You can delete registrations that are not in use from the capture environment. You can delete the registrations that are not in use on any database type on any machine.
You can issue the DELETE_INACTIVE_REGISTRATION command for the following status codes:
H
. History. The registration is no longer in use.
I
. Inactive. The registration has not yet been activated for use.
N
. Not Live. The registration has the status of H or I so is not being used for change data capture.
You can also issue DELETE_INACTIVE_REGISTRATION command with the following parameters to filter the registrations:
DATABASE_TYPE:
ADA for Adabas
AS4 for Db2 for i
DB2 for Db2 for z/OS
DCM for Datacom table-based sources
HAN for SAP HANA on Linux, UNIX, or Windows
IDL for IDMS log-based sources
IMS for IMS log-based and synchronous sources on z/OS
MSS for Microsoft SQL Server on Windows
MYS for MySQL on Linux, UNIX, or Windows
ORA for Oracle on Linux, UNIX, or Windows
PQS for PostgreSQL on Linux, UNIX, or Windows
UDB for Db2 on Linux, UNIX, or Windows
VSM for VSAM on z/OS
Default is the asterisk (*) wildcard, which means all database types are selected.
LAST_UPDATED_BEFORE_DATE. A date to use for filtering the registrations to delete. Delete registrations that were last updated earlier than the specified date.