Alternatively, you can manually create the triggers in the tables registered for change data capture. You can use the PowerExchange Navigator or the DTLUCBRG utility to generate DDL that includes the triggers. If you choose to create the triggers manually, make sure that you grant permissions to the user ID that is used to connect to the source database. For more information, see Granting Permissions Required for CDC.

If a table is removed from the list of registered tables, manually remove the triggers that were automatically created for the table. Afterwards, you can verify that the triggers have been removed by using the following query to list the triggers that currently exist for the table:

SELECT * FROM TRIGGERS WHERE SUBJECT_TABLE_SCHEMA=<
schema_name> and SUBJECT_TABLE_NAME=<
table_name>

To changen from Full Audit mode to PKLOG only or from PKLOG only to Full Audit mode, you must delete the table's capture registration or change the registration status to History. Then drop and re-create the triggers for that table. You can manually create the triggers or allow the PowerExchange Logger to create them automatically.