Determine the size of a DB2 table

bustacap · #1 (**permalink**) 10-03-07, 11:19

Hi there,

We are using DB2 version 8 fixpack 10 on AIX. All table spaces are SMS, actuall... we just have 1 tablespace that contains all the tables. How do I determine the physical size of just one of the tables in the tablespace? I believe I can use db2 inspect but that takes a very long time on a large database. Just wondering if there was an easier way? Thanks.

n_i · #2 (**permalink**) 10-03-07, 13:14

Code:

D:\>db2 get snapshot for tables on ???

            Table Snapshot

First database connect timestamp     = 10/01/2007 13:38:13.188694
Last reset timestamp                 =
Snapshot timestamp                   = 10/03/2007 13:03:40.319739
Database name                        = ???
Database path                        = D:\DB2\NODE0000\SQL00001\
Input database alias                 = ???
Number of accessed tables            = 62

Table List
 Table Schema        = SYSIBM
 Table Name          = SYSTABLES
 Table Type          = Catalog
 Data Object Pages   = 155
 Index Object Pages  = 71
 LOB Object pages    = 5376
 Rows Read           = Not Collected
 Rows Written        = 1156
 Overflows           = 6546
 Page Reorgs         = 0

bustacap · #3 (**permalink**) 10-03-07, 14:00

Thanks a lot! Now I just have to figure out how big a disk page is.

n_i · #4 (**permalink**) 10-03-07, 14:53

It's not a disk page, it's the tablespace page.

Code:

select tabschema, tabname, pagesize 
from syscat.tables t, syscat.tablespaces s 
where t.tbspaceid = s.tbspaceid

bustacap · #5 (**permalink**) 10-03-07, 16:04

Thanks for clearing that up! I was looking at this document and it referred to it as a "disk page". Oh well...

http://publib.boulder.ibm.com/infoce...n/r0011337.htm

Thanks again!

rubystep · #6 (**permalink**) 10-09-07, 17:39

How about REORGCHK UPDATE STATISTICS ON TABLE schema.table and check the TSIZE column for the table?

Internet Services

Web Development

Digital Marketing

Consumer Tech