PH42270: ALT CONVERT COLUMN TO IDENTITY MISSING "START WITH" VALUE ADB2PA PARSE ERROR ADB9755E ONCODE = 612 MSG7954

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Converting a column to an identity column results in error
  ADB7955E in the DDL reader because the generated ALTER is
  missing a START WITH value. As a result, this message is
  received (for example):
  
  ADB2PA: The following statement could not be completely parsed :
  
  ADMIN ALTER TABLE >TABLE_NAME< REPLACE COLUMN "ID"
  DECIMAL(20, 0) NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START
  WITH INCREMENT BY 1 MINVALUE 5001 MAXVALUE 99999 NO CYCLE CACHE
  50 NO ORDER)
  
  This is followed by an error message:
  
  ADB7955E ADBCDTS An ONCODE condition 612 has been detected from
  location MSG7954
  
  ADB7955E ADBCDTS Error: " ONCODE()=" 612" ONLOC()="MSG7954"
  ONLINE()=" 54494" ONOFFSET()=" 422" ONCONDCOND()="
  ONCONDID()=" 7"
  
  
  Keywords:  ONCODE612; msgadb7955e;
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Errors ADB7955E and ONCODE 612 might    *
  *                      occur when trying to convert a column   *
  *                      to an identity column.                  *
  ****************************************************************
  Converting a column to an identity column might
  generate JCL that is missing a START WITH value. Executing this
  JCL can result in the following error:
  
  ADB7955E ADBCDTS An ONCODE condition 612 has been detected from
  location MSG7954ADB7955E ADBCDTS Error: " ONCODE()=" 612"
  ONLOC()="MSG7954" ONLINE()=" 54494" ONOFFSET()=" 422"
  ONCONDCOND()="ONCONDID()=" 7"
  
  Keywords: ONCODE612; msgadb7955e;
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI79298

Modules/Macros

• ADB27CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI79298

     UP22/02/17 P F202

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.