A fix is available
APAR status
Closed as program error.
Error description
If a table is used in one or more source subscriptions, but in none of them is it configured with Method set to Mirror, i.e. all are Method:Refresh, then it should not be required to set the table's DATA CAPTURE attribute to CHANGES. DATA CAPTURE should only need to be set to CHANGES if at least one of the subscriptions has configured the table to use Method:Mirror.
Local fix
No
Problem summary
**************************************************************** * USERS AFFECTED: Users of IIDR CDC for z/OS who use refresh * * only activity for synchronizing the source * * and target tables. * **************************************************************** * PROBLEM DESCRIPTION: IIDR CDC for z/OS requires a table's * * DATA CAPTURE attribute to CHANGES to * * perform Describe, Refresh and Mirror * * activity. However, Describe or Refresh * * activity has nothing to do with the Db2 * * log data, their DATA CAPTURE CHANGES * * restriction for the object table should * * be lifted. * **************************************************************** The table's DATA CAPTURE CHANGES restriction for Describe and Refresh activity has been found to be too wide reaching.
Problem conclusion
The table's DATA CAPTURE CHANGES restriction for Describe and Refresh activity has been removed.
Temporary fix
Comments
APAR Information
APAR number
PH52527
Reported component name
INFO SRVR CDC Z
Reported component ID
5655U7600
Reported release
A21
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-02-10
Closed date
2023-08-10
Last modified date
2023-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI93151
Modules/Macros
CHCBNDPL CHCDDTDB CHCDDTPF CHCSDTDB CHCTVHDL
Fix information
Fixed component name
INFO SRVR CDC Z
Fixed component ID
5655U7600
Applicable component levels
RA21 PSY UI93151
UP23/08/29 P F308
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":"SSTVMA","label":"InfoSphere Data Replication for DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 September 2023