Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList