There is a process that DB2 runs named db2sysc. There should be one and only one of these process for each logical node in a EEE environment.
We have a script that goes out to each machine (using the rah command) and does a ps -ef | grep $DB2INSTANCE | grep db2sysc. It counts the number of db2sysc's that it finds and compares that to the number of entries in db2nodes.cfg. A ps -ef it also returns the logical node number which could be used to help find the missing nodes, (what you expect vs, what you find) if any. (if the two numbers don't match we list all of the nodes that we did find). (Also, don't try this as the instance owner, you will get an extra node because of the way the grep looks for the instance owner and db2sysc, which is part of the grep command.) This seemed to be the least intrusive means of determining if DB2 is up or not. This script will run faster and use less resources than anything depending on DB2 services. You can run the script iterativly or only when the SA wants it to. Russ The opions expressed here are my own and should be considered as untested untill you test them in your own environment. blah blah blah --------------- MESSAGE db2eug.v002.n206.2 --------------- From: [EMAIL PROTECTED] Subject: Best way to determine if DB2 is "up"? Date: Tue, 13 Nov 2001 10:29:03 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Our system administrator wants me to give him a UNIX shell script that will report to him on whether DB2 is up or down. It's easy to determine if it's down: If there are no processes running for the instance owner, my shell script just prints "DB2 is down" on his screen. But it seems more problematic to determine if everything that should be running is in fact running. He doesn't want me to simply display all of the DB2 instance processes, since he can't be expected to be expert in knowing all the processes of every application on every system that he administers. My question, then, is: What is the best/most desirable indicator that the DB2 instance is "up" in every respect? Would a successful attempt to connect to the database do it? Is there another, better approach? By the way, we are running DB2 UDB EEE 7.2 on AIX 4.3.3.0. Thanks. Steve Westfall Equifax, Inc. This message contains information from Equifax, Inc. which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail [EMAIL PROTECTED] ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
