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> |
