Personal tools
You are here: Home DB2 Problem Resolution Instance errors DB2 Instance Down
Navigation
Log in


Forgot your password?
 
Document Actions

DB2 Instance Down

DB2 Instance Down for some reason



1 Error message


SQL1032N  No start database manager command was issued.  SQLSTATE=57019


2 Possible causes:


a) someone/some routine issued "db2stop"


db2diag.log will show messages as:

2008-03-24-22.20.34.322247-240 I9769A383          LEVEL: Event
PID     : 8598                 TID  : 1           PROC : db2stop2
INSTANCE: udb0                 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104


b) db2 processes where removed from O.S:


In this case, there will be no message at db2diag.log.

c) Fatal error on DB2


db2diag.log will show messages as:

2008-03-24-22.20.34.322247-240 I9769A383          LEVEL: Fatal


3 Investigating


Before restart the instance, check if there are remaining O.S processes or memory segments:

ps -ef |grep db2sy |grep <instance owner>
ipcs |grep <instance owner>


Archive db2diag.log for further investigation (this is important when the server has a Fatal Error): db2diag -archive

4 Resolution


Restart instance:

db2start


Monitor db2 start at db2diag.log:

tail -f db2diag.log


Activate all database:

db2 activate database <db>


Check tablespace status:

db2 "list tablespaces |grep Tablespace | wc -l"

must be the same as

db2 "list tablespaces |grep Normal|wc -l"




Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls