View previous topic :: View next topic
|
Author |
Message |
ralph_v
New User
Joined: 07 Jul 2005 Posts: 27
|
|
|
|
Hi,
Is there any way to find whether DB2 is down. |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
3 Options:
1) Run the DB2 command "-DISPLAY DATABASE(dbname)".
2) Take a look in SDSF to see whether the DB2 started task is up.
3) From within REXX, try the CONNECT statement of the DSNREXX interface.
O. |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
Hi,
check in spool that whether DB2 address space jobs running or not...search the spool with jobname starts with subsystem name.
You will find 4 or 5 address space jobs (MSTR,DBRC,SPAS,DIST each for one purpose). If they are not active you can say DB2 is down.
Thanks
Raghavendra |
|
Back to top |
|
|
venky5436
New User
Joined: 06 Dec 2005 Posts: 12
|
|
|
|
Hi,
You can try this simple method to check if DB2 database is working.
Use the select to view few rows from any table .
Thanks
venky |
|
Back to top |
|
|
|