DB2 - Problembeschreibung
Problem IC80593 | Status: Geschlossen |
LOAD OPERATION CAN CAUSE INSTANCE TO TRAP IN DB2LFRM AGENTS. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
LOAD operation can cause instance to trap in db2lfrm agents. This only occurs in a DPF instance and currently the condition under which the issue occurs are random. db2diag.log: 2011-09-01-10.05.14.770440+120 I1257458E574 LEVEL: Warning PID : 20678 TID : 46947800967488PROC : db2sysc 12 INSTANCE: db2inst1 NODE : 012 DB : SAMPLE APPHDL : 0-5253 APPID: *N0.db2inst1.110901080458 AUTHID : DB2INST1 EDUID : 372464 EDUNAME: db2lfrm0 12 FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314 DATA #1 : String, 142 bytes LOADID: 371182.2011-09-01-10.04.58.146091.0 (1935;4) Starting LOAD phase at 09/01/2011 10:05:14.770237. Table DB2INST1.STORES ... 2011-09-01-10.05.17.101201+120 I1281629E510 LEVEL: Severe PID : 20678 TID : 46947800967488PROC : db2sysc 12 INSTANCE: db2inst1 NODE : 012 DB : SAMPLE APPHDL : 0-5253 APPID: *N0.db2inst1.110901080458 AUTHID : DB2INST1 EDUID : 372464 EDUNAME: db2lfrm0 12 FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::FreeChannel, probe:20 DATA #1 : Hexdump, 4 bytes 0x00002AB2E2FFCA70 : 0100 0000 .... ... 2011-09-01-10.05.17.140139+120 I1284821E490 LEVEL: Severe PID : 20678 TID : 46947800967488PROC : db2sysc 12 INSTANCE: db2inst1 NODE : 012 DB : SAMPLE APPHDL : 0-5253 APPID: *N0.db2inst1.110901080458 AUTHID : DB2INST1 EDUID : 372464 EDUNAME: db2lfrm0 12 FUNCTION: DB2 UDB, fast comm manager, sqkfFastCommManager::CloseChannel, probe:3000 RETCODE : ZRC=0x8759007F=-2024210305=SQLKF_PGM_ERROR "FCM coding error" 2011-09-01-10.05.17.462219+120 I1285312E563 LEVEL: Warning PID : 20678 TID : 46947800967488PROC : db2sysc 12 INSTANCE: db2inst1 NODE : 012 DB : SAMPLE APPHDL : 0-5253 APPID: *N0.db2inst1.110901080458 AUTHID : DB2INST1 EDUID : 372464 EDUNAME: db2lfrm0 12 FUNCTION: DB2 UDB, fast comm manager, sqkfCommSession::FreeStrayDataResources, probe:15 MESSAGE : Error closing stray channel: DATA #1 : Hexdump, 8 bytes 0x00002AB2E2FFCB50 : 4074 CE44 0200 0000 @t.D.... 2011-09-01-10.05.17.488452+120 I1285876E510 LEVEL: Severe PID : 20678 TID : 46947800967488PROC : db2sysc 12 INSTANCE: db2inst1 NODE : 012 DB : SAMPLE APPHDL : 0-5253 APPID: *N0.db2inst1.110901080458 AUTHID : DB2INST1 EDUID : 372464 EDUNAME: db2lfrm0 12 FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::FreeChannel, probe:20 DATA #1 : Hexdump, 4 bytes 0x00002AB2E2FFCA70 : 0100 0000 .... 2011-09-01-10.05.17.509163+120 I1286387E490 LEVEL: Severe PID : 20678 TID : 46947800967488PROC : db2sysc 12 INSTANCE: db2inst1 NODE : 012 DB : SAMPLE APPHDL : 0-5253 APPID: *N0.db2inst1.110901080458 AUTHID : DB2INST1 EDUID : 372464 EDUNAME: db2lfrm0 12 FUNCTION: DB2 UDB, fast comm manager, sqkfFastCommManager::CloseChannel, probe:3000 RETCODE : ZRC=0x8759007F=-2024210305=SQLKF_PGM_ERROR "FCM coding error" ... 2011-09-01-10.05.17.835421+120 I1288474E558 LEVEL: Severe PID : 20678 TID : 46947800967488PROC : db2sysc 12 INSTANCE: db2inst1 NODE : 012 DB : SAMPLE APPHDL : 0-5253 APPID: *N0.db2inst1.110901080458 AUTHID : DB2INST1 EDUID : 372464 EDUNAME: db2lfrm0 12 FUNCTION: DB2 UDB, RAS/PD component, pdResilienceIsSafeToSustain, probe:800 DATA #1 : String, 37 bytes Trap Sustainability Criteria Checking DATA #2 : Hex integer, 8 bytes 0x0000000B0202100D DATA #3 : Boolean, 1 bytes false 2011-09-01-10.05.17.852146+120 I1289033E479 LEVEL: Severe PID : 20678 TID : 46947800967488PROC : db2sysc 12 INSTANCE: db2inst1 NODE : 012 DB : SAMPLE APPHDL : 0-5253 APPID: *N0.db2inst1.110901080458 AUTHID : DB2INST1 EDUID : 372464 EDUNAME: db2lfrm0 12 FUNCTION: DB2 UDB, Query Gateway, sqlqg_signal_handler, probe:10 MESSAGE : DIA0505I Execution of a component signal handling function has begun. 2011-09-01-10.05.17.873243+120 I1289513E210 LEVEL: Severe PID:20678 TID:46947800967488 NODE:012 Title: QG SQLCA Dump File:/db2/SAMPLE/db2dump/FODC_Trap_2011-09-01-10.05.17.581354/20 678.372464.012.dump.bin 20678.372464.012.trap.txt: <Header> DB2 build information: DB2 v9.7.0.3 s101006 SQL09073 timestamp: 2011-09-01-10.05.17.628602 instance name: db2inst1.012 EDU name : db2lfrm0 12 EDU ID : 372464 Signal #11 uname: S:Linux R:2.6.18-238.1.1.el5 V:#1 SMP Tue Jan 4 13:32:19 EST 2011 M:x86_64 N:cromarty process id: 20678 thread id : 46947800967488 (0x2AB2E2FFE940) </Header> ... <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002AAAAFEF4C07 ossDumpStackTraceEx + 0x01ef 0x00002AAAAFEEF9CE OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc 0x00002AAAAD1DE05B sqlo_trce + 0x03fb 0x00002AAAAD2240A0 sqloEDUCodeTrapHandler + 0x0266 0x00000034A520EB10 address: 0x00000034A520EB10 ; dladdress: 0x00000034A5200000 ; offset in lib: 0x000000000000EB10 ; 0x00002AAAAB9F8A60 sqzDataChainIteratorI11sqkfChannelE13nextChainElemEv + 0x000a 0x00002AAAAB9F8A47 sqzDataChainIteratorI11sqkfChannelE22forwardRemoveChainElemEv + 0x0011 0x00002AAAAC7887BD sqkfFastCommManager12CloseChannelEP11sqkfChanneli + 0x006b 0x00002AAAAC799D95 sqkfCommSession22FreeStrayDataResourcesEiP18SQLZ_PDB_UNIQUE_ID + 0x01b7 0x00002AAAABDB2F20 sqlkfFreeStrayDataResourcesiP18SQLZ_PDB_UNIQUE_ID + 0x0024 0x00002AAAABEA27BE sqlricls_complexP8sqlrr_cbilll + 0x1220 0x00002AAAABDA0964 sqlra_close_sectionP8sqlrr_cbP25sqlra_sql_context_sibling + 0x0212 0x00002AAAAD9BC13B sqluCGenColDataFormatter15iExecuteSectionEP8sqeAgent + 0x016b 0x00002AAAAD9B90FB sqluCGenColMgr21iProcessGeneratedColsEP8sqeAgentP16sqluCCatalogI nfoP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBPP10SQLD_VALUEPmiRiSC_Pi + 0x03ad 0x00002AAAAD9E9D75 address: 0x00002AAAAD9E9D75 ; dladdress: 0x00002AAAAAABF000 ; offset in lib: 0x0000000002F2AD75 ; 0x00002AAAAD9E4C94 sqluCFormatter4iRunEv + 0x0856 0x00002AAAADA61505 sqluLoadEDUDriverPhj + 0x02f9 0x00002AAAABD1AD94 sqloEDUEntry + 0x02f4 0x00000034A520673D address: 0x00000034A520673D ; dladdress: 0x00000034A5200000 ; offset in lib: 0x000000000000673D ; 0x00000034A46D40CD clone + 0x006d </StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * this only occurs in a DPF instance in all platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW Version 9.7 Fix Pack 6. * **************************************************************** | |
Local-Fix: | |
Use the option CPU_PARALLELISM 1 to avoid this issue. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
The problem was first fixed in DB2 LUW Version 9.7 Fix Pack 6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84435 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.12.2011 18.05.2012 18.05.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |