Steve, I like to create a table in a tablespace that exists on all partitions and then query the number of rows in the table. If I get the expected value, then I can be pretty sure that the database is up and all partitions are available.
Good luck, Ian ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 13, 2001 9:29 AM Subject: DB2EUG: Best way to determine if DB2 is "up"? > 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
