PH35277: INZU451E MESSAGE UNDULY ISSUED WHEN FORMAT INTERNAL AND TEMPLATE SWITCHING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.1 only) The unload fails after having unduly reported the
  following error :
  INZU451E OPTION FORMAT INTERNAL IS NOT VALID WHEN USED WITH MORE
  THAN ONE TABLE IN THE SAME DATASET.
  
  This occurs when the following conditions are fulfilled:
  - the unload specifies FORMAT INTERNAL
  - the output dataset for the unload (UNLDDN or OUTDDN option) is
  allocated through a TEMPLATE statement that specifies with the
  LIMIT option (template switching feature)
  - the LIMIT option specifies a TEMPLATE statement that specifies
  the same DSN name-expression as the ""parent"" TEMPLATE
  - the template switching feature is enabled (i.e; the value of
  VUU030/ULOPTNS parmlib parameter contains TEMPLATE_LIMIT(YES))
  

Local fix

• if applicable, consider specifying distinct DSN expression for
  the TEMPLATE statements involved in the TEMPLATE switching
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The unload fails after having unduly    *
  *                      reported the following error:           *
  *                      INZU451E OPTION FORMAT INTERNAL IS NOT  *
  *                      VALID WHEN USED WITH MORE THAN ONE      *
  *                      TABLE IN THE SAME DATASET.              *
  *                                                              *
  *                      This occurs when the following          *
  *                      conditions are fulfilled:               *
  *                      - the unload specifies FORMAT INTERNAL  *
  *                      - the output dataset for the unload     *
  *                      (UNLDDN or OUTDDN option) is allocated  *
  *                      through a TEMPLATE statement that       *
  *                      specifies with the LIMIT option         *
  *                      (template switching feature)            *
  *                      - the LIMIT option specifies a TEMPLATE *
  *                      statement that specifies the same DSN   *
  *                      name-expression as the ""parent""       *
  *                      TEMPLATE                                *
  *                      - the template switching feature is     *
  *                      enabled (i.e; the value of              *
  *                      VUU030/ULOPTNS parmlib parameter        *
  *                      contains TEMPLATE_LIMIT(YES))           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  INZU451E message unduly issued when FORMAT INTERNAL and TEMPLATE
  switching.
  

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

• INZ$$PRM INZBIND  INZTDSC  INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI75101

     UP21/05/07 P F105

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.