PK79529: ALC PROCESS USES DROP/CREATE STRATEGY RATHER THAN ALTER STRATEGY WHEN TABLE HAS DATA CAPTURE CHANGES ATTRIBUTE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ALC command used a DROP/
  CREATE method to implement a change rather than ALTER when the
  table being referenced was defined with DATA CAPTURE CHANGES.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who         *
  *                 use the ALC function on a table with         *
  *                 DATA CAPTURE CHANGES enabled.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2  allows  certain  changes  to  be   *
  *                      made  with  the DB2  ALTER  statement   *
  *                      and  disallows others  when the table   *
  *                      is defined with DATA CAPTURE CHANGES.   *
  *                                                              *
  *                      ALC will conform to DB2 limitations and *
  *                      restrict  ALTER against  a DATA CAPTURE *
  *                      CHANGES table if the data type, length, *
  *                      precision or scale is being changed.    *
  *                                                              *
  *                      Other  operations allowed by DB2 ALTER, *
  *                      such  as adding a column  to the end of *
  *                      the table,  will be likewise allowed in *
  *                      ALC.  When not possible,  the operation *
  *                      will remain a "DROP" or "DROP-SC" (DROP *
  *                      with Skip Convert).                     *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When using  the ALC function to add a column at the end of the
  table, such a column may be allowed by the DB2 ALTER TABLE ADD
  COLUMN statement.
  
  In some circumstances, ALC was not using ALTER but was requiring
  that the table be dropped and recreated.
  

Problem conclusion

• The problem is fixed.
  

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

•    ADB27DUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK47570

     UP09/06/26 P F906

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.