Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: db2 growth monitor

    Dear All,

    What is the db2 command to see the database growth last 5 month.

    I want it to see db growth each month.

    Regards,
    K.manikandan.

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    A very rough and simple approch:
    Monitory the size of your backup images thru time. They give a nice impression.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by dr_te_z
    Monitory the size of your backup images thru time. They give a nice impression.
    ... if they are not compressed or incremental.

    There is a storage management tool in DB2 Control Center. Alternatively, you can run the CAPTURE_STORAGEMGMT_INFO procedure manually on schedule and select information you need from the storage management tables. You will find more information in the manuals.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    do db2 list tablespaces show detail then for each tablespace do
    total pages X Page size.....Add up this value for all tablespaces and you'll have your db size

    or you can use the get_dbsize_info procedure...
    IBM Certified Database Associate, DB2 9 for LUW

Posting Permissions

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