PH00823: UNDESIRED EXTRA BLANK IN THE FAKE TABLE NAME SPECIFIED IN THE GENERATED LOAD CONTROL CARDS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the LOADDDN option is specified and the target table name
  cannot be determined, not fully compliant LOAD control cards are
  generated where the INTO TABLE clause specifies a table name to
  be changed before use. This situation is reported by one of the
  INZU211I/INZU211W/INZU211E messages.
  In DB2 HPU versions 4.2, the unknown table name in the INTO
  CLAUSE was replaced by "????—?.—?". From DB2 HPU version 4.3 the
  unknown table name is replaced by the "—?.???? " substitution
  string which contains an extra blank. As a consequence, the
  required replacement to be done before using the LOAD control
  cards unexpectedly changes as well which can cause failures of
  the automated post-processing of the LOAD control cards.
  
  PB53575 PB 53575
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the LOADDDN option is specified    *
  *                      and the target table name cannot be     *
  *                      determined, not fully compliant LOAD    *
  *                      control cards are generated where the   *
  *                      INTO TABLE clause specifies a table     *
  *                      name to be changed before use. This     *
  *                      situation is reported by one of the     *
  *                      INZU211I/INZU211W/INZU211E messages.    *
  *                      In DB2 HPU versions 4.2, the unknown    *
  *                      table name in the INTO CLAUSE was       *
  *                      replaced by "????????.????????". From   *
  *                      DB2 HPU version 4.3 the unknown table   *
  *                      name is replaced by the                 *
  *                      "????????.???????? " substitution       *
  *                      string which contains an extra blank.   *
  *                      As a consequence, the required          *
  *                      replacement to be done before using     *
  *                      the LOAD control cards unexpectedly     *
  *                      changes as well which can cause         *
  *                      failures of the automated               *
  *                      post-processing of the LOAD control     *
  *                      cards.                                  *
  *                      pb53575                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzrload 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:

  UI57807

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI57807

     UP18/09/05 P F809

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.