PI91711: INZI503E IF DDLDDN SPECIFIES IMPLICITLY HIDDEN OR INLINE LENGTH OR GENERATED ... AS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A syntax error is reported by the INZI503E DDL ANALYSING: SYNTAX
  ERROR AT POS(line, column) message when attempting to unload the
  data from an image copy using the DDLDDN feature. This can occur
  if the DDL provided for the DDLDDN feature specifies a CREATE
  TABLE statement involving either of the following clauses:
  -          IMPLICITLY HIDDEN
  -          INLINE LENGTH integer
  -          GENERATED ALWAYS AS ( ...
  -          GENERATED AS ( ...
  
  PB51438
  

Local fix

• consider removing the clause if it does not affect the result
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A syntax error is reported by the       *
  *                      INZI503E DDL ANALYSING: SYNTAX ERROR    *
  *                      AT POS(line, column) message when       *
  *                      attempting to unload the data from an   *
  *                      image copy using the DDLDDN feature.    *
  *                      This can occur if the DDL provided for  *
  *                      the DDLDDN feature specifies a CREATE   *
  *                      TABLE statement involving either of     *
  *                      the following clauses:                  *
  *                                                              *
  *                      - IMPLICITLY HIDDEN                     *
  *                      - INLINE LENGTH integer                 *
  *                      - GENERATED ALWAYS AS ( ... )           *
  *                      - GENERATED AS ( ... )                  *
  *                      pb51438                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzmsgs and inzctrlh modules were changed.The oddlx2 and
  oddlx2y modules were 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.