Re: Which table is in which dbspace?

Sorry. Now that I've tried this, this gives the database name, not the dbspace name. :-( I can't seeem to find the link between partnum and chknum/dbsnum. But since I'm still on leave, I don't really care. :-) From: "Obnoxio The Clown" <obnoxio@hotmail.com> > >select dbsname, >-- owner, > tabname, > te_extnum, > trunc((te_physaddr / 1048576)) chunk_num >-- te_pagenum, >-- te_size > from sysmaster:systabnames st, sysmaster:systabextents te >where te.te_partnum = st.partnum >order by chunk_num, dbsname, tabname, te_extnum> >according to <MATTHEWP@visa.com> > >:-) > >From: sally.woolrich@comino.com (Sally Woolrich) >> >>I need an SQL to print out (using names!) which table is in which >>dbspace: >> >> dbspace1 table1 >> dbspace1 table2 >> dbspace2 table3 >> dbspace3 table4 >> >>etc. >> >>I can't work out how to do it for myself, sadly, but I'm sure there's >>*someone*out there who does. >> >>Using IDS 7.30.UC3. >> >>TIA >> > >_________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > >Share information about yourself, create your own public profile at >http://profiles.msn.com. > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.