How to increase the db size in TSM 6.3 Linux server

[frankantony]

Hi All,

I have a clarification on extending db space. Can you please advise how to increase db size in linux TSM server.


Thanks,
Frank.

 

[marclant]

Hi,

It's easy, you just need to add database directories, on new disk obviously: https://ibm.biz/BdRAXS

Note that will increase the database, but will not rebalance it across all directories(disk), which means you will benefit from the added space immediately, but only benefit from the parallel I/O performance over time. So you can follow these steps if you want to rebalance it immediately, rather than let it happen slowly over a longer period of time: https://ibm.biz/BdRAXa

Marc...

 

[frankantony]

Hi,

It's easy, you just need to add database directories, on new disk obviously: https://ibm.biz/BdRAXS

Note that will increase the database, but will not rebalance it across all directories(disk), which means you will benefit from the added space immediately, but only benefit from the parallel I/O performance over time. So you can follow these steps if you want to rebalance it immediately, rather than let it happen slowly over a longer period of time: https://ibm.biz/BdRAXa

Marc...

Hi Marc,

Can't we increase the existing files online to extend the db space. Please advise.

\tsmdb001
\tsmdb002
\tsmdb003

 

[marclant]

Hi Frank,

In 6.x/7.x, we do not format files and assign them to the DB. We just give it directories and DB2 adds 512MB files as needed to those directories. That's why the directories have to be on different filesystems, otherwise it does not give you more space, just more directories. If the 3 directories you listed are 3 different filesystems, then yes you can extend the DB online.

The only thing that needs to be done offline is if you want to manually redistribute the database evenly across all directories after adding the space, as opposed to let it occur naturally which can take several weeks or more. You will not take a performance hit by not redistributing it, but you will not see the performance gain immediately either.

Marc...

 

[frankantony]

Hi Frank,

In 6.x/7.x, we do not format files and assign them to the DB. We just give it directories and DB2 adds 512MB files as needed to those directories. That's why the directories have to be on different filesystems, otherwise it does not give you more space, just more directories. If the 3 directories you listed are 3 different filesystems, then yes you can extend the DB online.

The only thing that needs to be done offline is if you want to manually redistribute the database evenly across all directories after adding the space, as opposed to let it occur naturally which can take several weeks or more. You will not take a performance hit by not redistributing it, but you will not see the performance gain immediately either.

Marc...

Thanks Marc. I will extend the file systems online .

Thanks,
Frank