Re: [ADSM-L] Rebalance the TSM DB filespaces
2016-02-22 10:46:11
David,
We have performed the DB rebalance a few times without issue and we have
run all the tablespaces at the same time. But we have our
TSM databases on Raid 10 disks on a Hitachi storage array. You might
want to break up the rebalances by running each tablespace individually
if you are using slower storage.
Also you can use this query to monitor the number of DB extents left to
rebalance for each tablespace.
db2 "select varchar(tbsp_name, 30) as tbsp_name, dbpartitionnum,
rebalancer_mode, rebalancer_extents_remaining,
rebalancer_extents_processed, rebalancer_start_time from
table(snap_get_tbsp_part_v91(NULL,-2)) as t"
The rebalance process is complete when the columns under REBALANCER_MODE
= NO_REBAL
Thanks,
Bill
On 2/22/2016 10:14 AM, David Ehresman wrote:
The tsmtutorials.com web page says you can rebalance space usage after adding a
new DB filespace by issuing the following commands:
* Perform the rebalance activity during a quiet time. Logon as the server
instance owner and execute the DB2 commands below. (on Windows, you need to run
these commands from a DB2 Command Window and "set db2instance=server1).
db2 connect to tsmdb1
db2 set schema tsmdb1
db2 alter tablespace SYSCATSPACE rebalance
db2 alter tablespace USERSPACE1 rebalance
db2 alter tablespace LARGESPACE1 rebalance
db2 alter tablespace LARGEIDXSPACE1 rebalance
db2 alter tablespace IDXSPACE1 rebalance
db2 alter tablespace SYSTOOLSPACE rebalance
* Depending on the size of the tablespace, the rebalance can take some
time to finish. For a large tablespace, the rebalance can take about 30
minutes. Run the following command to check the rebalance status
db2 "select * from SYSIBMADM.TBSP_UTILIZATION " |grep -i progress
* If the rebalance is still active, the above command will return the
tablespace still in active resizing. Wait until all tablespaces have done the
rebalance and execute the following commands to reduce the tablespaces
db2 alter tablespace SYSCATSPACE reduce max
db2 alter tablespace USERSPACE1 reduce max
db2 alter tablespace LARGESPACE1 reduce max
db2 alter tablespace LARGEIDXSPACE1 reduce max
db2 alter tablespace IDXSPACE1 reduce max
db2 alter tablespace SYSTOOLSPACE reduce max
* After the rebalance/reduce, the file systems should be equally utilized
and there are should be no more file systems in 100% full condition.
- See more at:
http://www.tsmtutorials.com/2014/04/how-to-rebalance-tsm-server-database-tablespaces.html#sthash.pr2hDMzv.dpuf
Has anyone had this work for them? Anything to watch out for?
David
--
William Sefranek
University of Buffalo
Enterprise Infrastructure Services
(716)645-5116
|
|
|