IBM Support

IT35265: FEDERATED QUERY COULD LEAD TO DB2 INSTANCE CRASH WITH FODC_PANICIN SQLQGINSERT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Running a query to federated server could crash the Db2
    instance.
    Db2diag.log file may show:
    
    2020-10-07-18.10.43.047333+120 I694574676A464       LEVEL: Error
    PID     : 1442932              TID : 1029           PROC :
    db2fmp (C) 0
    INSTANCE: db2                  NODE : 000
    HOSTNAME: TEST
    EDUID   : 1029                 EDUNAME: db2fmp (C) 0
    FUNCTION: DB2 UDB, Query Gateway, sqlqg_fedstp_hook, probe:40
    MESSAGE : Unexpected error returned from outer RC=
    DATA #1 : Hexdump, 4 bytes
    0x000000012AEC3C50 : 8026 0160
    .&.`
    
    2020-10-07-18.11.12.693822+120 E694575141A870       LEVEL: Error
    PID     : 26804722             TID : 263681         PROC :
    db2sysc 0
    INSTANCE: db2                  NODE : 000           DB   :
    SAMPLE
    APPHDL  : 0-21111              APPID: *LOCAL.db2.210105071903
    UOWID   : 9                    ACTID: 1729
    AUTHID  : TESTUSER             HOSTNAME: TEST
    EDUID   : 263681               EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
    probe:30
    MESSAGE : ADM14005E  The following error occurred: "AppErr".
    First Occurrence
              Data Capture (FODC) has been invoked in the following
    mode:
              "Automatic".  Diagnostic information has been recorded
    in the
    
    
    Related trap file shows
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x09000000115C8700 sqlqgInsert(sqlri_riud *, int *) + 0x440
    0x09000000146B9F44 sqlriDjxIns(sqlrr_cb *) + 0x904
    0x0900000010D48CC8 sqlriSectInvoke(sqlrr_cb *, sqlri_opparm *) +
    0x628
    0x090000000FDB8F1C sqlrr_execute_immediate(sqlrr_cb *, int) +
    0x261C
    0x090000000FD6067C sqlrr_execimmd(db2UCinterface *,
    db2UCprepareInfo *) + 0x87C
    0x0900000012481914 pvmPackage::executeSection(sqlca *, unsigned
    int, bool) + 0x7B4
    0x090000001247CAA8 PVM::executeQuery(unsigned int, bool) + 0x208
    0x0900000012489760 PVM::run(void) + 0xFE0
    0x09000000124753DC pvm_entry + 0x45C
    0x090000000DC7DEEC sqloInvokeFnArgs + 0x5D6C
    0x0900000011644C58 IPRA.$sqlriInvokerTrusted(sqlri_ufob *,
    sqlriRoutineErrorIntf *, bool) + 0x2AF8
    0x090000001163A9A8 sqlriInvokeInvoker(sqlri_ufob *, bool) +
    0x2008
    0x090000001163B8B0 sqlricall(sqlrr_cb *) + 0x670
    0x0900000010D48CC8 sqlriSectInvoke(sqlrr_cb *, sqlri_opparm *) +
    0x628
    0x090000000FDB25A0 sqlrr_process_execute_request(sqlrr_cb *,
    int, bool) + 0x36E0
    0x090000000FD4C440 sqlrr_execute(db2UCinterface *, UCstpInfo *)
    + 0x4A0
    0x0900000012481AEC pvmPackage::executeSection(sqlca *, unsigned
    int, bool) + 0x98C
    0x090000001247CAA8 PVM::executeQuery(unsigned int, bool) + 0x208
    0x0900000012489760 PVM::run(void) + 0xFE0
    0x09000000124753DC pvm_entry + 0x45C
    0x090000000DC7DEEC sqloInvokeFnArgs + 0x5D6C
    0x0900000011644C58 IPRA.$sqlriInvokerTrusted(sqlri_ufob *,
    sqlriRoutineErrorIntf *, bool) + 0x2AF8
    0x090000001163A9A8 sqlriInvokeInvoker(sqlri_ufob *, bool) +
    0x2008
    0x090000001163B8B0 sqlricall(sqlrr_cb *) + 0x670
    0x0900000010D48CC8 sqlriSectInvoke(sqlrr_cb *, sqlri_opparm *) +
    0x628
    0x090000000FDB25A0 sqlrr_process_execute_request(sqlrr_cb *,
    int, bool) + 0x36E0
    0x090000000FD4C440 sqlrr_execute(db2UCinterface *, UCstpInfo *)
    + 0x4A0
    0x0900000015186A3C sqljs_ddm_excsqlstt(db2UCinterface *,
    sqljDDMObject *) + 0x5BC
    0x0900000015103060 sqljsParseRdbAccessed(sqljsDrdaAsCb *,
    sqljDDMObject *, db2UCinterface *) + 0x280
    0x09000000151060E4 sqljsParse(sqljsDrdaAsCb *, db2UCinterface *,
    sqeAgent *, bool) + 0x2264
    0x09000000150D10BC IPRA.$sqljsSqlam(db2UCinterface *, sqeAgent
    *, bool) + 0xE9C
    0x09000000150D97D4 sqljsDriveRequests(sqeAgent *, db2UCconHandle
    *) + 0xB4
    0x09000000150CF170
    IPRA.$sqljsDrdaAsInnerDriver(SQLCC_INITSTRUCT_T *, bool) +
    0x13F0
    0x09000000150CC5BC sqljsDrdaAsDriver(SQLCC_INITSTRUCT_T *) +
    0x33C
    0x090000000DDD6C20 sqeAgent::RunEDU(void) + 0xB60
    0x090000000DDB0E40 sqzEDUObj::EDUDriver(void) + 0x300
    0x090000000DC91E00 sqloEDUEntry + 0x360
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT35265

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-12-14

  • Closed date

    2022-04-16

  • Last modified date

    2022-04-16

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022