DB2 - Problembeschreibung
Problem IC66302 | Status: Geschlossen |
HADR STANDBY (DB2HADRS) MIGHT PANIC IF IT CANNOT CLOSE SQLOGMIR.LFH DURING SHUTDOWN. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
A HADR standby EDU (db2hadrs) might invoke a panic to bring instance down if the EDU cannot close mirror log control file (SQLOGMIR.LFH) while it is being shutdown. The following db2diag.log entries show the problem. The sqloclose() indicates the file has already been closed by the other EDU. So HADR standby do not need to close it, and should not panic. 20010-01-22-18.08.42.843837+540 E36716560A735 LEVEL: Error (OS) PID : 156072 TID : 12500 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 12500 EDUNAME: db2hadrs (SAMPLE) 0 FUNCTION: DB2 UDB, oper system services, sqloclose, probe:20 MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." DIA8411C A file "" could not be found. CALLED : OS, -, close OSERR : EBADF (9) "Bad file number" DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes 0x0700000004BFDCE0 : FFFF FFFF 0000 0100 ........ DATA #2 : String, 105 bytes Search for ossError*Analysis probe point after this log entry for further self-diagnosis of this problem. 2010-01-22-18.08.42.859223+540 I36717710A434 LEVEL: Error PID : 156072 TID : 12500 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 12500 EDUNAME: db2hadrs (SAMPLE) 0 FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrCloseLogFiles, probe:31920 RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." DIA8411C A file "" could not be found. 2010-01-22-18.08.42.871074+540 E36718961A832 LEVEL: Critical PID : 156072 TID : 12500 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 12500 EDUNAME: db2hadrs (SAMPLE) 0 FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10 MESSAGE : ADM14001C An unexpected and critical error has occurred: "Panic". | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users who use HADR. * **************************************************************** * PROBLEM DESCRIPTION: * * A HADR standby EDU (db2hadrs) might invoke a panic to * * bringinstance down if the EDU cannot close mirror log * * controlfile (SQLOGMIR.LFH) while it is being shutdown.The * * following db2diag.log entries show the problem. * * Thesqloclose() indicates the file has already been closed * * bythe other EDU. So HADR standby do not need to close it, * * andshould not panic.20010-01-22-18.08.42.843837+540 * * E36716560A735 LEVEL: Error(OS)PID : 156072 * * TID : 12500 PROC : db2sysc0INSTANCE: db2inst1 * * NODE : 000EDUID : 12500 EDUNAME: db2hadrs * * (SAMPLE) 0FUNCTION: DB2 UDB, oper system services, * * sqloclose, probe:20MESSAGE : * * ZRC=0x860F000A=-2045837302=SQLO_FNEX "File * * notfound."DIA8411C A file "" could not be found.CALLED : * * OS, -, closeOSERR : EBADF (9) "Bad file number"DATA #1 : * * File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes0x0700000004BFDCE0 * * : FFFF FFFF 0000 0100 ........DATA #2 : String, 105 * * bytesSearch for ossError*Analysis probe point after this * * logentry for further self-diagnosis of this * * problem.2010-01-22-18.08.42.859223+540 I36717710A434 LEVEL: * * ErrorPID : 156072 TID : 12500 PROC : * * db2sysc0INSTANCE: db2inst1 NODE : 000EDUID : * * 12500 EDUNAME: db2hadrs (SAMPLE) 0FUNCTION: * * DB2 UDB, High Availability Disaster * * Recovery,hdrCloseLogFiles, probe:31920RETCODE : * * ZRC=0x860F000A=-2045837302=SQLO_FNEX "File * * notfound."DIA8411C A file "" could not be * * found.2010-01-22-18.08.42.871074+540 E36718961A832 * * LEVEL:CriticalPID : 156072 TID : 12500 * * PROC : db2sysc0INSTANCE: db2inst1 NODE : 000EDUID * * : 12500 EDUNAME: db2hadrs (SAMPLE) 0FUNCTION: * * DB2 UDB, base sys utilities, sqle_panic, probe:10MESSAGE : * * ADM14001C An unexpected and critical error hasoccurred: * * "Panic". * **************************************************************** * RECOMMENDATION: * * Please upgrade to version 9.5 fixpack 6 or later. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.5 Fix Pack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66578 IC66579 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.02.2010 09.09.2010 09.09.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |