PK54119: MSGINZT034E TEMPLATE ERROR: WITH REASON CODE 0X12DA003 WHEN THE TEMPLATE IS CODED WITH :SELNUM.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INZT034E TEMPLATE ERROR: TEMPLATE template REDEFINES DSNAME
  PREVIOUSLY GENERATED FROM TEMPLATE template
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x12da003)
  when GLOBAL OPTIONS TEMPLATESET( NUMBER = :SELNUM );
  is set in the UNLOAD SYSIN.
  ADDITIONAL SYMPTOMS:
  
  1)Error INZI330E when using LISTDEF and TEMPLATE:
    Error message INZI330E is issued in DB2 V8 when variable &DB
    or &TS is used in a template, and the tablespace is specified
    with a LISTDEF. For objects created before DB2 V8, and for
    which the DBNAME or the TSNAME is shorter than 8 characters,
    the generated dsname contains trailing blanks for these
    variables. PB 9022
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following are for R220/R310:        *
  *                      1. An abend S878-10 occurs after        *
  *                      processing a large number or            *
  *                      partitions or LDS in the same           *
  *                      execution of HPU. The getmain error     *
  *                      occurs because all available memory     *
  *                      below the 16mb line is used.            *
  *                      The following are for R310:             *
  *                      2. The limit to 8 characters of user    *
  *                      defined variables in the TEMPLATESET    *
  *                      is suppressed. This can be used to      *
  *                      enter a variable that would generate    *
  *                      several qualifiers, separated by a dot. *
  *                      3. SELNUM defined by a TEMPLATESET at   *
  *                      the GLOBAL level is not correctly       *
  *                      evaluated when another TEMPLATESET      *
  *                      redefines another variable in the       *
  *                      UNLOAD command. Error message INZT034E  *
  *                      may be  issued if several select        *
  *                      statements try to create the same       *
  *                      dataset.                                *
  *                      4. Error INZI330E when using LISTDEF    *
  *                      and TEMPLATE:                           *
  *                      Error message INZI330E is issued in     *
  *                      DB2 V8 when variable &DB or &TS is used *
  *                      in a template, and the tablespace is    *
  *                      specified with a LISTDEF. For objects   *
  *                      created before DB2 V8, and for which    *
  *                      the DBNAME or the TSNAME is shorter     *
  *                      than 8 characters, the generated        *
  *                      dsname contains trailing blanks for     *
  *                      these variables.                        *
  *                      5. Potential abend S0C4 in in function  *
  *                      otmplateItemClone( ), when using a      *
  *                      template.                               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module UDBCRRTS was changed to free correctly its workarea
  between the processing of 2 LDS.
  2. Not a bug.
  3. Module inzctrlh, function inzctrlhDetermineTemplateUserVar
  was changed to correctly process the user defined variables.
  4. Module otmplate, function otmplateItemSubstitute was changed
  to do a strip on trailing blanks on content of template
  variables.
  5. Module olistdef, olistdefCreateCharFromSqlvar was changed to
  fix the overlay problem.
  

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:

  UK31801 UK31802

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK31801

     UP07/12/06 P F712

• R310 PSY UK31802

     UP07/12/06 P F712

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.