How to know current DB2 database size

hoho · #1 (**permalink**) 09-30-04, 22:45

Hi,
Any body know how to get the DB2 database size currently allocated and used in the system(including tablespaces, active logs, db2 internal control files, etc...) ?

xcb7226 · #2 (**permalink**) 10-01-04, 03:39

Hallo,

on Unix you can find the specific SQLxxxxx :

db2 list db directory on <dir> |grep <dbname>

Then you can do :

du -k <dir>

Regards Will

hoho · #3 (**permalink**) 10-01-04, 03:50

This only list out the size of database directory only, how about all other table spaces?

xcb7226 · #4 (**permalink**) 10-01-04, 04:19

Hallo,

you should make a tablespace snapshot or

db2 connect to >db>
db2 list tablespaces show detail

Regards

Internet Services

Web Development

Digital Marketing

Consumer Tech