PI72450: UNEXPECTED MSGS INZT028E, INZU469E, INZU283E, INZC003E COULD BE ISSUED WHEN TEMPLATE IS USED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After the fix for either PTF UI37984 or UI37985 has been
  applied, an unload unduly fails with completion code 8 after
  having issued INZT028E TEMPLATE ERROR: RETPD AND EXPDL OPTIONS
  ARE EXCLUSIVES. This occurs if a TEMPLATE statement specifying
  RETPD provided through a TEMPLATE library (via the TEMPLATEDD
  option).
  
  PB47224
  

Local fix

• Specify the TEMPLATE statement directly in the unload control
  statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload z/OS.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the fix for either PI58263 or     *
  *                      PI61545 or PI58390, i.e. PTF UI37984    *
  *                      or UI37985 (PTF HZ475011 or             *
  *                      PTF HZ465033 for                        *
  *                      PB44626/PB44659/PB44640) has been       *
  *                      applied, an unload unduly fails with    *
  *                      completion code 8 after having issued   *
  *                      INZT028E TEMPLATE ERROR: RETPD AND      *
  *                      EXPDL OPTIONS ARE EXCLUSIVES. This      *
  *                       occurs if a TEMPLATE statement         *
  *                      specifying RETPD provided through a     *
  *                      TEMPLATE library (via the TEMPLATEDD    *
  *                      option).                                *
  *                      For example, the issue occurs with the  *
  *                      following unload statement:             *
  *                      PROCESS_OPTIONS TEMPLATEDD TEMPLATE     *
  *                      UNLOAD TABLESPACE                       *
  *                      DB2 YES                                 *
  *                      SELECT * FROM DSN81010.ACT              *
  *                      OUTDDN FOUT                             *
  *                      FORMAT DELIMITED                        *
  *                      LOADDDN SYSCNTL                         *
  *                      with a TEMPLATE library as follows:     *
  *                      //TEMPLATE DD *                         *
  *                      TEMPLATE FOUT DSN                       *
  *                       LABO.HPUZ0122.TEMP.P&PART.             *
  *                      UNIT WORK RETPD 6                       *
  *                      47224                                   *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzhyacc, inzmyacc, inztopt and oyacc modules were changed.
  

Problem conclusion

• APPLY the PTF.
  

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

•    INZTPMEM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI43510

     UP16/12/28 P F612

• R430 PSY UI43511

     UP16/12/28 P F612

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.