I've been combing through the SYSIBM tables looking for this answer. I need
to figure out what STOGROUP my tables belong to. I realize SYSTABLES has
TSNAME to tell me what TABLESPACE the table belongs to. But I can't get from
TABLESPACE to STOGROUP. How do I figure out what STOGROUP my tabl
Behalf
Of Janet Graff
Sent: donderdag 11 februari 2016 7:07
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: What STOGROUP does a table belong to
I've been combing through the SYSIBM tables looking for this answer. I need
to figure out what STOGROUP my tables belong to. I realize SYSTABLES has
TS
Thanks Jan! I'll look into that.
Janet
>I think the column STORNAME in SYSTABLEPART is what you're looking for. This
>also implies that an entire tablespace doesn't necessarily reside in a >single
>storage group.
>Regards,
>Jan