PK23386: OBJECT COMPARE DOES NOT USE ALTER TO CHANGE THE VOLATILE PARAMETER ON A TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare does not use the ALTER DDL command to change a
  table from VOLATILE to NOT VOLATILE and vice versa. I does a
  drop and recreate which always allows for the process to be
  compromised.
  

Local fix

• Process will work. Manual ALTER should be considered.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool, who     *
  *                 have the  VOLATILE parameter on a Table,     *
  *                 may be affected.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The ALTER DDL command  was not used  to *
  *                      change  a  table from VOLATILE  to  NOT *
  *                      VOLATILE  and  vice  versa.  It  did  a *
  *                      Drop and Recreate  which always allowed *
  *                      for the process to be compromised.      *
  *                      .*                                      *
  *                      A "Smart Alter" (ALTER)  was  not being *
  *                      used  to change the  VOLATILE parameter *
  *                      on a TABLE. It was being DROPed and the *
  *                      reCREATed. An  ALTER  needed to be done *
  *                      rather than a DROP/CREATE.              *
  *                      .*                                      *
  *                      The following problems are addressed:   *
  *                      * Table was being dropped and recreated *
  *                      rather than altered when the change was *
  *                      VOLATILE/NOT VOLATILE.                  *
  *                      * Incorrect  syntax  for ALTER SEQUENCE *
  *                      statement ( word "BY"  was  missing  in *
  *                      "INCREMENT BY").                        *
  *                      * Incorrect syntax was created for      *
  *                      ALTER SPECIFIC FUNCTION - Truncated     *
  *                      "STOP AFTER SYSTEM DEFAULT FAILURES"    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fixes.
  

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:

  UK14392 UK14393

Modules/Macros

•    GOC2CMF  GOC2CMS
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R310 PSY UK14392

     UP06/05/19 P F605

• R710 PSY UK14393

     UP06/05/19 P F605

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.