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 -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Janet Graff Sent: donderdag 11 februari 2016 7:07 To: [email protected] 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 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 tables are allocated in? Thank you! Janet ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
