size of db2 udb database

#1 (**permalink**) 02-27-2008, 06:26 AM

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,

#2 (**permalink**) 02-27-2008, 06:27 AM

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.

#3 (**permalink**) 02-27-2008, 06:27 AM

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

#4 (**permalink**) 02-27-2008, 06:27 AM

Check this stored procedure

get_dbsize_info

cheers....
Shashi Mannepalli

#5 (**permalink**) 02-27-2008, 06:31 AM

how do i execute this procedure?

#6 (**permalink**) 02-27-2008, 06:31 AM

shashi how do i execute get_dbsize_info ?

Rgds,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode