| 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 IC87538 | Status: Closed |
DPF LOAD MIGHT GET SQL0969N, IF DB2_COMPATIBILITY_VECTOR=ORA AND DATA LOADED INTO CHAR/VARCHAR DISTRIBUTION KEY ARE BLANK ONLY | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
There are 3 necessary conditions.
1. It must be a DPF Load.
2. Oracle compatibility mode is enabled, i.e. db2set
DB2_COMPATIBILITY_VECTOR=ORA.
3. Load blanks only into a column which is a distribution key
and whose type is CHAR/VARCHAR.
Following information can be observed in db2diag.log.
2012-10-24-23.25.47.242669-240 I9886E543 LEVEL: Error
PID : 19673 TID : 46912916941120PROC :
db2sysc 1
INSTANCE: sample NODE : 001 DB : SAMPLE
APPHDL : 0-63 APPID: *N0.sample.121025032012
AUTHID : SAMPLE
EDUID : 150 EDUNAME: db2lfrm0 1
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 125 bytes
LOADID: 34.2012-10-24-23.25.46.703427.0 (2;4)
Row found on wrong partition , 1, (nil), Detected in
file:sqluldat.C, Line:4154
2012-10-24-23.25.47.244413-240 I10430E1005 LEVEL: Error
PID : 19673 TID : 46912916941120PROC :
db2sysc 1
INSTANCE: sample NODE : 001 DB : SAMPLE
APPHDL : 0-63 APPID: *N0.sample.121025032012
AUTHID : SAMPLE
EDUID : 150 EDUNAME: db2lfrm0 1
FUNCTION: DB2 UDB, database utilities, sqluGetAndFormatRecords,
probe:4157
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 45 bytes
LOADID: 34.2012-10-24-23.25.46.703427.0 (2;4)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2769 sqlerrml: 0
sqlerrmc:<
sqlerrp : SQLULDAT
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000001
sqlwarn : (1) W (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users of version 9.7 on Linux, Unix and Windows * * platforms. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to DB2 LUW Version 9.7 Fix Pack 8 or higher levels. * **************************************************************** | |
| Local Fix: | |
N/A | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
| Solution | |
First fixed in DB2 LUW Version 9.7 Fix Pack 8. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.10.2012 08.04.2013 08.04.2013 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP8 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.8 |
|