Preface
Overview of the Server Manager Command Line Interface
Usage Scenario: Using Server Manager CLI Commands to Run Replications
- Prerequisite Tasks for Running Replication Jobs from the Server Manager CLI
- Using the Server Manager CLI to Run Replications
  - Running a Scheduled Replication Job in Interactive Mode
  - Running a Scheduled Replication Job in Non-interactive Mode with Scripts
Command Reference

Command Line Interface for the Server Manager

9.8.0 HotFix 1

Back Next

supplog remove

Disables database supplemental logging for DB2 for Linux, UNIX, and Windows, Microsoft SQL Server, and Oracle sources.

For DB2 sources, marks the tables for which you want to set DATA CAPTURE NONE.

For Microsoft SQL Server sources, marks the tables for which you want to disable Change Data Capture.

For Oracle sources, marks the columns in a source table that you want to remove from a supplemental log group.

The supplog remove command only marks the database supplemental logging settings that you want to disable. To persist the changes, run the supplog run command. Alternatively, you can run the supplog save command to save the settings to a script file that your DBA can run later.

Before you can run this command, you must run the supplog open command.

After the supplog remove command runs successfully, the Server Manager CLI lists the number of updated objects.

Syntax

For DB2 and Microsoft SQL Server sources, use the following syntax:

supplog remove source_schema.source_table [-a]

For Oracle sources, use the following syntax:

supplog remove source_schema.source_table [-a] [columns=column_name1,column_name2,...]

Parameters

The following table describes the command parameters for DB2 and Microsoft SQL Server sources:

Parameter	Description
`source_schema`	The name of the source schema or a mask for the name of the source schema or schemas. You can use the following wildcard characters in a mask: An asterisk (*) to match all characters A question mark (?) to match any single character Square brackets ([ ]) to match only one out of several characters
`source_table`	For DB2 sources, the name of the source table or a mask for the name of the source table or tables. For SQL Server sources, the owner name and the source table name, or a mask for the owner and table names. You can use the following wildcard characters in a mask: An asterisk (*) to match all characters A question mark (?) to match any single character Square brackets ([ ]) to match only one out of several characters
-a	For DB2 sources, include this parameter to set DATA CAPTURE NONE for the table or tables that match the `source_schema` and `source_table` parameter values and that are not mapped in the open configuration. For SQL Server sources, include this parameter to disable Change Data Capture for the table or tables that match the `source_schema` and `source_table` parameter values and that are not mapped in the open configuration.

The following table describes the command parameters for Oracle sources:

Parameter	Description
`source_schema`	The name of the source schema. No wildcards are allowed.
`source_table`	The name of the source table. No wildcards are allowed.
-a	If the table that matches the `source_schema` and `source_table` parameter values is not mapped in the open configuration, use this parameter to remove the columns in the source table from a supplemental log group.
columns	A comma-separated list of the columns that you want to remove from a supplemental log group that Data Replication created, or a mask for these columns. You can use the following wildcard characters in a mask: An asterisk (*) to match all characters A question mark (?) to match any single character Square brackets ([ ]) to match only one out of several characters If you omit this parameter, this command removes all of the columns from the supplemental log group. Removing all columns also removes any primary key or unique index columns from the supplemental log group. Informatica does not recommend removing all columns from supplemental log groups that contain primary keys or unique indexes.

Examples

For a DB2 source, the following command sets DATA CAPTURE NONE for all mapped and unmapped tables in all schemas:

supplog remove *.* -a
The supplog remove command executed successfully. Updated 1000 object(s).

For a Microsoft SQL Server source, the following command disables Change Data Capture for the mapped "tab1" table that has the "src" schema and "dbo" owner:

supplog remove src.dbo.tab1
The supplog remove command executed successfully. Updated 1 object(s).

For an Oracle source, the following command removes the "col1" column in the "tab1" table from a supplemental log group:

supplog remove src.tab1 columns=col1
The supplog remove command executed successfully. Updated 1 object(s).

Rename Saved Search

Table of Contents

Command Line Interface for the Server Manager

Command Line Interface for the Server Manager

supplog remove

supplog remove

Syntax

Parameters

Examples