In the CCT file, the status code determines whether a registration is available for use. The CCT file can contain the following status codes:
A
. Active. The registration is available for use by the PowerExchange Logger for Linux, UNIX, and Windows, the PowerExchange Logger for z/OS, Condense, or a z/OS ECCR.
H
. History. The registration was active but now it is no longer in use because its status was changed to History.
I
. Inactive or "not yet used." You can create registrations with the Inactive status and then change them to an Active status later.
S
. Suspended. This status applies only to certain z/OS database types such as Adabas, Datacom, IDMS, and log-based IMS. The registration is temporarily disabled for change capture use. The ECCRs ignore updates for the registered source during the suspension window. Typically, registrations are suspended when you perform database maintenance or large cascade-delete operations. The PowerExchange Logger for Linux, UNIX, and Windows and PowerExchange Condense continue to read any change data that the ECCRs already captured before the suspension started. After the suspension window ends, you must restore the status back to A for the registrations to be used for change data capture again.
Also, PowerExchange uses the following status codes in PWXUCREG parameters and messages but not in the CCT file:
C
. Cancel Suspend. This value is passed in SQL when a PWXUCREG CANCEL_SUSPEND_REGISTRATION command has been issued to cancel a prior request to suspend registrations for certain z/OS database types.
D
. Drop Old Data. This value is passed in SQL when a PWXUCREG DROP_OLD_REGISTRATION_DATA command has been issued to set a special suspension window for certain z/OS database types.
L
. Live. This value is passed in SQL when registrations with the status A or S are retrieved from the PowerExchange Logger for Linux, UNIX, or Windows or from PowerExchange Condense. It can also be used in the PWXUCREG DISPLAY_REGISTRATION command that displays registration status information.
N
. Not Live. This value is passed in SQL with the PWXUCREG DELETE_INACTIVE_REGISTRATION command that deletes inactive registrations from the capture environment and the DISPLAY_REGISTRATION command so that registrations with status H and I are retrieved and processed.
R
. Reset timestamp. This value is passed in SQL when a PWXUCREG RESET_SUSPENSION_WINDOW command is issued to clear any activation and suspension timestamps that define the current suspension window for certain z/OS database types.