-
Title
Monitoring script sp_ps does not alert when single post queue stops in a multiple post queue envi -
Description
The monitoring scriptsp_ps does not alert until all the post queues are stopped in a multiple post queue environment.
-
Cause
This is due to multiple post queues and you need to customize the script for your environment
-
Resolution
RESOLUTION
Attached is a pre-modified script, that can be used.
1. Set the environment for each sp_cop you have.
export SP_SYS_PRODDIR=/u01/jess/prod53
export SP_SYS_VARDIR=/u01/jess/var
export SP_COP_TPORT=2200
export SP_COP_UPORT=2200
export ORACLE_SID=sha92
alias spbin='cd /u01/jess/prod53/bin'
alias spvar='cd /u01/jess/var'2. Place the attached sp_ps_new in the shareplex prod dir/util directory.
3. Modify the following lines in the script
a) # Change this directory to your directory where you place your env file or .profile
. /xx/xxx/$2b) change interval (seconds) based on how often you want to check to see if any process is down
interval=60c) insert your email address
MailUserName='xxxxx@xxx.com'd) If you don't want to get notified when a process is stopped by user, then you can remove this'Stopped by user' from this line in the script"egrep -i 'Stopped - due to error|Idle|Stopped by user' chk_splex_processes_$2.out > splex_error_$2.out"4. chmod 755 sp_ps_new, and run as following:
./sp_ps_new 'sp_cop -u<xxxx>' <yyyy.env file> &
For example if your sp_cop is started as 'sp_cop -u2200' and your env file is called data.env
./sp_ps_new 'sp_cop -u2200' data.env &
WORKAROUND
SharePlex Manager allows you to monitor and alert SharePlex processes. -
Attachments
-
Additional Information
Support doesn't customize shell scripts for specific customer environment, PSO should be contacted.