How to put database connection check validation in Unix shell script

Question

I have created shell script for connection database.

#------------------------------------------------------------------------------------------
# Declaring a variable used in this program
#------------------------------------------------------------------------------------------
Databasename="XYZ"
#------------------------------------------------------------------------------------------
# ************************** MAIN PROGRAM STARTS ******************************************
#------------------------------------------------------------------------------------------

cd $SCRIPT_PATH

db2 connect to $Databasename

touch $UserId $RoleName $MCD_Prod

echo "UserId" > $UserId

echo "RoleName" > $RoleName

db2 -x "Select A.USER_ID from USER A ,ROLE_TYPE R, USER_ROLE U where A.USER_ID=U.USER_ID AND U.ROLE_ID=R.ROLE_ID" >> $UserId

db2 -x "Select R.ROLE_NM from USER A ,ROLE_TYPE R, USER_ROLE U where A.USER_ID=U.USER_ID AND U.ROLE_ID=R.ROLE_ID order by A.USER_ID" >> $RoleName
-------------------------------------------------------------------------------

i have made database validation when i select * in database an connection not found.

But if the database name is incorrrect from "XYZ" to "XYZ1" , database could not connect but program terminate here only..

I need to put validation ..Please help

Is their is any way in shell script where i can check ..is database is connected succufully or not and determinate program here only if not connected — user2197712
– user2197712, Commented Aug 27, 2013 at 6:18

OkieOth · Accepted Answer · 2013-08-27 06:28:30Z

1

Try it with the following code ...

if ! db2 -x "Select A.USER_ID from USER A ,ROLE_TYPE R, USER_ROLE U where A.USER_ID=U.USER_ID AND U.ROLE_ID=R.ROLE_ID" >> $UserId
then
  echo "there was an error, maybe the connection failed
fi

answered Aug 27, 2013 at 6:28

OkieOth

3,7642 gold badges24 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to put database connection check validation in Unix shell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related