Unanswered: Need size of database ( 3 month's earlier )
We don't have any script through which I have saved earlier size of database.
Is there any complex query through which I can get the details of tablespaces growth like when it got altered or about SMS tablespace when size increased. So that I can have a reverse calculation like today database is of 100 GB and in last 3 months I have extended 20 GB then not accurate but near about size of database 3 months earlier was 80 GB.
[ for DMS tablespace I am able to find out details from command db2 -x "select CMD_TEXT from SYSIBMADM.DB_HISTORY where OPERATION='T' with ur " ]
if you did not capture/saved this info there is no possibility to track this back
schedule a daily get_db_size _info and save the data in a table
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be