Re: List tables in dbspace through sysmaster query
My sincere apologies to AB. It was really careless on my part. But my
other comment still holds true about IIUG FAQ 8.6 needs correction.
Vivek Chaudhary
______________________________ Reply Separator _________________________________
Subject: Re: List tables in dbspace through sysmaster query
Author: a.blonde (a_blonde@mindless.com) at internet
Date: 5/22/00 2:03 AM
---- you wrote:
> This would not list any tables which are fragmented by "round robin",
> "expression" because systables has it's partnum as zero.
Of course it does Dude! Why didn't you read my answer, before attempting to shoo
t it down in flames?
It doesn't even mention systables. That would be silly as the question was about
a select on sysmaster!
> ---- you wrote:
> > Hi,
> >
> > I'm trying to find a way to list the tables located in a dbspace through a
> > query
> > against the sysmaster db. I'm sure it's possible, but I can't find a table
> > in sysmaster
> > containing the table to dbspace mapping. Anyone know how to list the
> > tables in a specific
> > dbspace through a query against the sysmaster database?
> >
> > Thanks,
> >
> > Jeff
> >
> > P.S. I am using informix 7.31UC5, I'm not sure if it matters.
>
> You can use this Dude:
>
> select dbsname, tabname
> from systabnames
> where dbinfo("dbspace", partnum) = "rootdbs">
> AB
> ----------------------------------------------------------------
> Get your free email from AltaVista at http://altavista.iname.com
>
AB
----------------------------------------------------------------
Get your free email from AltaVista at http://altavista.iname.com
In article <8gbrre$mvj$1@news.xmission.com>, Vivek.CHAUDHARY@st.com
writes
>
> My sincere apologies to AB. It was really careless on my part. But my
> other comment still holds true about IIUG FAQ 8.6 needs correction.
>
> Vivek Chaudhary
>
>
To what (I'm the FAQ maintainer),
Please give us a replacement.
>
>______________________________ Reply Separator _________________________________
>Subject: Re: List tables in dbspace through sysmaster query
>Author: a.blonde (a_blonde@mindless.com) at internet
>Date: 5/22/00 2:03 AM
>
>
> ---- you wrote:
>> This would not list any tables which are fragmented by "round robin",
>> "expression" because systables has it's partnum as zero.
>
>Of course it does Dude! Why didn't you read my answer, before attempting to shoo
>t it down in flames?
>
>It doesn't even mention systables. That would be silly as the question was about
> a select on sysmaster!
>
>> ---- you wrote:
>> > Hi,
>> >
>> > I'm trying to find a way to list the tables located in a dbspace through a
>> > query
>> > against the sysmaster db. I'm sure it's possible, but I can't find a table
>> > in sysmaster
>> > containing the table to dbspace mapping. Anyone know how to list the
>> > tables in a specific
>> > dbspace through a query against the sysmaster database?
>> >
>> > Thanks,
>> >
>> > Jeff
>> >
>> > P.S. I am using informix 7.31UC5, I'm not sure if it matters.
>>
>> You can use this Dude:
>>
>> select dbsname, tabname
>> from systabnames
>> where dbinfo("dbspace", partnum) = "rootdbs">>
>> AB
>> ----------------------------------------------------------------
>> Get your free email from AltaVista at http://altavista.iname.com
>>
>
>AB
>----------------------------------------------------------------
>Get your free email from AltaVista at http://altavista.iname.com
>
--
David Williams