PK62818: INZT038E WHEN USING GDG DATASETS TO UNLOAD.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using GDG datasets to unload gets the following error:
  INZT038E TEMPLATE ERROR: UNSUPPORTED OPTION GDG
  INZU366I UTILITY RETURN CODE 8 ( REASON CODE 0x107a002 )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. msgINZU269E UNDEFINED VARIABLE &UQ.  *
  *                      IN TEMPLATE OUTDD is issued when &UQ.   *
  *                      is used within a TEMPLATE DSN model.    *
  *                      PB 9037                                 *
  *                      2. When unloading LOB tablespaces       *
  *                      within PDS that does not exist yet,     *
  *                      the process ends with RC 8 although     *
  *                      the data is correctly unload and the    *
  *                      following message is issued:            *
  *                      INZI331E FREE OF DDNAME SYSnnnnn        *
  *                       FAILED, RC=4, REASON=0x438 PB 9062     *
  *                      3. In DB2 V9, when unloading LOB        *
  *                      tablespaces SQLCODE=-452 (UNABLE TO     *
  *                      ACCESS THE FILE REFERENCED BY HOST      *
  *                      VARIABLE dsname (ddname). REASON CODE:  *
  *                       4) is issued and processing ends with  *
  *                      return code 8. PB 9188                  *
  *                      4. Enhancement : support GDG in         *
  *                      template. PB 9253                       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. inztyacc was changed to accept &UQ. Keyword.
  2. inzrunh was changed not to free the same ddname twice.
  3. inzgcxtr was changed to correctly set the SQLDA when lob
   files are involved.
  4. Module  inztyacc was changed to support GDG in TEMLPLATE
   specifications.
  

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:

  UK36344

Modules/Macros

•    INZRSAVE INZUTILB INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK36344

     UP08/05/14 P F805

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.