IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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

  • RB10 PSN

       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