IBM Support

IT20169: ABEND POSSIBLE IN QUERY COMPILER DUE TO STALE POINTER ACCESS WHEN USING TRUSTED CONNECTIONS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An abend is possible in the DB2 query compiler due to stale
    pointer access when using trusted connections.
    In most cases the trap will be sustained and only an error
    returned to the application without further server impact.
    
    The db2diag.log will show :
    
    2016-07-02-00.09.10.685000+120 I3275977F547         LEVEL:
    Severe
    PID     : 11628                TID : 12836          PROC
    :db2syscs.exe
    INSTANCE: DB2INST1             NODE : 000           DB   :SAMPLE
    APPHDL  : 0-49474
    APPID:127.0.0.1.59555.160701223041
    AUTHID  : U018224              HOSTNAME: db2hostname
    EDUID   : 12836                EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler,
    probe:100
    MESSAGE : DIA0505I Execution of a component signal handling
    function has begun.
    
    and the stack trace in the trap file :
    
     <sqlnrDBConnInfo::nestedCall>
     <sqlnn_cmpl>
     <sqlnn_cmpl>
    <sqlra_compile_var>
    <sqlra_find_var>
    <sqlra_get_var>
     <sqlrr_prepare>
    <sqljs_ddm_prpsqlstt>
    <sqljsParseRdbAccessed>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * First fixed in DB2 version 11.1.2.2                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to DB2 version 11.1.2.2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT20169

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

  • Closed date

    2017-06-23

  • Last modified date

    2017-06-23

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

    IT19798

  • 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

[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020