DB2 - Problem description
Problem IT36227 | Status: Closed |
PUSHDOWN ON DECFLOAT CAN RETURN -901 IN SOME CASES | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem 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] | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.03.2021 26.10.2021 26.10.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |