IBM Support

IT22622: INSTANCE MAY CRASH WHEN SQLGGTSS API IS RUN WITHOUT A CONNECTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Instance may crash when sqlggtss API is run without a
    connection.
    
    Trap file will show the following:
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00007F09A24CE975
    _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
    0x0385
    0x00007F09A24CE57C ossDumpStackTraceV98 + 0x002c
    0x00007F09A24CA61D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00fd
    x00007F09A8B0CAB4 sqlo_trce + 0x0404
    x00007F09A8B964EC sqloEDUCodeTrapHandler + 0x02ac
    x000000363120F500 address: 0x000000363120F500 ; dladdress:
    0x0000003631200000 ; offset in lib: 0x000000000000F500 ;
    x00007F09A9B6E390 _Z9sqlpSpReqP8sqeAgent11SQLP_SPTYPEPm + 0x0060
    x00007F09A7A57418 _Z17sqlbgtss_route_inP12SQLE_DB2RA_TP8sqeAgent
    + 0x0078
    x00007F09A5B450F6 _Z8sqlesrvrP14db2UCinterface + 0x1356
    x00007F09A5B6479E _Z19sqleMappingFnServerP5sqldaP5sqlca + 0x04de
    x00007F09A5D8AE47
    _Z19sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgent
    P5sqlca + 0x0247
    x00007F09A5D8CC7D _Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo +
    0x06fd
    x00007F09A9ADE91E
    _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject +
    0x09be
    x00007F09A9ADD9AE
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x007e
    x00007F09A5E74FEB
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x036b
    x00007F09A5E6F4E9 address: 0x00007F09A5E6F4E9 ; dladdress:
    0x00007F09A29F4000 ; offset in lib: 0x000000000347B4E9 ;
    x00007F09A5E6D93C address: 0x00007F09A5E6D93C ; dladdress:
    0x00007F09A29F4000 ; offset in lib: 0x000000000347993C ;
    x00007F09A5E6A999 address: 0x00007F09A5E6A999 ; dladdress:
    0x00007F09A29F4000 ; offset in lib: 0x0000000003476999 ;
    x00007F09A5E6A58B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
    0x00eb
    x00007F09A5B68C27 _ZN8sqeAgent6RunEDUEv + 0x0ad7
    x00007F09A7382227 _ZN9sqzEDUObj9EDUDriverEv + 0x00f7
    x00007F09A6B3A8C3 sqloEDUEntry + 0x0303
    x0000003631207851 address: 0x0000003631207851 ; dladdress:
    0x0000003631200000 ; offset in lib: 0x0000000000007851 ;
    x0000003630EE894D clone + 0x006d
    </StackTrace>
    
    Cleaned up stack:
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00007F09A24CE975 ossDumpStackTraceInternal(unsigned long,
    OSSTrapFile&, int, siginfo*, void*, unsigned long, unsigned
    long) + 0x0385
    0x00007F09A24CE57C ossDumpStackTraceV98 + 0x002c
    0x00007F09A24CA61D OSSTrapFile::dumpEx(unsigned long, int,
    siginfo*, void*, unsigned long) + 0x00fd
    x00007F09A8B0CAB4 sqlo_trce + 0x0404
    x00007F09A8B964EC sqloEDUCodeTrapHandler + 0x02ac
    x000000363120F500 address: 0x000000363120F500 ; dladdress:
    0x0000003631200000 ; offset in lib: 0x000000000000F500 ;
    x00007F09A9B6E390 sqlpSpReq(sqeAgent*, SQLP_SPTYPE, unsigned
    long*) + 0x0060
    x00007F09A7A57418 sqlbgtss_route_in(SQLE_DB2RA_T*, sqeAgent*) +
    0x0078
    x00007F09A5B450F6 sqlesrvr(db2UCinterface*) + 0x1356
    x00007F09A5B6479E sqleMappingFnServer(sqlda*, sqlca*) + 0x04de
    x00007F09A5D8AE47 sqlerKnownProcedure(int, char*, int*, sqlda*,
    sqlda*, sqlerFmpTable*, sqeAgent*, sqlca*) + 0x0247
    x00007F09A5D8CC7D sqlerCallDL(db2UCinterface*, UCstpInfo*) +
    0x06fd
    x00007F09A9ADE91E sqljs_ddm_excsqlstt(db2UCinterface*,
    sqljDDMObject*) + 0x09be
    x00007F09A9ADD9AE sqljsParseRdbAccessed(sqljsDrdaAsCb*,
    sqljDDMObject*, db2UCinterface*) + 0x007e
    x00007F09A5E74FEB sqljsParse(sqljsDrdaAsCb*, db2UCinterface*,
    sqeAgent*, bool) + 0x036b
    x00007F09A5E6F4E9 address: 0x00007F09A5E6F4E9 ; dladdress:
    0x00007F09A29F4000 ; offset in lib: 0x000000000347B4E9 ;
    x00007F09A5E6D93C address: 0x00007F09A5E6D93C ; dladdress:
    0x00007F09A29F4000 ; offset in lib: 0x000000000347993C ;
    x00007F09A5E6A999 address: 0x00007F09A5E6A999 ; dladdress:
    0x00007F09A29F4000 ; offset in lib: 0x0000000003476999 ;
    x00007F09A5E6A58B sqljsDrdaAsDriver(SQLCC_INITSTRUCT_T*) +
    0x00eb
    x00007F09A5B68C27 sqeAgent::RunEDU() + 0x0ad7
    x00007F09A7382227 sqzEDUObj::EDUDriver() + 0x00f7
    x00007F09A6B3A8C3 sqloEDUEntry + 0x0303
    x0000003631207851 address: 0x0000003631207851 ; dladdress:
    0x0000003631200000 ; offset in lib: 0x0000000000007851 ;
    x0000003630EE894D clone + 0x006d
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22622

  • 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

    2017-10-02

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

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

    IT19288

  • 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":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 March 2018