PI96683: CM BATCH OR COMPARE ALTER ADD PRIMARY KEY DDL TRUNCATE IBM0441W ONCODE=150 STRINGSIZE CONDITION ADBPA PARSE ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ALTER of a table to add a primary key generates DDL where
  the keyword 'PRIMARY KEY' is truncated to 'PRI'.  This may
  result in the following errors when the generated DDL is
  executed:
  1.  IBM0441W ONCODE=150 The STRINGSIZE condition was
  raised.
  From entry point _Concnvs at compile unit offset >offset< at
  entry offset >offset< at address >address<.
  From entry point ALTERED_ADDPK at statement 10493 at compile
  unit offset >offset< at entry offset >offset<
  at address >address<.
  Note: Statement numbers are approximate and may vary somewhat,
  depending on release or other maintenance applied.
  2.  ADB2PA: The following statement could not be parsed:
  (ALTER TABLE statement displayed, with 'PRIMARY KEY' keyword
  truncated to 'PRI')
  Token number = >number<, Token =
  (
  Unsuccessful parse of DDL
  statement.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the CM Batch function       *
  *                 and Users of the Object Comparison Tool      *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: A change adding a PRIMARY KEY           *
  *                      constraint may result in parser         *
  *                      failure and IBM0441W ONCODE=150         *
  *                      error when the generated DDL is         *
  *                      executed.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When processing a change that adds a PRIMARY KEY
  CONSTRAINT to a table, the 'PRIMARY KEY' keyword
  may be truncated to 'PRI' in the generated DDL. When
  this DDL is executed, the following errors may result:
  
  IBM0441W ONCODE=150 The STRINGSIZE condition
   was raised.
  
  From entry point _Concnvs at compile unit offset >offset< at
   entry offset >offset< at address >address<.
   From entry point ALTERED_ADDPK at statement 10493 at
   compile unit offset >offset< at entry offset >offset<
   at address >address<.
  
  ADB2PA: The following statement could not be parsed:
  (followed by the ALTER TABLE statement, including
  'PRI' for 'PRIMARY KEY')
  
  Token number = >number<, Token =
   (
   Unsuccessful parse of DDL
   statement. )
  
  This issue appears to occur for long constraint names.
  

Problem conclusion

• 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:

  UI56654 UI56655

Modules/Macros

•    ADB2CMU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI56654

     UP18/06/22 P F806

• RC10 PSY UI56655

     UP18/06/22 P F806

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.