Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to know whether DB2 is down

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ralph_v

New User


Joined: 07 Jul 2005
Posts: 27

PostPosted: Tue Feb 28, 2006 2:50 pm    Post subject: How to know whether DB2 is down
Reply with quote

Hi,

Is there any way to find whether DB2 is down.
Back to top
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Tue Feb 28, 2006 3:37 pm    Post subject:
Reply with quote

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
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Tue Feb 28, 2006 6:41 pm    Post subject: Re: How to know whether DB2 is down
Reply with quote

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
View user's profile Send private message
venky5436

New User


Joined: 06 Dec 2005
Posts: 12

PostPosted: Fri Mar 17, 2006 9:13 pm    Post subject: Re: How to know whether DB2 is down
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:



Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us