DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2_LOAD_COPY_NO_OVERRIDE registry variable is unnecessarily 
checked during LOAD TERMINATE in the following scenario on DPF 
environment. 
 
1. DB2_LOAD_COPY_NO_OVERRIDE is improperly set. ("COPY YES TO 
/path_0/" is the proper setting) 
   db2set DB2_LOAD_COPY_NO_OVERRIDE=/path_0/ 
 
2. LOAD is started with "COPY YES TO /path_1/" option. 
   If "COPY NO" option is used, the option will be converted to 
the value of DB2_LOAD_COPY_NO_OVERRIDE. 
   LOAD ... INSERT ... COPY YES TO /path_1/ 
 
3. LOAD operation is interrupted, for example, by "force 
application" 
 
4. Terminate the interrupted LOAD. 
   LOAD ... TERMINATE ... COPY YES TO /path_1/ 
 
5. The registry variable is unnecessarily checked and SQL27965N 
is returned. 
   SQL27965N  The DB2_LOAD_COPY_NO_OVERRIDE registry variable 
value "/path_0/" is not valid.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* As same as Error description.                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 FixPack 5.                            * 
****************************************************************

Set the proper value for the registry variable.

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 9.7 FixPack 5.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

24.06.2011
28.12.2011
28.12.2011

9.7.FP5