Oninit cdi / Archive
Talk to an expert →

Which table is in which dbspace?

Posted in 2000

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

Sally Woolrich — — source: Informix-list mailing list archive (1991-1998)

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

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

On Mon, 11 Sep 2000 12:15:34 +0100, sally.woolrich@comino.com (Sally Woolrich) wrote: > > >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 I found the answer for myself in the IIUG archives and adapted it to my needs.

↪ replying to Sally Woolrich
gorgos@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

In article <39bcbe7f.3738866@comino-leeds>, sally.woolrich@comino.com (Sally Woolrich) wrote: > > > 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 > > dbaccess sysmaster <<! select dbinfo("DBSPACE",partnum) dbspace,tabname from systabnames order by 1,2; ! Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Sally Woolrich
Jacob Salomon — — source: Informix-list mailing list archive (1991-1998)

In article <39bcdde6.11779467@comino-leeds>, sally.woolrich@comino.com (Sally Woolrich) wrote: > On Mon, 11 Sep 2000 12:15:34 +0100, sally.woolrich@comino.com (Sally > Woolrich) wrote: > > > > > > >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 > > I found the answer for myself in the IIUG archives and adapted it to > my needs. Great for you. I know there are many ways to do this but I'll plug my own solution, which answers your question and some others: partitions.sh, which is available in the IIUG library. -- +----- Jacob Salomon - DBA JSalomon@bn.com - --------------------------+ |------------------- Bulletin Board Announcement ----------------------| | Congregants will please note that the bowl at the back of the church | | bearing the sign "For the Sick" is for monetary contributions only. | +----------------------------------------------------------------------+ Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary