Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList