Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Unanswered: Need size of database ( 3 month's earlier )

    Hi All,

    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 " ]
    Last edited by niteshtheone; 04-01-15 at 18:43.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts