Storage group for a TS name

harishch_ch · New User Joined: 07 Jan 2008 Posts: 27 Location: bangalore

Hi,

May i know, how can i find the Storage group for a TS name or for a particular table?

Which SYSIBM table?

Regards,
Harish.

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

Are you looking for

SYSIBM.SYSSTOGROUP

harishch_ch · New User Joined: 07 Jan 2008 Posts: 27 Location: bangalore

I am looking to find the storage group for a particular table or table space name.

In SYSIBM.SYSSTOGROUP table i am not able to find the above.

Regards,
Harish.

enrico-sorichetti · Posted: Fri Nov 28, 2008 5:43 pm

gentlemen a bit of ingenuity ...
a simple search wit "SYSIBM.SYSTABLESPACE" and/or "SYSIBM.SYSTABLES" gave this ...

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sysibmsystablestable.htm
and this....
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sysibmsystablespacetable.htm
and this...
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sysibmsysdatabasetable.htm