check if database server is running

[holdahl]

I want to write a script that check if a sybase ase server is up and running (that you can connect to it)
Trying to do a ps -ef and grep for dataserver will show the process of the server but it seems like this process is displayed before the server is ready for connections.

Any suggestions?



-holdahl

 

[dbalearner]

You can test it in UNIX script as follows:

isql -U${USERNAME} -P${PASSWORD} -S${SQL_SERVER} -w1000 << ! > ${LOG_FILE}
exit
!
if [[ $? != 0 ]]
then
msg="`date` ${SQL_SERVER} problem. ${SQL_SERVER} on ${HOST} is down or cannot be accessed"
cat ${LOG_FILE}|/usr/bin/mailx -s "${msg}" ${SUPPORT}
}
exit 1
fi

HTH