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