PI76684: UNLOAD FAILS - INZI503E WHEN MINVALUE OR MAXVALUE OPERAND OF AN AS-IDENTITY-CLAUSE GREATER THAN 2147483647.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• change the DDL provided via DDLDDN so that any MAXVALUE or
  MINVALUE operand is less than or equal to 2147483647.
  
  PB48245
  

Local fix

• change the DDL provided via DDLDDN so that any MAXVALUE or
  MINVALUE operand is less than or equal to 2147483647.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload from an image copy (COPYDDN   *
  *                      option) specifying the DDL of the       *
  *                      source table via the DDLDDN option      *
  *                      fails with                              *
  *                      INZI503E DDL ANALYSING: SYNTAX ERROR    *
  *                       AT POS(x,y) where x, y is the          *
  *                       location of the MINVALUE or MAXVALUE   *
  *                       operand of an as-identity-clause       *
  *                       greater than 2147483647.               *
  *                      For example, the issue occurs if the    *
  *                      CREATE TABLE statement provided to the  *
  *                      unload via the DDLDDN file contains     *
  *                      the following definition:               *
  *                          DEC18_COLMUN         DECIMAL(18, 0) *
  *                       NOT NULL                               *
  *                            GENERATED BY DEFAULT              *
  *                            AS IDENTITY                       *
  *                              (START WITH 100, INCREMENT BY   *
  *                       1, NO CACHE, NO CYCLE,                 *
  *                               NO ORDER, MAXVALUE             *
  *                       999999999999999999, MINVALUE 1),       *
  *                      PB48245                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI46201

     UP17/04/19 P F704

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.