Re. Sblob space

Posted in 2007

Sushil Shirodkar — Wed, 21 Nov 2007 20:33:12 — source: IIUG Forums & Mailing Lists

Hello Everybody, For normal dbspace I can run the following query to find the details. SELECT DBINFO("DBSPACE", partnum) dbspace, tabname FROM systables WHERE DBINFO("DBSPACE",partnum)='xyz' AND tabtype = "T" AND tabid > 99 ORDER BY 1,2 ; 1: How to see the contents of the sblob space. 2: How do I tell what tables used up the space on a specific day. Thanks, Sushil.. _________________________________________________________________ Connect and share in new ways with Windows Live. http://www.windowslive.com/connect.html?ocid=TXT_TAGLM_Wave2_newways_112007