There are two additional tablespaces if you use node replication:
db2 alter tablespace REPLTBLSPACE1 rebalance
db2 alter tablespace REPLIDXSPACE1 rebalance

and the related reduce max commands for them.

Some of the tablespaces provided by Bill's db2 select do not allow a rebalance. 
 The names implying temporary space: TEMPSPACE1, TSMTEMP, LGTMPSP and 
SYSTOOLSTMPSPACE.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
William Sefranek
Sent: Monday, February 22, 2016 9:48 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Rebalance the TSM DB filespaces

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-databa
> se-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

[Confidentiality notice:]
***********************************************************************
This e-mail message, including attachments, if any, is intended for the
person or entity to which it is addressed and may contain confidential
or privileged information.  Any unauthorized review, use, or disclosure
is prohibited.  If you are not the intended recipient, please contact
the sender and destroy the original message, including all copies,
Thank you.
***********************************************************************