DB2 - Problembeschreibung
Problem IT09599 | Status: Geschlossen |
LOAD WITH EXCEPTION TABLE FAILS WITH SQL3015N(-206) WHEN LOADING INTO V9.7 DATABASE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When attempting to LOAD from a DB2 v10.5 Client into DB2 v9.7 Server, if we specify an exception table then the command fails with SQL3015N(-206), for example: LOAD CLIENT FROM ccdb235914958_node65534 OF DEL MODIFIED BY fastparse timeformat="HH:MM:SS" dateformat="YYYY-MM-DD" timestampformat="YYYY-MM-DD HH:MM:SS.UUUUUU" codep age=819 SAVECOUNT 0 WARNINGCOUNT 0 MESSAGES loadMsgs.out INSERT INTO DM.CHK_BULK_LOAD(EMP_CODE,EMP_NAME,DATE_ID_OF_JOINING,EMP_ID) FOR EXCEPTION DM.EXP_CHK_BULK_LOAD STATISTICS NO COPY NO DATA BUFFER 0 SORT BUFFER 0 CPU_PARALLELISM 0 DISK_PARALLELISM 0 INDEXING MODE AUTOSELECT ALLOW NO ACCESS SET INTEGRITY PENDING CASCADE DEFERRED; returns: SQL3015N An SQL error "-206" occurred during processing. SQL0206N "CONTROL" is not valid in the context where it is used. SQLSTATE=42703 db2diag.log: 2015-06-16-10.53.46.687756+060 I2099E513 LEVEL: Error PID : 13902 TID : 140737353852672 PROC : db2bp INSTANCE: db2inst6 NODE : 000 DB : XMETA APPID : 9.180.214.45.53657.150616095345 HOSTNAME: grubb FUNCTION: DB2 UDB, database utilities, sqluCheckSqlca, probe:1391 MESSAGE : SQL0206N "CONTROL" is not valid in the context where it is used. DATA #1 : String, 12 bytes sqlucktb.SQC DATA #2 : String, 44 bytes Error from Import/Export or Load Processing. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to in DB2 LUW v10.5 Fixpack 7 or Later. * **************************************************************** | |
Local-Fix: | |
Do not specify exception table (the FOR EXCEPTION clause) in the load command. | |
Lösung | |
First Fixed in DB2 LUW v10.5 Fixpack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.06.2015 21.01.2016 21.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |