PI92007: INCORRECT AUTOTAG FIELD AND WHEN CLAUSE WHEN ORIGINOBID OPTION IS SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When an unload from an image copy (COPYDDN option) specifies the
  "ORIGINOBID integer" and the "AUTOTAG integer" options, the
  field generated for the AUTOTAG option does not contain the
  expected value (i.e. the external representation of the rank of
  the SELECT statement within the unload statement) but the
  external representation of the OBID specified by the ORIGINOBID
  option.
  
  If the unload statement also requests the LOAD control cards be
  generated (LOADDDDN option), the WHEN clause generated in the
  LOAD statement is always the following.
  WHEN (1:integer) = X'0000'.
  
  PB51555
  

Local fix

• If all the SELECT statements are associated with a specific OBID
  (specified by the ORIGINOBID option), consider correcting the
  LOAD statement by replacing the WHEN (1:integer) = X'0000' by
  "WHEN (1:integer) = 'OBID' when OBID is the value specified by
  the corresponding ORIGINOBID option.
  
  Make the change for every SELECT statement for which an
  ORIGINOBID is specified.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When an unload from an image copy       *
  *                      (COPYDDN option) specifies the          *
  *                      "ORIGINOBID integer" and the            *
  *                      "AUTOTAG integer" options, the field    *
  *                      generated for the AUTOTAG option does   *
  *                      not contain the expected value          *
  *                      (i.e. the external representation of    *
  *                      the rank of the SELECT statement        *
  *                      within the unload statement) but the    *
  *                      external representation of the OBID     *
  *                      specified by the ORIGINOBID option.     *
  *                      If the unload statement also request    *
  *                      the LOAD controls cards be generated    *
  *                      (LOADDDN option), the WHEN clause       *
  *                      generated in the LOAD statement is      *
  *                      always WHEN (1:integer) = X'0000'.      *
  *                      pb51555                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzmsgs and inzctrlh modules were changed.The inzctrlh
  module was 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

•    INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI53962

     UP18/02/23 P F802

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.