DB2 - Problembeschreibung
Problem IC87538 | Status: Geschlossen |
DPF LOAD MIGHT GET SQL0969N, IF DB2_COMPATIBILITY_VECTOR=ORA AND DATA LOADED INTO CHAR/VARCHAR DISTRIBUTION KEY ARE BLANK ONLY | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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 | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 LUW Version 9.7 Fix Pack 8. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.10.2012 08.04.2013 08.04.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP8 | |
Problem behoben lt. FixList in der Version | |
9.7.0.8 |