home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList