Steve, Have you thought about connecting to the database? You would need a script to ensure that the connecting script did so within a reasonable time.
I would also recommend actually specifying the user name to ensure full validation is done. Cheers, Jeremy [EMAIL PROTECTED] wrote: > 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 ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
