home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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