1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TSM DB extension question

Discussion in 'TSM Server' started by Alexxx, Sep 11, 2017.

  1. Alexxx

    Alexxx Active Newcomer

    Joined:
    Aug 17, 2010
    Messages:
    8
    Likes Received:
    0
    Hi All

    question regarding TSM DB, TSM DB Sits on two drives D & E of 100 GB size each,as there were only 10GB free space was left on both drives so we increased the size of D & E by 100GB each now, my questions is

    * when you run q dbspace, it shows 200 GB free space available however when you run q db, it has the same old total pages, usable pages, used pages and free pages..... so when the TSM useup the remaining free pages, is it gonna be extended automatically as there are 100 GB free space available on each drive now or we need run the command "extend dbspace D:,H: to extend the database.

    BTW we are running TSM 6.3.

    Thanks lots in Advance
     
  2.  
  3. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,533
    Likes Received:
    354
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    The number of pages is based on the number of database volumes (files) created on the filesystems already. As DB2 needs to create new volumes(files), you'll see the total number of pages go up.

    You only use extend dbspace if you add filesystems to the database, you do nothing in TSM if you extend the size of the filesystems outside TSM.
     
  4. Alexxx

    Alexxx Active Newcomer

    Joined:
    Aug 17, 2010
    Messages:
    8
    Likes Received:
    0
    Thanks heaps for the response/explanation, marclant. It really helped!
     

Share This Page