IBM Support

IT29021: DB2 TRAPS IN SQLRL_GET_FULL_NAME()

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

  • DB2 can trap with a stack like this:
    
    0        ossDumpStackTraceInternal
    1        ossDumpStackTraceV98
    2        OSSTrapFile::dumpEx
    3        sqlo_trce
    4        sqloEDUCodeTrapHandler
    5        _IO_ftrylockfile
    6        __intel_ssse3_rep_memcpy
    7        sqlrl_get_full_name
    8        sqlrl_userTempDropIndex
    9        sqlrlCGTTindexRefresh
    10       sqlrlc_systables_fetch
    11       sqlnq_cat_look2
    12       sqlnq_cat_look
    13       sqlnq_handle_qtb_extref_rec
    14       sqlnq_handle_named_ref
    15       sqlnq_handle_named_ref
    16       sqlnq_handle_named_ref
    17       sqlnq_handle_named_ref
    18       sqlnq_handle_named_ref
    19       sqlnq_handle_named_ref_in_src
    20       sqlnq_handle_table_ref
    21       sqlnq_handle_from_table_ref
    22       sqlnq_sem
    23       sqlnp_smactn
    24       sqlnp_parser
    25       sqlnp_main
    26       sqlnn_cmpl
    27       sqlnn_cmpl
    28       sqlra_compile_var
    29       sqlra_find_var
    30       sqlra_get_var
    31       sqlri_ddl_common
    32       sqlriddl
    33       sqlriSectInvoke
    34       sqlrr_execute_immediate
    35       sqlrr_execimmd
    36       sqljs_ddm_excsqlimm
    37       sqljsParseRdbAccessed
    38       sqljsParse
    39       sqljsSqlam
    40       sqljsDrdaAsInnerDriver
    41       sqljsDrdaAsDriver
    42       sqeAgent::RunEDU
    43       sqzEDUObj::EDUDriver
    44       sqloEDUEntry
    45       start_thread
    46       clone
    
    The purpose of this APAR is to help avoid the trap by producing
    an SQL0901N error instead.   In the db2diag.log a message like
    this will be added when this issue occurs:
    
    FUNCTION: DB2 UDB, catalog services, sqlrlCGTTindexRefresh,
    probe:14259
    RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29021

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

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

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

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

    IT30778

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:
16 January 2020