ENDUR—End unit of recovery

This command may be issued to instruct CDC for Db2® for z/OS® to dispose of a unit of recovery (transaction) by either queuing it for transmission to the target or discarding it.

ENDUR identifies:

  • the unit of recovery
  • the subscription that is currently active that is to be acted on
  • the manner of disposition for the unit of recovery
Attention: Normally, units of recovery are sent to the target system and applied there in the order in which their COMMIT actions are read from the Db2 log. Using the ENDUR command to force the disposition of a unit of recovery necessarily will interfere with this order. Changes within a unit of recovery that are subjected to the ENDUR,DISP=COMMIT command may be transmitted to the target side sooner than they would have been, or later than they should have been if they have been delayed somehow. Changes within a unit of recovery that are subjected to the ENDUR,DISP=ROLLBACK command will be discarded when they possibly should have been sent to the target side. All of these scenarios will desynchronize the source and target tables from which the manipulated units of recovery contained changes. These effects must be weighed against the need to use the ENDUR command to force changes from the subscription's staging space.
Read syntax diagramSkip visual syntax diagram FMODIFY procname,identifier,ENDUR, SUBSCR=subscription , URID=hhhhhhhhhhhh,MBR=hhhh,DISP=COMMITROLLBACK
SUBSCR
Identifies the subscription.

Only one subscription can be specified.

If the subscription is not actively mirroring, an error message will be issued.

URID
Identifies the 6-byte (12 hexadecimal characters) unit of recovery identifier for DB2 V10 or the 10-byte (20 hexadecimal characters) unit of recovery identifier for DB2 V11 and above.

This information can be obtained from the second data column of the staging space report.

MBR
Specifies the member identifier.

The MBR keyword must be specified with a non-zero value if and only if the connected Db2 subsystem is a member of a Data Sharing Group.

The MBR keyword should not be specified if the connected Db2 subsystem is not a member of a Data Sharing Group

DISP
Indicates the manner of disposition of the unit of recovery.

The following predefined values can be specified:

  • COMMIT—Artificially ends and queues the unit of recovery for transmission to the target system.
  • ROLLBACK—Artificially ends and discards the unit of recovery.

Example 1

F CHCAS,ENDUR,SUBSCR=NCTEST02,URID=02DFD6A05A0B,DISP=ROLLBACK

Artificially ends and discards the unit of recovery with an ID of 02DFD6A05A0b for subscription NCTEST02 that is defined in the CDC for Db2 for z/OS address space CHCAS.

Example 2

F CHCAS,ENDUR,SUBSCR=HQ01,URID=00D05AE98BEC06000000,DISP=COMMIT

Artificially ends and replicates the unit of recovery with an ID of 00D05AE98BEC06000000 for subscription HQ01 that is defined in the CDC for Db2 for z/OS address space CHCAS.