PM53585: TEMPLATE ERROR: TEMPLATE OUTLOB REDEFINES DSNAME DSNAME PREVIOUSLY GENERATED FROM TEMPLATE TEMPLATE_NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A template error message such as the following
  
    INZT034E TEMPLATE ERROR: TEMPLATE OUTLOB REDEFINES DSNAME
             dsname PREVIOUSLY GENERATED FROM TEMPLATE
             template_name
  
  is issued and the unload fails with completion code 8 where a
  logical unload is processed in SQL mode and more than one LOB or
  XML column is to be unloaded as a LOB file.
  
  PB11355        INZT034E INZT034 MSGINZT034E MSGINZT034
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A template error message such as        *
  *                      "INZT034E TEMPLATE ERROR: TEMPLATE      *
  *                      OUTLOB REDEFINES DSNAME dsname          *
  *                      PREVIOUSLY GENERATED FROM TEMPLATE      *
  *                      template_name" is issued and the        *
  *                      unload fails with completion code 8     *
  *                      where a logical unload is processed     *
  *                      in SQL mode and more than one LOB or    *
  *                      XML column is to be unloaded as a LOB   *
  *                      file.                                   *
  *                      PB 11355                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzctrlh module was changed to produce unique values for
  the &DB, &TS, &SN, :COLNUM and :SELNUM template variables when
  the actual value cannot be determined.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK76342

     UP12/02/24 P F202

• R410 PSY UK76343

     UP12/02/24 P F202

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.