I am using DB2 (EE) 9.1 over RHEL 4.0. I would like to know the size of my database. Can anyone tell me the query to fire against catalog tables which will display complete database size, logs size, tablespace size ????

have a look at this page
http://publib.boulder.ibm.com/infoce...c/r0023485.htm
there are table functiuons that display db ts size info
the log can be retrieved from the db cfg setting also as query/table function

in version 9, we have a stored procedure named getdbsize\get_dbsize.....something of this kind, dont know the exact name for thr SP. i doubt if this SP is there in v8.
u can call this SP to find the db size

1) db2 "select (SUM(total_pages)*4)/1024.0/1024 TOTAL_ALLOCATED_SPACE_IN_GB from table (snapshot_tbs_cfg('dbname',-1)) TBS_SPCE"


2) db2 'call get_dbsize_info(?,?,?,1)'

Cheers
Sandy