How can I get the total/used database disk size?

Shyckymn · #1 (**permalink**) 03-15-07, 15:46

I've tried CALL GET_DBSIZE_INFO(?, ?, ?, -1) without success.

Any tips?

Best regards.

Marcus_A · #2 (**permalink**) 03-15-07, 16:52

You need to be at the proper fixpack level. You may need 8.1 FP9 or higher is needed (but not sure). It definitely works on 8.1 FP10. Make sure you connect to a database before issuing the call.

grofaty · #3 (**permalink**) 03-16-07, 02:14

Hi,

I have executed command on test computer on db2 v8 fp9 and I got bellow result:

Code:

 Value of output parameters
 --------------------------
 Parameter Name  : SNAPSHOTTIMESTAMP
 Parameter Value : 2007-03-16-07.12.30.446061

 Parameter Name  : DATABASESIZE
 Parameter Value : 1769635840

 Parameter Name  : DATABASECAPACITY
 Parameter Value : 6297561600

 Return Status = 0

What is the difference between DATABASESIZE and DATABASECAPACITY?

Thanks,
Grofaty

grofaty · #4 (**permalink**) 03-16-07, 02:24

Hi,
I have found info about GET_DBSIZE_INFO.

DATABASESIZE = current database size
DATABASECAPACITY = maximum possible size ob database (dependent to disk space).

This is useful command. I needed this info multiple times and alway it was debate how to calculate database size. Now I have benchmark value.

Thanks,
Grofaty

rahul_s80 · #5 (**permalink**) 03-16-07, 05:17

8.2.7 on windows

U can see it in Control Center
Just connect to a DB and in the object details pane U can see the size and capacity of DB.
check if ur version supports that

Shyckymn · #6 (**permalink**) 03-16-07, 08:09

Mv DB2 version is 7.2.8.
How can I get the information?
I don't have the SYSTOOLS.STMG_DBSIZE_INFO table.
By the way, there's no any table for the SYSTOOLS schema...

Wim · #7 (**permalink**) 03-16-07, 09:25

Does this also include BLOB's ?

stolze · #8 (**permalink**) 03-16-07, 16:31

Version 7 is out of service for more than a year already. You may want to move to V8 or better yet V9.

What are you referring to with the "SYSTOOLS" schema?

grofaty · #9 (**permalink**) 03-20-07, 09:19

Quote:

Originally Posted by Shyckymn

Mv DB2 version is 7.2.8.
How can I get the information?

Hi,
I don't see any option beside calculating in by yourself. If you follow my link few posts above, you can do manually what store procedure GET_DBSIZE_INFO does.

Hope this helps,
Grofaty

Internet Services

Web Development

Digital Marketing

Consumer Tech