PI93188: DDLDDN: INZU366I WITH REASON CODE 0X32A00B IF DDLDDN FILE CONTAINS A FOR UPDATE CLAUSE IN THE "FREE BLOCK"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the file provided for the DDLDDN feature contains the
  clause "FOR UPDATE" in the free block (e.g. PCTFREE 10 FOR
  UPDATE 10 ), HPU issues error messages such as the following:
  
  INZI503E DDL ANALYSING: SYNTAX ERROR AT POS(52, 33)
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x32a00b) and fails
  with a completion code of 8.
  
  INZI503E INZI503 MSGINZI503E MSGINZI503 INZU366I INZU366
  MSGINZU366I MSGINZU366
  PB51333 Z631
  

Local fix

• Remove the FOR UPDATE clause that has no impact on the DB2 HPU
  processing.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the file provided for the DDLDDN   *
  *                      feature contains the clause             *
  *                      "FOR UPDATE" in the free block          *
  *                      (e.g. PCTFREE 10 FOR UPDATE 10 ), HPU   *
  *                      issues error messages such as           *
  *                       INZI503E DDL ANALYSING: SYNTAX ERROR   *
  *                        AT POS(x, y)                          *
  *                       INZU366I UTILITY RETURN CODE 8         *
  *                        (REASON CODE 0x32a00b) and fails      *
  *                        with a completion code of 8.          *
  *                      pb51333                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzmsgs and inzctrlh modules were changed.The oddlx2y
  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.