PH35111: DB2 ADMIN TOOL: ONCODE 451 IN ADB2CMF COMPARE_VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Admin Tool: ONCODE 451 in ADB2CMF COMPARE_VIEW
  
  Altering a table with a view defined as SELECT * FROM <base
  table> by adding a column between existing columns results in
  MSGADB7350E ADB2CMF Module : ADB2CMF detected an ONCODE
  condition 451 in COMPARE_VIEW.  This may or may not be followed
  by MSGIEC212I 414-08 (close error).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 Administration Tool for z/OS users.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: ONCODE 451 in ADB2CMF procedure         *
  *                      COMPARE_VIEWS, possibly followed by     *
  *                      ABEND414 when adding a column to the    *
  *                      middle of a table and the table has a   *
  *                      view that includes all columns.         *
  ****************************************************************
  The customer's LE defaults were set to values that were too
  small to allow the necessary structures to be allocated to
  to analyze the change, which caused the reported ONCODE 451.
  
  For example:
  
  ADB7350E ADB2CMF Module : ADB2CMF detected an ONCODE
  condition 451 in COMPARE_VIEWS at <line no>
  ADB7380E ADB2CMP Module ADB2CMP - Severe error Alter has been
  stopped.
  

Problem conclusion

• The affected module has been updated to include an LE user
  options module that specifies settings sufficient to allow
  the requested operation to complete successfully.
  
  Search Keywords: ONCODE451
  

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

• ADB2CML
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI75090

     UP21/04/29 P F104

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.