A fix is available
APAR status
Closed as program error.
Error description
Q Apply always calls SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure which prevents supporting replication of non-temporal source to temporal target.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All Q Apply users * * 2- Synchronized Q Apply with TERM=Y * * 3- Q Apply * * 4- All SQL Apply users * * 5- Global Elite, AIX ETS * * 6- All SQL Apply users * **************************************************************** * PROBLEM DESCRIPTION: 1- Q Apply ignores STOP commands in * * TERM=N case after Apply encountering * * an error * * 2- Q Apply does not terminate when * * running in synchronized mode (MCG) * * with TERM=Y even when update to * * IBMQREP_MCGSYNC table fails due to DB2 * * termination * * 3- Q Apply always calls * * SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPOR * * ALHISTORY stored procedure which * * prevents supporting replication of * * non-temporal source to temporal target. * * 4- unexpected results when using event * * based scheduling * * 5- Suspension of monitor for zos * * doesn't work correctly. * * 6- SQL Apply failed in ASNLOAD with * * SQLCODE -104 * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- Q Apply does not terminate for STOP command when Q Apply starts with TERM=N and encounters an error 2- Q Apply with TERM=Y keeps looping on update of IBMQREP_MCGSYNC table even when the update fails with SQL -924 due to DB2 termination. 3- Ability needed in Q Apply to disable SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure call on agent connections to support non-temporal to temporal replication. 4- SQL Apply is applying changes beyond the timestamp specified in ASN.IBMSNAP_SUBS_EVENT.END_OF_PERIOD 5- Suspension of monitor for zos doesn't work correctly. 6- ASNLOAD failed when loading CCD target tables on LUW because the CAST function for IBMSNAP_OPERATION included some z specific syntax
Problem conclusion
1- Q Apply is changed to set the flag rcvdStop when Apply receives a stop command. 2- Q Apply browser will handle DB2 termination failures correctly when updating IBMQREP_MCGSYNC table by terminating the Q Apply program. 3- New Q Apply parameter RECORD_TEMPORALHISTORY=N/Y to control whether Q Apply threads will call SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure to disable DB2 from generating temporal history at target. RECORD_TEMPORALHISTORY=N default allows temporal source to temporal target replication, whereas, RECORD_TEMPORALHISTORY=Y will allow non-temporal source to temporal target replication. 4- If event-based scheduling is in use, set the upper limit of replication to max synchpoint in the UOW table with the synchtime <= END_OF_PERIOD. 5- After code changes, the suspension works fine. 6- Remove z specific syntax in the CAST function for IBMSNAP_OPERATION when ASNLOAD loads CCD target tables. Note: ASNCLP has been updated from db2_v111m4fp6 s2102031900. Function Level: 1140.103
Temporary fix
Comments
APAR Information
APAR number
PH33099
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
B33
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-01-05
Closed date
2021-02-10
Last modified date
2021-03-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI73894 UI73897 UI73895 UI73896
Modules/Macros
ASNACMD ASNADMSP ASNAISO ASNAPPLY ASNCAP ASNCATM ASNCCMD ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS ASNCLPQA ASNLOAD ASNMCMD ASNMON ASNQACMD ASNQAPAG ASNQAPP ASNQAROW ASNQASUB ASNQBRWZ ASNQCAP ASNQCCMD ASNQDEP ASNQEXRP ASNQMFMT ASNQSPIL ASNQXFMT ASNRBASE ASNTDIFF ASNTDSP ASNTRC ASN2BASE
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RB33 PSY UI73894
UP21/02/18 P F102
RB34 PSY UI73895
UP21/02/19 P F102
RB35 PSY UI73896
UP21/02/19 P F102
RB36 PSY UI73897
UP21/02/18 P F102
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B33"}]
Document Information
Modified date:
06 March 2021