1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

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,608
    Likes Received:
    370
    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