Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    136

    Unanswered: database capacity issue..

    Hi,
    db2 “call get_dbsize_info(?,?,?,1)”
    When above statement is executed I got below output

    Value of output parameters
    --------------------------
    Parameter Name : SNAPSHOTTIMESTAMP
    Parameter Value : 2008-03-26-12.14.44.187000

    Parameter Name : DATABASESIZE
    Parameter Value : 23191552


    Parameter Name : DATABASECAPACITY
    Parameter Value : 11580578304

    Return Status = 0

    It shows database capacity around 10 G??????
    but my free disk space is 2.7G
    Full disk space is 12 G
    Used disk space is 8.3 G

    When free disk space is only 2.7G then how it can show database capacity around 10 G?????????????????????????????????

    Thanks
    Pawan

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I am fairly certain that maximum capacity is not based on the HD size but on the number and pagesize of your tablespaces.

    Andy

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Your numbers on the disk space do not line up: Free disk space + used disk space = 11 GB in your case - but you state you have 12 GB.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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