DB2 - Problem description
Problem IT09599 | Status: Closed |
LOAD WITH EXCEPTION TABLE FAILS WITH SQL3015N(-206) WHEN LOADING INTO V9.7 DATABASE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
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 Summary: | |
**************************************************************** * 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. | |
Solution | |
First Fixed in DB2 LUW v10.5 Fixpack 7. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.06.2015 21.01.2016 21.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |