A fix is available
APAR status
Closed as new function.
Error description
Recreating and Starting DB2 Tables for IDAA/Replication after a change still does not function properly (Change Management).
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Administration and Object * * Comparison Tool for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: 1. Alter table (ALT) operation on an * * accelerator shadow table that is * * enabled for replication, results in * * shadow table left in incorrect status. * * * * 2. ALT operation does not detect * * and preseve correct replication status * * of accelerator shadow table. * * * * 3. Compare process (DDL vs Catalog) * * against an accelerator shadow table * * started for acceleration and * * replication does not generate * * statements for the same. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1. Alter table (ALT) operation on an accelerator shadow table that is enabled for replication, results in shadow table left in below incorrect statuses (assuming corresponding global change parameters are enabled on panel ADB2PCO "Options for Change Functions"). Incorrect result: Acceleration=disabled, Load=Initial Load pending, Replication=Unavailable Correct result: Acceleration=enabled, Load=Replication In Progress, Replication=enabled 2. ALT operation does not detect and preseve correct replication status of accelerator shadow table. This APAR adds a fix to preserve replication information (before recreate) and enable replication only for tables that were previously enabled. Warning will be issued if there are tables in the list that are not eligible for replication. Panel ADBPZAK 'Accelerated Table - Keys' will display below additional status fields: Acceleration status, Load status, Replication status and Replication Details. 3. Compare process (DDL vs Catalog) against an accelerator shadow table started for acceleration and replication does not generate statements for the same.
Problem conclusion
Temporary fix
Comments
Problems have been resolved. ×**** PE18/11/06 PTF IN ERROR. SEE APAR PH04870 FOR DESCRIPTION ×**** AE18/11/05 PTF IN ERROR. SEE APAR PH04870 FOR DESCRIPTION ×**** PE18/11/16 PTF IN ERROR. SEE APAR PH04870 FOR DESCRIPTION
APAR Information
APAR number
PH03088
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B20
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-09-21
Closed date
2018-10-05
Last modified date
2018-11-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI58930 UI58931
Modules/Macros
GOCCMP
Fix information
Fixed component name
DB2 OBJECT COMP
Fixed component ID
5697G6400
Applicable component levels
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUVH","label":"IBM Db2 Object Comparison Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
16 November 2018