Hi all,
After the creation of blank database in db2, how we come to know the actual space used by that database?
as i din't had any idea, i just took the backup of that blank database n checked the size in the properties of the backup file, which says its 20 MB...is this the right way to know?

you can try this command to get the szie of the database

select * from systools.stmg_dbsize_info

the following exception is thrown when i execute the command

SQL0204N "SYSTOOLS.STMG_DBSIZE_INFO
" is an undefined name.

first connect to database....then run below procedure
db2 "call get_dbsize_info(?,?,?,0)"

Which DB2 version on which platform?

m using DB2 v8.1 on windows XP.

after executing the command:
'db2 call get_dbsize_info(?,?,?,0)'
it is throwing this error:
SQL04404 no authorized routine named "GET_DBSIZE_INFO" of type "procedure" having compatible arguments was found.

n after runnig this command:
'select * from systools.stmg_dbsize_info'
it is throwing this error:
SQL0204N "systools.stmg_dbsize_info " is an undefined name.
I can also not find any schema in my database with name systools.

That SP was introduced in approximately FP 9 of 8.1 (which is the same as 8.2.2). Fixpacks are free to download from the IBM site and the latest for vesion 8 is FP 16.

Well if you have control center then the total db size is displayed whenever you select any database....

This will help U....check this
db2 "select TABLESPACE_ID,CONTAINER_TYPE,TABLESPACE_NAME,TOTAL _PAGES,USABLE_PAGES,(TOTAL_PAGES-USABLE_PAGES) as FREEPAGES from table(SNAPSHOT_CONTAINER('SIDRKMG',-1)) as sample"

hi marcus,

thanks! i upgraded to v9 n now i can see the SP with name get_dbsize_info.

nick,
i din't found any db information when i select the database. just let me know where exactly i will find that info.

DB2learner,
din't understood the command u suggested to execute.