| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT35997 | Status: Closed |
SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR | |
| product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
| Problem description: | |
Your SQL statement might fail in DPF with a SQL0901 if it
contains the following:
- a UNION ALL
- each branch of the UNION contains one or more joins on columns
with mismatch data types
- one or more of the columns referenced in the join are in the
SELECT list
If you hit this failure, you will see the following in the
db2diag.log file:
2017-11-21-09.18.36.719390-300 I67997E1072 LEVEL:
Severe
PID : 24158 TID : 140734556530432 PROC :
db2sysc 1
INSTANCE: xxxxxx NODE : 001 DB : xxxxx
APPHDL : 0-53 APPID: xxxxxx
AUTHID : xxxxxx HOSTNAME: xxxxx
EDUID : 202 EDUNAME: db2agntp (xxxxx) 1
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:250
MESSAGE : ZRC=0x820B0001=-2113208319=SQLKB_NONSEVERE_PGM_ERROR
"Non-severe programming error."
DIA8532C An internal processing error has occurred.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 39
sqlerrmc: probe 040 in sqlktins(), msg=sqlkbndn()
sqlerrp : SQLRI088
sqlerrd : (1) 0x820B0001 (2) 0x00000001 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFE0C (6)
0x00000001
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2017-11-21-09.37.17.455219-300 I210047E524 LEVEL:
Error
PID : 29742 TID : 140734065796864 KTID : 1926
PROC : db2sysc 1
INSTANCE: xxxxxx NODE : 001 DB : xxxxxx
APPHDL : 0-55 APPID: xxxxxx
AUTHID : xxxxxx HOSTNAME: xxxxxx
EDUID : 149 EDUNAME: db2agntp (xxxxxx) 1
FUNCTION: DB2 UDB, bucket map services, sqlkbptn, probe:447
DATA #1 :
[0] unexpected src len > can_len (25 > 14) | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
| Local Fix: | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
| Comment | |
Upgrade to 11.5.6 or later | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.02.2021 21.06.2021 21.06.2021 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
