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 show

For the source tables in the open configuration, shows the tables or columns for which database supplemental logging is not enabled, or shows all mapped and unmapped source tables.

For a DB2 source, shows the tables with DATA CAPTURE CHANGES set.

For a Microsoft SQL Server source, shows the tables with Change Data Capture enabled.

For an Oracle source, shows the columns that are included in supplemental log groups that Data Replication created and the primary keys and indexes for the source tables.

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

For Oracle sources, the supplog show command does not show the columns in supplemental log groups that were created outside of Data Replication.

Syntax

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

supplog show schema_mask.table_mask [-t] [-a]

For Oracle sources, use the following syntax:

supplog show schema_mask.table_mask [-t] [-a] [-c]

Parameters

The following table describes the command parameters:

Parameter	Description
`source_schema`	A mask for the name of the source schema or schemas. You can use the following wildcard characters in the 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`	A mask for the name of the source table or tables. You can use the following wildcard characters in the 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
-t	For DB2 and SQL Server sources, shows only the tables that do not have database supplemental logging enabled. For Oracle sources, shows only the tables with columns that are not in a supplemental log group that Data Replication created.
-a	Shows all mapped and unmapped tables for the specified source schema.
-c	For Oracle sources, shows only the columns in the specified source table or tables that are not included in a supplemental log group that Data Replication created.

Examples

For an Oracle source, the following command shows the columns that are not in a supplemental log group for the "tab1" table in the "src" schema:

supplog show src.tab1 -c

The following command shows all mapped and unmapped tables in the "src" schema:

supplog show src.* -a

Rename Saved Search

Table of Contents

Command Line Interface for the Server Manager

Command Line Interface for the Server Manager

supplog show

supplog show

Syntax

Parameters

Examples