Report growth DB - TSM Server 6.3

[girreis]

Dear friends,


I would like to follow the growth of DB TSM Server, in daily and monthly report, I create? Wanted to use the SELECT command!


Thank you,


Ramon

 

[girreis]

Dear friends,


I would like to follow the growth of DB TSM Server, in daily and monthly report, I create? Wanted to use the SELECT command!


Thank you,


Ramon

nobody!

Ramon

 

[przemq]

nobody!

Ramon

from dsmadmc:

select cast(USED_DB_SPACE_MB/1024 as DECIMAL(5,2)) as DATABASE_SIZE_GB from db

from db2 commanline:

su instance_owner
db2 connect to tsmdb1
db2 "select cast(USED_DB_SPACE_MB/1024 as DECIMAL(5,2)) as DATABASE_SIZE_GB from tsmdb1.db"