Shell Programming and Scripting

#!/bin/sh
echo "DB2 INSTANCE PROFILER UTILITY"
echo "1 = DTRND1"
echo "2 = SCGND1"
echo "3 = SCGND2"
echo "4 = SCGND3"
echo "5 = DTRNL1"
echo "6 = SCGNL1"
echo "7 = SCGNL2"
echo "8 = SCGNL3"
echo "Please enter the number of the instance you want to profile:\c"
read name

case $name in
 "1") . /dbhome/dtrnd1/sqllib/db2profile
      db2 get instance;;
 "2") . /dbhome/scgnd1/sqllib/db2profile
      db2 get instance;;
 "3") . /dbhome/scgnd2/sqllib/db2profile
      db2 get instance;;
 "4") . /dbhome/scgnd3/sqllib/db2profile
      db2 get instance;;
 "5") . /dbhome/dtrnl1/sqllib/db2profile
      db2 get instance;;
 "6") . /dbhome/scgnl1/sqllib/db2profile
      db2 get instance;;
 "7") . /dbhome/scgnl2/sqllib/db2profile
      db2 get instance;;
 "8") . /dbhome/scgnl3/sqllib/db2profile
      db2 get instance;;

     *) echo "Your did not pick a valid instance";;
esac

#!/bin/sh
echo "DB2 INSTANCE PROFILER UTILITY"
ilist=$(db2ilist)
i='0'

for instance in $ilist
do
i=`expr $i + 1`
echo $i " = " $instance



done

#!/bin/bash
INSTANCE=""
while [[ $INSTANCE = "" ]]; do
    echo "DB2 INSTANCE PROFILER UTILITY"
    echo "Please enter the number of the instance you want to profile:"
    select INSTANCE in $(db2ilist); do
         if [[ $INSTANCE = "" ]]; then
              echo "Please enter a valid number. Retry."
         else {
              . /dbhome/${INSTANCE}/sqllib/db2profile
              db2 get instance; }
          fi
          break
          done
     done
exit 0

#!/bin/ksh

typeset -i iCnt=0
typeset    chInstance=""
typeset -u chUInst=""
typeset -i iSelect=0
typeset    chSelect=""

(( iCnt = 1 ))
db2ilist | while read chInstance ; do
     achInstName[$iCnt]="$chInstance"
     (( iCnt += 1 ))
done

tput clear
print - "Enter the corresponding number to start the instance:\n"
(( iCnt = 1 ))
while [ $iCnt -le ${#achInstName[*]} ] ; do
     chUInst="${achInstName[$iCnt]}"
     printf "%2d)  %15s\n" "$iCnt" "$chUInst"
     (( iCnt += 1 ))
done
print - "\n\n      Enter your pick (0 to abort) ==>"
read chSelect

if [ "$(print - $chSelect | tr -d '0-9')" != "" ] ; then
     print -u2 "Error: only the given numbers or 0 as input allowed." 
     exit 1
else
     iSelect=$chSelect
fi

if [ $iSelect -eq 0 ] ; then
     print -u2 "User selected abort, exiting..."
     exit 0
fi

if [ $iSelect -le ${#achInstName[*]} ] ; then
     . /dbhome/${achInstName[$iSelect]}/sqllib/db2profile
     db2 get instance
else
     print -u2 "Error: User entered an invalid pick number. Exiting."
     exit 1
fi

exit 0