IBM Support

IT32451: PUSHDOWN ON DECFLOAT CAN RETURN -901 IN SOME CASES

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

  • It will affect typ: timestamp with setting
    labeled_duration_style to O or T. Because In db2 compiler: QGM
    the qnc object's type is LINT and now
    
    The issue is caused with the use of  timestamp, internally there
    is a mismatch of types which causes this issue. The code try to
    set a LINT value to a SINT variable, which cause -901:Value is
    too large for the buffer. The change will modify the variable
    type to LINT.
    
    
    
    2020-04-01-22.36.53.431072+180 E103430403E2826       LEVEL: Info
    (Origin)
    PID     : 23201                TID : 47797025892096  PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   : XXXX
    APPHDL  : 0-540                APPID: XXXXXXXXXXXXXXXXXXXXX
    AUTHID  : XXX                 HOSTNAME:XXXXXXXXXXXXXXXXXX
    EDUID   : 263                  EDUNAME: db2agent (FEDDB) 0
    FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
    MESSAGE : ZRC=0x80310008=-2144272376=SQLNN_E_2LARGE "value is
    too large"
    DATA #1 : String, 62 bytes
    An unexpected error was detected during statement compilation.
    DATA #2 : Boolean, 1 bytes
    true
    DATA #3 : Boolean, 1 bytes
    false
    DATA #4 : Boolean, 1 bytes
    true
    DATA #5 : Boolean, 1 bytes
    false
    DATA #6 : Hex integer, 4 bytes
    0x00000000
    DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 33
    sqlerrmc: Value is too large for the buffer
    sqlerrp : SQLNQ101
    sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0xFFFFFF9C      (6)
    0x00000000
    sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
    sqlstate:
    DATA #8 : Hex integer, 4 bytes
    0x00000040
    DATA #9 : String with size, 1000 bytes
    DATA #10: String, 452 bytes
    Compiler error stack for rc = -2144272376:
    sqlnn_cmpl[370]
    sqlnr_exe[200]
    sqlnr_rcc[100]
    sqlnr_seq[100]
    sqlnr_comp[110]
    sqlnr_after_prep1[5000]
    sqlnd_main[300]
    sqlnd_qtb_pda[10]
    sqlnd_qtb_pda[1100]
    sqlnd_qtb_pda[1100]
    sqlnd_qtb_pda[1200]
    sqlnd_opr_pda[70]
    sqlnd_oprhxp_qunset_vi_pda[350]
    sqlnd_hxp_qunset_vi_pda[620]
    sqlnd_exp_qunset_pda[2605]
    sqlnd_exp_qunset_pda[2605]
    sqlnd_exp_qunset_pda[2900]
    sqlnd_qnc_qunset_pda[400]
    sqlnq_qnc::field_value[100]
    

Local fix

Problem summary

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

Problem conclusion

  • Upgrade to db2_v111m4fp6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32451

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

  • Closed date

    2021-03-15

  • Last modified date

    2021-03-15

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

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

    IT36227

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:
16 March 2021