query to get DBSPACE information

Posted in 2006

Topics: Storage & Space Management, SQL Development & Query Writing

DEBA mishra — Mon, 04 Sep 2006 05:53:47 — source: IIUG Forums & Mailing Lists

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

↪ replying to DEBA mishra

John Miller iii — Mon, 04 Sep 2006 06:15:47 — source: IIUG Forums & Mailing Lists

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.

↪ replying to DEBA mishra

Keith Simmons — Tue, 05 Sep 2006 07:39:15 — source: IIUG Forums & Mailing Lists

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. > >

↪ replying to DEBA mishra

Richard Snoke — Tue, 05 Sep 2006 13:22:02 — source: IIUG Forums & Mailing Lists

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.

Glossary

dbspace