Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Posts
    9

    Unanswered: How to know current DB2 database size

    Hi,
    Any body know how to get the DB2 database size currently allocated and used in the system(including tablespaces, active logs, db2 internal control files, etc...) ?

  2. #2
    Join Date
    Jun 2004
    Posts
    4
    Hallo,

    on Unix you can find the specific SQLxxxxx :

    db2 list db directory on <dir> |grep <dbname>

    Then you can do :

    du -k <dir>

    Regards Will

  3. #3
    Join Date
    Sep 2002
    Posts
    9
    This only list out the size of database directory only, how about all other table spaces?

  4. #4
    Join Date
    Jun 2004
    Posts
    4
    Hallo,

    you should make a tablespace snapshot or

    db2 connect to >db>
    db2 list tablespaces show detail

    Regards

Posting Permissions

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