size of db2 udb database

DeeBee2

is there a view or a table that i can query the total size of my
database (including the containers belonging to DMS and SMS
tablespaces)

Thanks & Regards,

Mar 20 '06 #1

Sun

if your using version 8.2, you can see that in Advance view of control
center.

otherwise, you can check the directory size from OS.

Mar 20 '06 #2

Ian

DeeBee2 wrote:

is there a view or a table that i can query the total size of my
database (including the containers belonging to DMS and SMS
tablespaces)

Thanks & Regards,

See SYSPROC.SNAPSHOT_TBS_CFG() table function.

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

Mar 20 '06 #3

Shashi Mannepalli

Check this stored procedure

get_dbsize_info
cheers....
Shashi Mannepalli

Mar 20 '06 #4

DeeBee2

how do i execute this procedure?

Mar 25 '06 #5

DeeBee2

shashi how do i execute get_dbsize_info ?

Rgds,

Mar 25 '06 #6