Results 1 to 3 of 3

Thread: DB size info

  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: DB size info

    Hi Everyone,

    One of SAMPLE database size is as below

    Code:
    C:\Program Files\IBM\SQLLIB\BIN>db2 call get_DBSize_info(?,?,?,0)
    
      Value of output parameters
      --------------------------
      Parameter Name  : SNAPSHOTTIMESTAMP
      Parameter Value : 2009-03-30-11.38.23.129000
    
      Parameter Name  : DATABASESIZE
      Parameter Value : 57282560
    
      Parameter Name  : DATABASECAPACITY
      Parameter Value : 38995476992
    
      Return Status = 0
    
    
    C:\Program Files\IBM\SQLLIB\BIN>
    DB2 V9.1 on Win 2k3

    I need free space on this server. So I can drop SAMPLE database for space.

    How much space will I gain if I drop SAMPLE.


    Thanks
    DBFinder

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Looks like about 57 MB.

    The DATABASECAPACITY takes into account the size of the entire file system for SMS tablespaces.
    Last edited by Marcus_A; 03-30-09 at 14:28.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks,

    I had misunderstanding about DATABASECAPACITY.


    DBFinder

Posting Permissions

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