John
asked on
db2 db and commands hang.
we use db2 v9.7 fp8 on windows server.. suddenly there is no response for the db2 commands.
when tried the command: db2 connect to cbll2 (it hangs and there is no response)
we tried to recyle the instance and ran db2stop command..but there is error the db's are active and could not stop.
need help on this urgently..what else should we be checking?
thanks in advance
when tried the command: db2 connect to cbll2 (it hangs and there is no response)
we tried to recyle the instance and ran db2stop command..but there is error the db's are active and could not stop.
need help on this urgently..what else should we be checking?
thanks in advance
did you see anything unusual in the db2diag.log file?
> we tried to recyle the instance and ran db2stop command..
> but there is error the db's are active and could not stop.
You can try "db2stop force" to deactivate all databases forcefully and stop the instance.
> but there is error the db's are active and could not stop.
You can try "db2stop force" to deactivate all databases forcefully and stop the instance.
ASKER
Momi, Please find the critical errors in the diaglog file
Also now the instance is down, and when tried to restart it we are getting an error:
db2start
DB2-0 : The process terminated unexpectedly.
01/03/2013 04:31:29 0 0 SQL1042C An unexpected system error occurred.
SQL1032N No start database manager command was issued. SQLSTATE=57019
2013-01-03-04.48.17.354000 -480 E58515935H832 LEVEL: Critical
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "Panic".
The instance may have been shutdown as a result. "Automatic" FODC
(First Occurrence Data Capture) has been invoked and diagnostic
information has been recorded in directory
"C:\PROGRA~1\IBM\SQLLIB\DB 2\FODC_Pan ic_2013-01 -03-04.48. 17.354000\ ".
Please look in this directory for detailed evidence about what
happened and contact IBM support if necessary to diagnose the
problem.
2013-01-03-04.48.17.370000 -480 I58516769H382 LEVEL: Severe
PID : 4588 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1560 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, base sys utilities, sqleSysCtlr, probe:15
DATA #1 : Hexdump, 4 bytes
0x02ABFC40 : 4C00 0000 L...
2013-01-03-04.48.17.370000 -480 I58517153H420 LEVEL: Severe
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x7D410194 : 0000 0000 ....
2013-01-03-04.48.17.370000 -480 I58517575H391 LEVEL: Severe
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x02EBF788 : 0000 0000 ....
2013-01-03-04.48.17.370000 -480 I58517968H466 LEVEL: Severe
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:6
DATA #1 : Hexdump, 20 bytes
0x0041C628 : 496E 7374 616E 6365 206E 6F74 2061 6374 Instance not act
0x0041C638 : 6976 6500 ive.
2013-01-03-04.48.17.370000 -480 I58518436H351 LEVEL: Severe
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:7
MESSAGE : Cleaning up ipc resources and exiting.
Also now the instance is down, and when tried to restart it we are getting an error:
db2start
DB2-0 : The process terminated unexpectedly.
01/03/2013 04:31:29 0 0 SQL1042C An unexpected system error occurred.
SQL1032N No start database manager command was issued. SQLSTATE=57019
2013-01-03-04.48.17.354000
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "Panic".
The instance may have been shutdown as a result. "Automatic" FODC
(First Occurrence Data Capture) has been invoked and diagnostic
information has been recorded in directory
"C:\PROGRA~1\IBM\SQLLIB\DB
Please look in this directory for detailed evidence about what
happened and contact IBM support if necessary to diagnose the
problem.
2013-01-03-04.48.17.370000
PID : 4588 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 1560 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, base sys utilities, sqleSysCtlr, probe:15
DATA #1 : Hexdump, 4 bytes
0x02ABFC40 : 4C00 0000 L...
2013-01-03-04.48.17.370000
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x7D410194 : 0000 0000 ....
2013-01-03-04.48.17.370000
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x02EBF788 : 0000 0000 ....
2013-01-03-04.48.17.370000
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:6
DATA #1 : Hexdump, 20 bytes
0x0041C628 : 496E 7374 616E 6365 206E 6F74 2061 6374 Instance not act
0x0041C638 : 6976 6500 ive.
2013-01-03-04.48.17.370000
PID : 4588 TID : 7692 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 7692 EDUNAME: db2ipccm 0
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:7
MESSAGE : Cleaning up ipc resources and exiting.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.