Which table is in which dbspace?
Sally Woolrich needed SQL listing which table is in which dbspace on IDS 7.30.UC3. She then found an answer in the IIUG archives herself. A poster suggested querying sysmaster with dbinfo('DBSPACE', partnum) against systabnames, and Jacob Salomon recommended his partitions.sh script from the IIUG library. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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.
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.
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.