DB2 - Problembeschreibung
Problem IC93746 | Status: Geschlossen |
DB2 ABEND WITH MEMORY CORRUPTION DURING LOAD PROCESSING. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
DB2 may abend at the end of load during file closure with SIGSEV. FODC Trap will be created and stack dump may look as follows: Stack #1 Signal #11 Timestamp 2013-06-04-12.19.46.971129 0 strlen 1 _doprnt 2 vsnprintf 3 ossSnprintf 4 pdFormat_SQLO_FHANDLE 5 pdFormatArg 6 pdInvokeFmtFnc 7 @132@formatPDType 8 @132@pdTypeFormatOrDump 9 @132@pdLogInternal 10 pdLogInternal 11 pdLogSysRC 12 sqloSystemErrorHandler 13 sqloSystemErrorHandler@glue7CE 14 sqlodelete 15 sqloDeleteNamedPipe 16 sqluCSerializablePipeBase::iClose 17 sqluCSerializablePipeBase::iCleanUp 18 sqluCSerializablePipe::iCleanUp 19 @88@sqluCleanupUserExitPipes 20 sqluCleanupUserExitCB 21 sqluAppCbCleanup 22 sqluCommitCallBack 23 sqlrr_tran_router 24 sqlrr_subagent_router 25 sqleSubRequestRouter 26 sqleProcessSubRequest 27 sqeAgent::RunEDU 28 sqzEDUObj::EDUDriver 29 sqloEDUEntry Memory may be also consumed fully during this abend. Core dump may be generated as well. db2diag.log may look as follows: 2013-06-04-12.19.47.171008-240 I43934143A490 LEVEL: Warning PID : 12780076 TID : 265047 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB :sample APPHDL : 1-15207 APPID: *N1.db2inst1.130604132421 AUTHID : LOADPROD EDUID : 265047 EDUNAME: db2agnta (EDWDBP01) 0 FUNCTION: DB2 UDB, RAS/PD component, pdEDUIsInDB2KernelOperation, probe:600 DATA #1 : String, 13 bytes ossSnprintf DATA #2 : String, 3 bytes oss 2013-06-04-12.19.47.172227-240 I43934634A566 LEVEL: Severe PID : 12780076 TID : 265047 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB :sample APPHDL : 1-15207 APPID: *N1.db2inst1.130604132421 AUTHID : LOADPROD EDUID : 265047 EDUNAME: db2agnta (EDWDBP01) 0 FUNCTION: DB2 UDB, RAS/PD component, pdResilienceIsSafeToSustain, probe:800 DATA #1 : String, 37 bytes Trap Sustainability Criteria Checking DATA #2 : Hex integer, 8 bytes 0x0000000302001849 DATA #3 : Boolean, 1 bytes false 2013-06-04-12.21.45.561356-240 E43981275A1383 LEVEL: Error (OS) PID : 12780076 TID : 22963 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB :sample APPHDL : 1-15866 APPID: *N1.db2inst1.130604161934 AUTHID : LOADPROD EDUID : 22963 EDUNAME: db2agnta (EDWDBP01) 0 FUNCTION: DB2 UDB, oper system services, sqlodelete, probe:50 MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." DIA8411C A file "" could not be found. CALLED : OS, -, unlink OSERR : ENOENT (2) "No such file or directory" DATA #1 : File name, 137 bytes /gpfs/dba/db2utlgn/edwdbp01/s41f400n01/temp_files/cdwdba.lda_tas er_txns_ltr_tags_daily/DB200041.PID/DB200597.OID/db2loadpipe3974 7.000.000 DATA #2 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes File Handle = 125829120 File System Block Size = 0 bytes File System Type = UNKNOWN File Handle Flags : Require Sector Align = No DIO/CIO Mode = Yes Raw Block Device = No Reserved Handle = No Flush On Close = No Thread-Level Lock = Yes Write-through Mode = Yes File Not Tracked = No DATA #3 : unsigned integer, 4 bytes 1 DATA #4 : String, 105 bytes Search for ossError*Analysis probe point after this log entry for further self-diagnosis of this problem. 2013-06-04-12.21.45.561868-240 E43982659A526 LEVEL: Error PID : 12780076 TID : 22963 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB :sample APPHDL : 1-15866 APPID: *N1.db2inst1.130604161934 AUTHID : LOADPROD EDUID : 22963 EDUNAME: db2agnta (EDWDBP01) 0 FUNCTION: DB2 UDB, oper system services, sqloDeleteNamedPipe, probe:10 MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found." DIA8411C A file "" could not be found. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V97 FP9 * **************************************************************** | |
Local-Fix: | |
No Local Fix | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
First Fixed in DB2 V97 FP9 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.06.2013 16.12.2013 16.12.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |