Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2016
    Posts
    8

    Unanswered: resizing a DB2 tablespace

    Gurus,

    Please find below my current 'tablespace' utilization:
    ID NAME PAGE_SIZE TOTAL_PAGES USED_PAGES FREE_PAGES PERCENT_USED N_CONTAINERS
    --------- --------------- ------------ ----------- ----------- ----------- ------------ ------------
    2 USERSPACE1 4096 335872 328864 7008 97.91% 1
    0 SYSCATSPACE 4096 16384 15228 1156 92.94% 1
    3 SYSTOOLSPACE 4096 8192 168 8024 02.05% 1

    Please guide me on how to resize (for USERSPACE1 and SYSCATSPACE) affected tablespace in order to
    maintain within our 80% utilization threshold.

    Thank you very much!

  2. #2
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27

  3. #3
    Join Date
    Feb 2016
    Posts
    8
    Thanks for this db2mor!

    Sorry to forgot that I'm a newbie in DB2 administration.
    I just want to clarify if a certain tablespace had its setting of "Using automatic storage" and "Auto-resize enabled" equals to YES, do I need to resize/extend its size?

    Thanks again.

  4. #4
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    If the tablespace uses automatic storage , and tablespace can grow automatically , then verify that the file-systems hosting the containers for these tablespaces are appropriately sized also.

  5. #5
    Join Date
    Feb 2016
    Posts
    8
    Thanks for this.

    Can you guide me on this? Btw, our DB2 version is 9.5.4 running in RHEL 5.2.

    Regards,

  6. #6
    Join Date
    Feb 2016
    Posts
    8
    db2mor,

    Here is the size of the dB2 database:
    call get_dbsize_info(?,?,?,0)

    Value of output parameters
    --------------------------
    Parameter Name : SNAPSHOTTIMESTAMP
    Parameter Value : 2017-05-25-08.11.04.263185

    Parameter Name : DATABASESIZE
    Parameter Value : 13,057,253,376

    Parameter Name : DATABASECAPACITY
    Parameter Value : 407,443,654,653

    Return Status = 0

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
  •