IBM Support

IC80593: LOAD OPERATION CAN CAUSE INSTANCE TO TRAP IN DB2LFRM AGENTS.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

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

Local fix

  • Use the option CPU_PARALLELISM 1 to avoid this issue.
    

Problem summary

  • ****************************************************************
    * 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.                   *
    ****************************************************************
    

Problem conclusion

  • The problem was first fixed in DB2 LUW Version 9.7 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80593

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-12-27

  • Closed date

    2012-05-18

  • Last modified date

    2012-05-18

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC84435

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC80593

Modified date: 18 May 2012