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 IT05113 Status: Geschlossen

LOAD UTILITY USING "FOR EXCEPTION" OPTION FAILED WITH -804 ERROR
AFTER FIXPACK UPGRADE

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
The load utility might fail with -804 error on the database 
upgraded to (FP4 or later) from (FP3 or FP3a) fix packs. 
This issue does not happen for databases created newly on Fix 
Pack 4 or later. 
The following is an example of the error for this issue. 
 
$ db2 -tvf load.sql 
LOAD FROM /home/v105fp3a/repro/load_test.dmp of del modified by 
dumpfile="/home/v105fp3a/repro/load.err" usedefaults 
codepage=1208 method P 
(1,2) replace into LOAD_TEST1 ( COL1,COL2 ) FOR EXCEPTION 
LOAD_TEST1_EX 
SQL3015N  An SQL error "-804" occurred during processing. 
 
SQL0804N  The application program parameters for the current 
request are not 
valid.  Reason code "100".  If a host variable or SQLVAR in the 
SQLDA is 
invalid then:  host variable/SQLVAR number = "", SQLTYPE = "", 
SQLLEN = "", 
host variable/SQLVAR type = "".  SQLSTATE=07002
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* User using LOAD Utility.                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to  DB2 version 10.5.0.7.                            * 
****************************************************************
Local-Fix:
Bind utility packages manually after applying the fix pack. 
example) 
db2 connect to dbname 
db2 bind ~/sqllib/bnd/@db2ubind.lst blocking all grant public
Lösung
The problem is first fixed in DB2 version 10.5.0.7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.10.2014
25.01.2016
25.01.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList