Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2016

    Unanswered: how to check the current and allocated size of a database in DB2


    We are newbie in DB2 administration, can you assist us on what particular commands needed to extract the actual size of our DB2 (Linux 2.6.18-92.el5 x86_64; DB2 v9.5.0.4-REL# 06050107) database plus its allocated size... I'm attaching a screenshot of commands we've executed and 2 from these had different output:
    1. yellow highlight (via Unix prompt), size = 11Gb
    2. green highlight (db2 sql), size = 9.9Gb
    3. blue highlight (db2 sql), size = 1.15Gb
    4. pink highlight (db2 sql), size = 9.9Gb
    5. orange highlight (db2 sql), size = 9.9Gb

    Thank you and best regards,
    Attached Thumbnails Attached Thumbnails db2_forum.jpg  
    Last edited by ReyM21; 02-17-16 at 23:44. Reason: product/OS version not stated

Tags for this Thread

Posting Permissions

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