#! /bin/sh
echo “”
echo “”
echo “List DB2 instances & databases”
DB2_INSTALL_PATH=/opt/ibm/db2/V10.1
. /etc/init.d/functions
list_instances() {
$DB2_INSTALL_PATH/bin/db2greg -dump | grep -E ‘^I,DB2’ | \
cut -d, –output-delimiter=” ” -s -f4,5,7
}
#read DB2 instances from the global registry
list_instances | while read INST INSTDIR AUTOSTART
do
if [ $AUTOSTART -eq 1 ]
then
echo “—————————-“
echo “DB2 Instance: $INST”
su – $INST -c “$INSTDIR/bin/db2 list db directory” | grep Indirect -B 5 | grep “Database alias” | awk {‘print $4’} | sort -u | uniq | while read line
do
echo “Database: $line”
done
fi
done
echo “”
echo “”
Visits: 218