We had to do it. I suggest doing the rebalances one at a time, or if you aren't in a hurry, once a day as you will see quite a bit of IO. The reduce max are instantaneous and I wouldn't feel bad running them one right after the other. Other than that, we did not have any problems and the DB has remained balanced afterwards.
--------------------------------------------------- David Nixon System Programmer II Technology Services Group Carilion Clinic 451 Kimball Ave. Roanoke, VA 24015 Phone: 540-224-3903 [email protected] Our mission: Improve the health of the communities we serve. ________________________________________ From: ADSM: Dist Stor Manager [[email protected]] on behalf of David Ehresman [[email protected]] Sent: Monday, February 22, 2016 10:14 AM To: [email protected] Subject: [ADSM-L] Rebalance the TSM DB filespaces 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 ________________________________ Notice: The information and attachment(s) contained in this communication are intended for the addressee only, and may be confidential and/or legally privileged. If you have received this communication in error, please contact the sender immediately, and delete this communication from any computer or network system. Any interception, review, printing, copying, re-transmission, dissemination, or other use of, or taking of any action upon this information by persons or entities other than the intended recipient is strictly prohibited by law and may subject them to criminal or civil liability. Carilion Clinic shall not be liable for the improper and/or incomplete transmission of the information contained in this communication or for any delay in its receipt.
