IBM Support

IT33068: TRAP ON SQLNO_COL_WIDTH_INLINE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Trap on sqlno_col_width_inline stack will look like:
    
    0      ossDumpStackTraceInternal
    1      ossDumpStackTraceV98
    2      OSSTrapFile::dumpEx
    3      sqlo_trce
    4      sqloEDUCodeTrapHandler
    5      __sigwait
    6      sqlno_col_width_inline
    7      sqlno_width_cols_iset
    8      sqlno_global_cols_width
    9      sqlno_cols_width
    10      sqlno_cost_ridbid_iscan
    11      sqlno_cost_iscan
    12      sqlno_prop_iscan
    13      ISCAN
    14      sqlno_index_scan
    15      sqlno_crule_index_scan
    16      sqlno_crule_access_root
    17      sqlno_crule_access
    18      sqlno_plan_qun
    19      sqlno_each_opr
    20      sqlno_walk_qun
    21      sqlno_call_sf
    22      sqlno_each_opr
    23      sqlno_walk_qun
    24      sqlno_call_sf
    25      sqlno_each_opr
    26      sqlno_walk_qun
    27      sqlno_call_sf
    28      sqlno_each_opr
    29      sqlno_walk_qun
    30      sqlno_call_sf
    31      sqlno_each_opr
    32      sqlno_top_qtb
    
    When using opt guidelines:
    
    /* <OPTGUIDELINES>
    <REGISTRY>
             <OPTION NAME='DB2_REDUCED_OPTIMIZATION' VALUE='GLUE
    ON,ZZJN OFF,ENABLE_TRANS_JOIN'/>
    </REGISTRY>
    </OPTGUIDELINES> */
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * TRAP ON SQLNO_COL_WIDTH_INLINE                               *
    ****************************************************************
    * 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

    IT33068

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

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

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

    IT38190

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSY

       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:
04 May 2022