PH44174: MISSING OR WRONG OPTIONS AT TABLE LEVEL IN LOADDDN IF FORMAT INTERNAL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The tableoptions specified through the LOADOPT option are not
  correctly taken into account as detailed below:
  
  incorrout 1: any keyword from the table_options is ignored
  incorrout 2: any keyword from the table_options except for
  NUMRECS is ignored
  incorrout 3: although the tableoptions specify ""NUMRECS
  integer"", the NUMRECS options from the generated LOAD control
  cards unduly specifies the actual number of unloaded rows
  instead of the integer specified by the LOADOPT tableoptions.
  
  
  This issue occurs if FORMAT INTERNAL is specified and the
  additional condtion depending on the symptom described below are
  fulfilled:
  
  incorrout 1: EXECUTE NO is specified
  incorrout 2 & 3: EXECUTE NO is not specified
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The table options applicable to a       *
  *                      logical unload -- as a result of either *
  *                      or both the VUU070/ULOPTLDB parmlib     *
  *                      parameter setting or the LOADOPT option *
  *                      in the UNLOAD statement -- are not      *
  *                      correctly taken into account as         *
  *                      detailed below:                         *
  *                      incorrout 1: any keyword from the table *
  *                      options is ignored                      *
  *                      incorrout 2: any keyword from the table *
  *                      options except for NUMRECS is ignored   *
  *                      incorrout 3: although the table options *
  *                      specify "NUMRECS integer", the NUMRECS  *
  *                      option in the generated LOAD control    *
  *                      cards unduly specifies the actual       *
  *                      number of unloaded rows instead of the  *
  *                      integer specified by "NUMRECS integer". *
  *                                                              *
  *                      This issue occurs if FORMAT INTERNAL is *
  *                      specified and the additional condition  *
  *                      depending on the symptom described      *
  *                      below are fulfilled:                    *
  *                      incorrout 1: EXECUTE NO is specified    *
  *                      incorrout 2 & 3: EXECUTE NO is not      *
  *                      specified                               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Missing or wrong options at table level in LOADDDN if FORMAT
  INTERNAL
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI79968

     UP22/04/09 P F204

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.