Additional db2sysc processes

Dave Stritzinger

Additional db2sysc processes
List members,

My environment is AIX 5.1 with DB2 UDB 8.1.6 using the data partitioning
/ EEE / MLN option running on a P690 Regatta. I have 18 nodes defined in my
db2nodes.cfg file and as normal I have 18 db2sysc processes running ( all
nodes are running on the same AIX LPAR). I have created a small check script
that is scheduled with crontab to run every 15 minutes to check to make sure
that all the db2sysc processes are running, i.e. check to make sure that
either the complete DB2 system is up or if one or more of the nodes has
crashed).

The script checks for how many nodes should be running (NUM_OF_NODES=`wc
-l ~db2knapi/sqllib/db2nodes.cfg|awk '{print $1}'`), then checks how many
db2sysc processes are running (NUM_OF_DB2SYSC=`ps -ef|grep db2sysc|grep -v
grep|wc -l` ) and then compares the two to make sure that they are equal.

Last night the script found an "error" because the NUM_OF_NODES was 18
(correct amount), but the number of db2sysc processes found was 20 ! This
was the first time that I had this occur. I asked the DBA's at my place and
they were not doing any of there own scripts that may have been doing a grep
for db2sysc and they say no. The script as of last night just sent an email
stating that the numbers did not match. I enhanced the script today so that
the output from the ps -ef|grep command will also be sent out with the
warning.

I was always under the impression that the db2sysc process was one to
one with the number of nodes. Has anyone else encountered this issue or can
tell me why there maybe more db2sysc processes than nodes?

Thanks in advance for any and al help.


Dave S.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Piontkowski

Re: Additional db2sysc processes
(in response to Dave Stritzinger)
David -

I'm not sure 'bout DB2 V8 but in V7 there's also a db2sysc process for
the DB2 Admin Server.
Try this command sequence "ps -ef | grep -i [d]b2sysc | wc -l". The []
surrounding the "d"
in [d]b2sysc excludes the "grep -i..." command from the grep output.





Mike Piontkowski
Independence Blue Cross
Corporate Data Warehouse
Voice: x34530 (215-988-4530)
Fax: x38736 (215-988-8736)

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Tuesday, November 30, 2004 13:48
To: [login to unmask email]
Subject: [DB2-L] Additional db2sysc processes


List members,

My environment is AIX 5.1 with DB2 UDB 8.1.6 using the data
partitioning / EEE / MLN option running on a P690 Regatta. I have 18
nodes defined in my db2nodes.cfg file and as normal I have 18 db2sysc
processes running ( all nodes are running on the same AIX LPAR). I have
created a small check script that is scheduled with crontab to run every
15 minutes to check to make sure that all the db2sysc processes are
running, i.e. check to make sure that either the complete DB2 system is
up or if one or more of the nodes has crashed).

The script checks for how many nodes should be running
(NUM_OF_NODES=`wc -l ~db2knapi/sqllib/db2nodes.cfg|awk '{print $1}'`),
then checks how many db2sysc processes are running (NUM_OF_DB2SYSC=`ps
-ef|grep db2sysc|grep -v grep|wc -l` ) and then compares the two to make
sure that they are equal.

Last night the script found an "error" because the NUM_OF_NODES was
18 (correct amount), but the number of db2sysc processes found was 20 !
This was the first time that I had this occur. I asked the DBA's at my
place and they were not doing any of there own scripts that may have
been doing a grep for db2sysc and they say no. The script as of last
night just sent an email stating that the numbers did not match. I
enhanced the script today so that the output from the ps -ef|grep
command will also be sent out with the warning.

I was always under the impression that the db2sysc process was one
to one with the number of nodes. Has anyone else encountered this issue
or can tell me why there maybe more db2sysc processes than nodes?

Thanks in advance for any and al help.


Dave S.
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


CONFIDENTIALITY NOTICE: This E-Mail is intended only
for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you have received this communication in error, please do not distribute and delete the original message. Please notify the sender by E-Mail at the address shown. Thank you for your compliance.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm