Oninit cdi / Archive
Talk to an expert →

Re: Which table is in which dbspace?

Posted in 2000

Topics: Storage & Space Management, Versions, Editions & End-of-Life

↪ replying to Obnoxio The Clown
Sally Woolrich — — source: Informix-list mailing list archive (1991-1998)

I've had several answers by email of which the following is the most elegent for my purposes: select dbinfo ('dbspace', partnum), tabname from systables where tabid > 99 and tabtype = "T" and dbinfo ('dbspace', partnum) != 'database_dbs' order by 2 With the above it is necessary to only pick up tables, not views or synonyms, and in my case I want to know about the exceptions not the normal case. Thanks to whoever 'eformix@hotmail.com' really is. On Mon, 11 Sep 2000 15:27:44 +0100, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > >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.

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

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.

Glossary