Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2008
    Posts
    62

    Question Unanswered: Calculate DB size in DPF env

    Hello Experts,

    Is there any way like "get_dbsize_info" to calculate db size in DPF environment.

    Thanks


    Regards,
    Prashant

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    what version are you on? and why do you think the command is not available on dpf?

    To ensure that the data is returned by all partitions for a global table space snapshot, the database must be activated

    https://www-304.ibm.com/support/docv...id=swg1IY80746
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2008
    Posts
    62
    We are running on V9.5 FP6a.

    I was trying "get_dbsize_info" only from catalog node. It shows size of 70TB but actual db size is more than 160TB

    Thanks for reply.
    Last edited by prashant44; 12-05-11 at 21:42.

  4. #4
    Join Date
    Feb 2008
    Posts
    62
    Hi,

    Anybody has any idea on this.

    bash-3.2$ db2 "call get_dbsize_info(?,?,?,0)"

    Value of output parameters
    --------------------------
    Parameter Name : SNAPSHOTTIMESTAMP
    Parameter Value : 2011-12-06-23.29.14.134570

    Parameter Name : DATABASESIZE
    Parameter Value : 70372224860160

    Parameter Name : DATABASECAPACITY
    Parameter Value : -1

    Return Status = 0

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Did you activate the db?

    "To ensure that the data is returned by all partitions for a global table space snapshot, the database must be activated" as sathyaram_s mentioned.

  6. #6
    Join Date
    Feb 2008
    Posts
    62
    sorry for the delay.
    The database is already active and applications are running on it.

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Your catalog partition has 70TB of data? Verify the size reported by get_dbsize_info with your what's reported by db2pd -tablespaces from all partitions.

Posting Permissions

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