Skip to main content

Posts

Showing posts from May, 2018

Unix Script 2- Check Health of Rep Server

echo "Enter Server Name: \c" read SERVER echo "User Name : \c" read User_Name echo "Enter Passwd : \c" read PASSWD isql -U$User_Name -S$SERVER -P$PASSWD  -w2000 echo "############ Hello You Are Checking $SERVER Replicaiton Status ! ##########" go echo "#########################################################" go echo "Rep Server Health -Displays status information.Status is HEALTHY when all threads are running, otherwise SUSPECT." go admin health go echo "#########################################################" go echo "Displays the threads that are not running" go admin who_is_down go echo "#########################################################" go echo " Displays the state and amount of used space for disk partitions " go admin disk_space go echo "#########################################################" go echo "############...

Unix Script 1- to find the Zombee process and send email

#################################################################################################### # Script  - CATCHZ.ksh # Author  - Amol P Ingle # Date    - 5/24/2018 # Version - 1.0 # # Purpose - when stack trace with infected 11 hits ASE dataserver it will check #           1. Check Zombie process #              -if Zombie process came in then will send alert message to DBA Team #               with DBA Page to On-call DBA #              - even if zombie process not in server and infected message comes in errorlog then- #           2. Will check health of the ASE dataserver and send an email to DBA team #           3. Will check message with shutdown as well and if comes then will #              Alert email message t...