query to get DBSPACE information
Deba Mishra asked how to list the tables or databases in a dbspace. John Miller III suggested a query on sysmaster:systabnames filtering on the dbspace number from partnum. Keith Simmons recommended oncheck -pe. Richard Snoke gave an IDS 7.31 query joining systabnames, systabextents and syschktab to list tables by chunk, dbspace or device.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi can anybody help me with regard to this. How can i query for my DBSPACE to know which tables or databases it contains. is there any SQL query to run or any utility where i can get this information. Regards Deba
There are many ways to do this but using
the dbaccess utility against the sysmaster database
and running the following query.
select * from sysmaster:systabnames
where TRUNC(partnum/"0xFFFFF")=1 -- DBSPACE Number
John
Hi
can anybody help me with regard to this.
How can i query for my DBSPACE to know which tables or databases it
contains.
is there any SQL query to run or any utility where i can get this
information.
Regards
Deba
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Deba
oncheck -pe will provide the information in an easily digested form
Keith
On 04/09/06, DEBA mishra <mishra.dd@gmail.com> wrote:
>
> Hi
>
> can anybody help me with regard to this.
> How can i query for my DBSPACE to know which tables or databases it
> contains.
> is there any SQL query to run or any utility where i can get this
> information.
>
> Regards
> Deba
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
This works for IDS 7.31. I haven't adapted it for later releases. You
can adjust the predicate to get the tables in a chunk, a dbspace or a
whole device.
database sysmaster;
select distinct a.tabname
from systabnames a,
systabextents b,
syschktab c
where a.partnum = b.te_partnum and
c.chknum = physchunk(b.te_physaddr) and
c.fname like "/dev/rdsk/disk-1"
;
Cheers,
Dick Snoke
IBM Software Group - ChannelWorks
dsnoke@us.ibm.com
(404) 487-1595
"DEBA mishra" <mishra.dd@gmail.com>
Sent by: ids-bounces@iiug.org
09/04/2006 01:53 AM
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
query to get DBSPACE information [7412]
Hi
can anybody help me with regard to this.
How can i query for my DBSPACE to know which tables or databases it
contains.
is there any SQL query to run or any utility where i can get this
information.
Regards
Deba
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.