IBM Support

IT31330: INCORRECTLY CONFIGURED SSL CONNECTION MAY TRIGGER DB2 TRAP

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • This issue occurs when the database server has a database
    cataloged to loop back using SSL, and the server does not have
    SSL_CLNT_KEYDB
    and SSL_CLNT_STASH set.  It also applies to a Db2 gateway server
    but instead of a loop back, it is an out going SSL connection to
    a host.
    The Db2 server/gateway may trap with the following messages in
    db2diag.log:
    
    2019-12-10-09.22.39.700685-300 I734835A508 LEVEL: Error
    PID : 28246350 TID : 40573 PROC : db2sysc 0
    INSTANCE: inst01 NODE : 000 DB : DB2PRODB
    APPHDL : 0-15751
    HOSTNAME: db2prodsrv
    EDUID : 40573 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, common communication,
    sqlccMapSSLErrorToDB2Error, probe:530
    MESSAGE : DIA3604E The SSL function "gsk_environment_init"
    failed with the
    return code "202" in "sqlccLoadSSLLibrary".
    
    2019-12-10-09.22.39.701236-300 I735344A429 LEVEL: Error
    PID : 28246350 TID : 40573 PROC : db2sysc 0
    INSTANCE: inst01 NODE : 000 DB : DB2PRODB
    APPHDL : 0-15751
    HOSTNAME: db2prodsrv
    EDUID : 40573 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, common communication, sqlccLoadSSLLibrary,
    probe:998
    MESSAGE : DIA3603E SSL was not setup. Return code = "91".
    
    2019-12-10-09.22.39.701655-300 I735774A2822 LEVEL: Severe
    PID : 28246350 TID : 40573 PROC : db2sysc 0
    INSTANCE: inst01 NODE : 000 DB : DB2PRODB
    APPHDL : 0-15751
    HOSTNAME: db2prodsrv
    EDUID : 40573 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect,
    probe:10
    MESSAGE : ZRC=0x8636000A=-2043281398=SQLZ_RC_FNEX, SQLT_SQLJC
    "File Does Not Exist"
    DIA8411C A file "" could not be found.
    DATA #1 : String, 11 bytes
    CCI Error:
    DATA #2 : unsigned integer, 8 bytes
    91
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
    [0] 0x0900000011FC01E0
    sqljcLogCCIError__FP10sqljCmnMgrPCcP12SQLCC_COND_TUclN35 + 0x2E0
    [1] 0x0900000011FB9F34 sqljcCommConnect__FP10sqljCmnMgr + 0x7B4
    [2] 0x0900000011FB8EC8
    sqljcCmnMgrInit__FP10sqljCmnMgrP17SQLCC_COMHANDLE_TPUcUlP14db2UC
    conHandleUc24sqljcInvokeCommExitStatePP21sqljcCommexitCommInfoP
    + 0xC8
    [3] 0x0900000016EB0E78 sqljrCreateTransport__FP14db2UCconHandle
    + 0xD8
    [4] 0x0900000011B24698
    sqljrAssociateTransport__FP14db2UCconHandlePlbP19SQLE_SRVLST_DBE
    NTRYPi + 0x38
    [5] 0x0900000016EB01B8
    sqljrConnectBasedOnCatalog__FP14db2UCconHandlePibPb + 0x1D8
    [6] 0x0900000016EAF1B8
    sqljrInternalConnect__FP14db2UCconHandlePbPib + 0x9F8
    [7] 0x0900000016EB0C40
    sqljrFindBestAddressAndConnect__FP14db2UCconHandle + 0x80
    [8] 0x0900000016EA2274
    sqljrDrdaArAuthenticate__FP14db2UCinterfacelPUi + 0x1F4
    [9] 0x0900000018D19D40 sqlexGwAuthenticate__FP14db2UCinterface +
    0x1280
    [10] 0x0900000018CAF8F0 sqljrDrdaArConnect__FP14db2UCinterface +
    0xF0
    [11] 0x090000001248F94C
    sqleUCagentDrdaArConnect__FP14db2UCinterface + 0x8C
    [12] 0x0900000012489E18 sqleUCengnInit__FP14db2UCinterfaceUs +
    0x958
    [13] 0x090000001248A65C sqleUCagentConnect + 0x69C
    [14] 0x0900000012627988
    sqljsConnectAttach__FP13sqljsDrdaAsCbP14db2UCinterface + 0x308
    [15] 0x0900000013AA439C
    sqljs_ddm_accsec__FP14db2UCinterfaceP13sqljDDMObject + 0xBBC
    [16] 0x0900000018E68814
    sqljsParseConnect__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinte
    rface + 0x1F4
    [17] 0x0900000018E6BC64
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x2264
    [18] 0x0900000018E36E3C
    IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
    [19] 0x0900000018E3F554
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
    [20] 0x0900000018E34EF0
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
    [21] 0x0900000018E32334
    sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x334
    [22] 0x0900000011B599A0 RunEDU__8sqeAgentFv + 0xB60
    [23] 0x0900000011B33BC0 EDUDriver__9sqzEDUObjFv + 0x300
    [24] 0x0900000011A15200 sqloEDUEntry + 0x360
    [25] 0x0900000000551FE8 _pthread_body + 0xE8
    [26] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    
    2019-12-10-09.22.39.783144-300 I738597A522 LEVEL: Error
    PID : 28246350 TID : 40573 PROC : db2sysc 0
    INSTANCE: inst01 NODE : 000 DB : DB2PRODB
    APPHDL : 0-15751
    HOSTNAME: db2prodsrv
    EDUID : 40573 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
    probe:1
    MESSAGE : Error in agent servicing application with coor_node:
    DATA #1 : Hexdump, 2 bytes
    0x0A00000001BFBD40 : 0000 ..
    
    The call stacks look like:
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x09000000100D463C
    sqlccSSLSocketClose__FP17SQLCC_COMHANDLE_TP21SQLCC_TCPCONNHANDLE
    _TP12SQLCC_COND_T + 0x23C
    0x09000000100C1900
    sqlcctcpdisc__FP17SQLCC_COMHANDLE_TP12SQLCC_COND_T + 0x260
    0x09000000100551DC
    sqlccdisc__FP17SQLCC_COMHANDLE_TcP12SQLCC_COND_T + 0x2BC
    0x0900000016FA6A3C IPRA.$sqljsTrapResilience__FP14db2UCinterface
    + 0x15FC
    0x0900000016FA5230 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x230
    0x090000000FCCC9A0 RunEDU__8sqeAgentFv + 0xB60
    0x090000000FCA6BC0 EDUDriver__9sqzEDUObjFv + 0x300
    0x090000000FB88200 sqloEDUEntry + 0x360
    </StackTrace>
    

Local fix

  • Correct the SSL configuration
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31330

  • 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

    2019-12-18

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
01 April 2021