#!/bin/sh
db2 -x connect to tsmdb1
db2 -x set schema tsmdb1
db2 -x "select substr(tbspace,1,20) from syscat.tablespaces where tbspacetype='D'" | while read TBS; do
# Vagy: db2 list tablespaces show detail | grep -p 'Database managed space' | awk '/Name.*=/{print $3}'
        db2 -x connect to tsmdb1 > /dev/null
        db2 -x set schema tsmdb1 > /dev/null
        echo
        echo "$TBS:"
        echo '- Rebalance...'
        db2 alter tablespace $TBS rebalance
        while [[ $(db2pd -utilities | grep -c REBALANCE) -gt 0 ]]; do
                printf "."
                sleep 60
        done
        echo
        echo '- Reduce max...'
        db2 alter tablespace $TBS reduce max
        echo
        echo
        db2 connect reset > /dev/null
done