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
