Increase Database

cwb

ADSM.ORG Member
Joined
Oct 28, 2008
Messages
47
Reaction score
0
Points
0
PREDATAR Control23

Hi my friends - i have one question.

I have a tsm server 6.3 - and database was fragmented,

My question is - if database04 become 100% , TSm server go down. (halt).

How i can distribute all data for to equalize?

its possible.

thanks


/tsm/database01 256,000.00 238,649.44 17,350.56
/tsm/database02 256,000.00 238,649.44 17,350.56
/tsm/database03 256,000.00 238,649.43 17,350.57
/tsm/database04 254,976.00 250,351.65 4,624.35
/tsm/database05 256,000.00 238,632.71 17,367.29
/tsm/database06 256,000.00 238,632.68 17,367.32
/tsm/database07 256,000.00 238,632.70 17,367.30
/tsm/database08 252,928.00 238,632.18 14,295.82
 
PREDATAR Control23

Just one thing to remember:

If the TSM server running right now was upgraded from an earlier version like 6.2 or 6.1 which runs on DB2 V9.5 (6.3 is DB2 V9.7), the standard procedure may not work until you have converted the DB2 from 9.5 to 9.7.

You have to contact IBM for this since the procedure is dependent on your environment.

I am in this situation but haven't, to date, updated from 9.5 to 9.7.
 
PREDATAR Control23

thanks LED 888 , its works ...
now volumes are the same size...
 
PREDATAR Control23

I have a similar question/scenario to this if I may...

If an AIX TSM Server 6.3.x has maxed out it's available DB volumes how would it be best to get the Server back up and running again under the following options..

/tsm/db001 - 50Gb
/tsm/db002 -- 50Gb
/tsm/db003 - 50Gb
/tsm/db004 - 50Gb
/tsm/db005 - 50Gb
/tsm/db006 - 50Gb
/tsm/db007 - 50Gb
/tsm/db008 - 50Gb

All of the above are full...

2 new physical disks are provisioned and are being presented to the AIX TSM Server.

Can you...

1. Span the new available space across the current 8 db directories equally, thus retaining their equal allocation by extending each one? [Restart TSM after the extending is complete]
or
2. Create /tsm/db009 - 50GB from the new disk allocation and use the 'extend db' cmd to make TSM use the new directory [How can you achieve this is you cannot get to the TSM cmd prompt]?

Cheers
 
PREDATAR Control23

Ok, found an answer to option 2. [dependant on at least 200MB space free] :eek:


http://www-01.ibm.com/support/docview.wss?uid=swg21662954

So is option 1 really a viable option or would people tend not to venture down that road, as its most likely not the IBM way to do it? I've seen it done and succeed at a devclass directory level so why wouldn't it work within a similar directory structure at the db2 level?

Cheers
 
PREDATAR Control23

Option 1 is the best option because DB2 doesn't need to rebalance the database if you extend all the filesystem by the same size.

Option 2 is valid too, but the database needs to be rebalanced.

If you look at the Blueprint for Spectrum Protect, they recommend 8 directories for the database for up to 4TB. You are far from that. Also, there is no considerable performance improvement with going above 8 directories for the DB. So since you already have 8 directories, I'd go with Option 1.
 
PREDATAR Control23

Option 1 is the best option because DB2 doesn't need to rebalance the database if you extend all the filesystem by the same size.

Option 2 is valid too, but the database needs to be rebalanced.

If you look at the Blueprint for Spectrum Protect, they recommend 8 directories for the database for up to 4TB. You are far from that. Also, there is no considerable performance improvement with going above 8 directories for the DB. So since you already have 8 directories, I'd go with Option 1.


Brilliant, thanks Marclant.

Is your suggestion for option 1 still sound regardless of what version of db2 you're on or if the TSM Server has been upgraded from 6.1 > 6.3.x and the db2 version is still at the older 9.5 version?

Thanks fella.
 
PREDATAR Control23

Brilliant, thanks Marclant.

Is your suggestion for option 1 still sound regardless of what version of db2 you're on or if the TSM Server has been upgraded from 6.1 > 6.3.x and the db2 version is still at the older 9.5 version?

Thanks fella.
Even more so because the rebalancing is a manual process at older verions of DB2 making Option 1 even more appealing.
 
Top