DB size info

DBFinder · #1 (**permalink**) 03-30-09, 11:51

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