Use DELETE TRANDATA to do one of the following:
DB2 LUW and DB2 on z/OS: Alters the table to DATA CAPTURE NONE.
Oracle: Disable supplemental logging.
Sybase: Disable replication.
SQL Server: Stops extended logging for a table.
By default, this command attempts to remove the supplemental logging of the key columns that are used by Oracle GoldenGate (can be the primary key, a unique key, KEYCOLS columns, or all columns) and also the scheduling columns. The scheduling columns are the primary key, all of the unique keys, and all of the foreign keys. To delete the logging of the Oracle GoldenGate key columns, but not the scheduling columns, include the NOSCHEDULINGCOLS option with DELETE TRANDATA. If ADD TRANDATA was issued with the ALLCOLS option, use DELETE TRANDATA with the ALLCOLS option to remove the supplemental logging of all of the columns, including the Oracle GoldenGate key columns.
Use the DBLOGIN command to establish a database connection before using this command. The user specified with this command must have the same privileges that are required for ADD TRANDATA.
Syntax
DELETE TRANDATA [container.]owner.table [NOSCHEDULINGCOLS | ALLCOLS]
[container.]owner.tableThe pluggable database (if this is an Oracle multitenant container database), owner and name of the table or file. A wildcard can be used for any name component.
NOSCHEDULINGCOLSPrevents the command from removing the supplemental logging of the scheduling columns of the specified table. The scheduling columns are the primary key, all of the unique keys, and all of the foreign keys of a table.
ALLCOLSRemoves the supplemental logging of all of the columns of the specified table.