Preface
Data Replication Overview
- Product Overview
- Data Replication Usage Scenarios
- Data Replication Sources and Targets
- Data Replication Architecture and Components
- Stages of Replication Processing
- Alternative Deployment Topologies
- Replication Configurations
Understanding Data Replication
- Overview
- Replicating Source Tables That Do Not Have a Primary Key Definition
- Start Point for the Extractor Task
- Apply Processing
- Checkpointing
- Recovery
  - Recovery Tables
- Tcl and SQL Scripts for Advanced InitialSync and Applier Processing of Data
- Database Character Set Conversion
- Replication of Database-Generated Values
- Generated Virtual Indexes
- Datatype Conversion Rules
- DDL Replication
Sources - Preparation and Replication Considerations
- DB2 for Linux, UNIX, and Windows Sources
- Microsoft SQL Server Sources
- MySQL Sources
- Oracle Sources
Targets - Preparation and Replication Considerations
- Amazon Redshift Targets
- Apache Kafka Targets
  - Preparing Apache Kafka Target Systems
  - Replication Considerations for Apache Kafka Targets
- Cloudera and Hortonworks Targets
  - Preparing Cloudera and Hortonworks Target Systems
- DB2 for Linux, UNIX, and Windows Targets
- Greenplum Targets
- Microsoft SQL Server Targets
- MySQL Targets
- Netezza Targets
- Oracle Targets
- PostgreSQL Targets
- Teradata Targets
- Vertica Targets
Starting the Server Manager
- Overview
- Installing the Server Manager as a Service on Windows
- Starting the Server Manager as a Windows Service
- Starting the Server Manager as a Daemon on Linux or UNIX
- Manually Starting the Server Manager
- Stopping a Server Manager Service or Daemon
- Uninstalling the Server Manager Service on Windows
Getting Started with the Data Replication Console
- Data Replication Console Interface
- Starting the Data Replication Console
Defining and Managing Server Manager Main Servers and Subservers
- Server Manager Main Server and Subservers
- Defining the Main Server and Its Subservers
- Editing Connection Information for a Main Server or Subserver
- Editing Microsoft SQL Server Instance Settings
- Editing Properties for the Main Server or a Subserver
- Viewing Information About the Server Manager System
- Configuring the Server Manager for HTTPS Communication
- Configuring the Server Manager Main Server to Run with NAT
- Associating a Subserver with Another Main Server
- Deleting Subservers
Creating and Managing User Accounts
- User Account Overview
- Users and Privileges
- Server Manager Security Policies
- Creating a User Account
- Changing the Password for Your User Account - Replication User
- Changing the Password for a User Account - idradmin User
- Unlocking a User Account
- Resetting the Password for the idradmin Account
Creating and Managing Connections
- Connections Overview
- Creating a Source or Target Connection from the Server Manager Tab
- Editing a Source or Target Connection
- Assigning a Different Source or Target Connection to a Configuration
Creating Replication Configurations
- Replication Configuration
- Task Flow: Creating a Replication Configuration
- Defining the Source Database
  - Configuring a Connection to an Oracle ASM Instance
  - Configuring Connections to Oracle RAC Sources for High Availability
    - Connecting to an Oracle RAC by Using Custom Connection Strings
    - Connecting to an Oracle RAC by Using a Virtual IP Address or Host Name
- Defining the Target Database
- Generating Target Tables and Audit Log Tables
- Generating Avro Schemas for Apache Kafka Consumers
- Handling Source Tables with Long Table or Column Names
  - Strategies for Handling Long Table Names
    - Editing the Audit Log Table Suffix
    - Manually Editing Target Table Names in an SQL Script
  - Strategies for Handling Long Column Names
- Mapping Source and Target Tables
- Defining Source Table Indexes
- Enabling Replication of DDL Changes at the Schema and Table Levels
- Customizing Apply Settings for Target Tables
- Configuring the Start Points for Extractor and Applier Tasks
- Configuring Conflict Resolution
  - Example of Configuring a MAXIMUM Resolution Strategy for Update Conflicts
  - Example of Configuring Custom Conflict Resolution
- Customizing Column Mappings
  - Filtering Column Data
- Adding Tcl and SQL Expressions
- Specifying the Database Logs from Which to Extract Data
- Configuring Runtime Settings
- Configuring Message Logging
- Saving Replication Configurations to the Main Server Manager
Materializing Targets with InitialSync
- InitialSync Overview
- Source Connectivity for Data Unload Operations
- Target Connectivity for Data Load Operations
- Sync Point Value
- InitialSync Handling of Target Table Constraints
- Considerations for Running InitialSync
- Task Flow: Using InitialSync to Materialize a Target
Scheduling and Running Replication Tasks
- Methods of Running Replication Tasks
- Types of Replication Tasks
- Schedule and Task Statuses
- Conflicting Replication Tasks
- Running Replication Executables Manually from the Data Replication Console
- Scheduling Replication Tasks
Implementing Advanced Replication Topologies
- Advanced Replication Topologies
- Configuring Continuous Replication
- Configuring Data Replication from One Source to Multiple Targets
- Configuring Bidirectional Replication
- Configuring Cascade Replication
- Loopback Avoidance for Replicated Data
Monitoring Data Replication
- Types of Monitoring Information
- Replication Statistics
- Intermediate Files
- Task Execution Logs
- Server Manager Logs
  - Viewing Server Manager Logs
- User Notifications
- Skipped Transaction Records
- Managing Open Transactions
Managing Replication Configurations
- Configuration Management Tasks
- Switching to Read or Edit Mode for a Replication Configuration
- Editing a Replication Configuration
- Changing the Server Manager Associated with a Replication Configuration
- Clearing User Replication Settings
- Managing Database Supplemental Logging
- Deploying Replication Configurations
- Generating a Reverse-Replication Configuration
- Exporting a Configuration File
- Importing a Configuration File
- Cleaning Replication Processing Information for a Configuration
  - Performing a Clean Operation on a Configuration
- Viewing Earlier Revisions of a Replication Configuration
- Viewing a List of Processed Database Logs
Handling Replication Environment Changes and Failures
- Manually Changing the Source Table Structure After Running Data Replication
- Updating an Avro Schema for Kafka Targets After Running Data Replication
- Adding Table Mappings Manually After Running Data Replication
- Resuming Replication After Upgrading a DB2 for Linux, UNIX, and Windows Source Database
- Resuming Replication After Upgrading a Microsoft SQL Server Source Database
- Handling Applier Failures
Troubleshooting
- Collecting Diagnostic Data for Troubleshooting
- Common Replication Problems
Data Replication Files and Subdirectories
- Files and Subdirectories
- Data Replication Script Files
- Executables Called from the Data Replication Console or Scripts
- Default.cfg File
- Other Key Files
- Subdirectories
Data Replication Runtime Parameters
Command Line Parameters for Data Replication Components
- About Command Line Parameters
- Command Line Parameters for InitialSync
- Command Line Parameters for the Extractor
- Command Line Parameters for the Applier
- Command Line Parameters for the Server Manager
Updating Configurations in the Replication Configuration CLI
- Replication Configuration CLI Overview
- Updating Source and Target Metadata for a Replication Configuration in the CLI
  - Updating Source and Target Metadata for a Configuration in Interactive Mode
  - Updating Source and Target Metadata for a Configuration in Non-interactive Mode
- Replication Configuration CLI Commands
DDL Statements for Manually Creating Recovery Tables
Sample Scripts for Enabling or Disabling SQL Server Change Data Capture
- Microsoft SQL Server Enterprise Edition
Glossary
- Applier
- Applier task
- apply cycle
- Audit Apply
- audit log table
- bidirectional replication
- binary log
- calculated columns
- cascade replication
- change data capture
- checkpoint processing
- Command Line Interface
- configuration file
- continuous replication
- Copy File task
- data files
- data warehouse appliance
- Edit mode
- External task
- Extractor
- Extractor task
- Flat File target
- global transaction
- heterogeneous replication
- Informatica Data Replication Console
- initial materialization
- InitialSync
- InitialSync task
- intermediate files
- log coordinates
- loopback avoidance
- Merge Apply
- Microsoft SQL Server Backup task
- primary target
- CDC Publisher
- Read mode
- recovery table
- Replication Configuration Command Line Interface
- replication configuration file
- replication statistics
- replication tasks
- routing
- secondary target
- Send File task
- Server Manager
- Server Manager Command Line Interface
- Server Manager Main server
- Server Manager subserver
- SQL Apply
- SQL Script Engine
- staging table
- Start Point
- subtask threads
- supplemental logging
- Sync Point
- Tcl expression
- Tcl Script Engine
- transaction files
- transactional replication
- virtual column
- virtual index

User Guide

9.7.0 HotFix 1

Back Next

Command Line Parameters for InitialSync

You can start the InitialSync executable or script from the command line with the following optional parameters:

CLEAN_SQLITEREP= {y| n }: Removes repository information about previous revisions to the current configuration file from the revision control system. Options are:
y
. Remove the repository information.
n
. Do not remove the repository information.; Default value:
n
CONFIG=path/configuration_SQLite_database_file: Specifies the path and file name of a configuration SQLite database file for a replication configuration.; Default value:
No default
CONN_ID=target_connection_ID: Specifies the connection ID of the connection to the target database that is specified in the replication configuration.; Default value:
No default
DBLINK={ y |n}: For Oracle-to-Oracle replication only, indicates whether Data Replication can use dblinks to perform initial synchronization. The use of dblinks can improve performance. Options are:
y
. Enables Data Replication to use dblinks.
n
. Prevents Data Replication from using dblinks.; Default value:
y
DEST_TABLES=table1,table2,…
DEST_TABLES=table_mask: Lists the target tables to resynchronize. If you set the
RESYNC
parameter to n
, use this parameter to selectively resynchronize the target tables.
You can include the question mark (?) and asterisk (*) wildcards to define a mask for the tables to select for resynchronization.; Default value:
By default, InitialSync includes all tables that require resynchronization.
DIRECT={y|n}: Indicates whether InitialSync uses a native database load utility or the appropriate ODBC driver to load data to the target. Options are:
y
. Use a native database load utility to load data to the target, if a load utility is available for the target type.
n
. Use the appropriate ODBC driver or the Oracle Call Interface (OCI) library to load data to the target. InitialSync does not support the use of ODBC drivers for loading
Vertica and
Netezza targets.; Default value:
n for Oracle targets, y for other targets
EXCLUDE_DEST_ TABLES=table1, table2,…
EXCLUDE_DEST_ TABLES=table_mask: Lists the target tables to exclude from resynchronization. If you set the RESYNC parameter to n
, use this parameter to selectively exclude target tables from the resynchronization.
You can use the question mark (?) and asterisk (*) wildcards to specify a mask for the tables to exclude.; Default value:
By default, InitialSync includes all tables for resynchronization.
JOURNAL_MODE={ DELETE |TRUNCATE|PERSIST|MEMORY|WAL|OFF}: Specifies the rollback journal mode for the SQLite repository that contains configuration information. Journal mode options are:
DELETE
. Delete the rollback journal at the conclusion of each transaction.
TRUNCATE
. Commit transactions by truncating the rollback journal to zero-length instead of deleting it.
PERSIST
. Prevent the rollback journal from being deleted at the end of each transaction.
MEMORY
. Store the rollback journal in volatile RAM.
WAL
. Use a write-ahead log instead of a rollback journal to implement transactions.
OFF
. Disable the rollback journal completely.
For more information about SQLite journal modes, see the SQLite documentation.; Default value:
DELETE for Linux and UNIX, WAL for Windows
Ensure that this parameter has the same value for all Data Replication components.
INSERT_ARRAY_ SIZE=size: Specifies the number of rows in the buffer when Data Replication uses ODBC connectivity to perform Inserts on the target.; Default value:
100
NON_EMPTY_DEST= {y| n }: For Teradata targets, specifies whether data is appended to target tables or written to empty tables. Options are:
y
. Write data to an empty Teradata target.
n
. Append data to an existing Teradata target.; Default value:
n
OUTPUT_LOG_NAME=file_name: Specifies the name of the first execution log file that contains output from the Data Replication component.; Default value:
No default
OUTPUT_LOGS_FOLDER=path_to_directory: Specifies the directory in which Data Replication creates execution log files for the Data Replication component.; Default value:
No default
RESYNC={ y |n|p}: Indicates whether InitialSync synchronizes all of the mapped target tables or a subset of the mapped target tables. Options are:
y
. Synchronize all of the mapped target tables with the source tables.
n
. Synchronize the set of tables that you specify in the DEST_TABLES parameter. You can optionally use the EXCLUDE_DEST_TABLES parameter to exclude some of these tables.
p
. Synchronize the mapped target tables for which Sync Point value is -1.; Default value:
y
SM_RUN_ID=server_manager_run_ID: Specifies the run ID that the Server Manager assigns to the replication task.
The Server Manager uses the SM_RUN_ID parameter to set the run ID value when starting a task. Do not change this parameter value or delete this parameter from the commands that start replication tasks.; Default value:
No default
SOURCE_DATA_IS_READ_ONLY={y| n }: For Oracle sources, indicates whether the InitialSync task uses a regular SELECT query or an Oracle Flashback query to unload data from the source. Options are:
n
. Run a Flashback query with a SELECT statement that includes an AS OF SCN clause. This query returns committed data that was current at the point in time that corresponds to a particular SCN.
y
. Run a regular SELECT query. Use this option to unload data from an Oracle standby database that is open for read-only access and does not support Flashback mode.
If you run the SELECT statement with AS OF SCN clause for an Oracle standby database that is open for read-only access, Oracle issues the following error message:
ORA-08183: Flashback cannot be enabled in the middle of a transaction; Default value:
n
SQLITE_CACHE_SIZE=cache_size: Specifies the maximum number of database disk pages that SQLite will hold in memory at once per open database file. The Data Replication component uses this parameter to open SQLite database files.; Default value:
16384 bytes
Change the default value only at the request of Informatica Global Customer Support.
SQLITE_PAGE_SIZE=page_size: Specifies the page size of the SQLite database when a new database is created, a database is still empty, or prior to running the VACUUM command. The Data Replication component uses this parameter to open SQLite database files.; Default value:
16384 bytes
Change the default value only at the request of Informatica Global Customer Support.
THREADS=number_of_threads: Specifies the number of threads for the InitialSync component. You can use this parameter to override the value that is specified in the configuration file.; Default value:
No default
TX_NAME=transaction_name: For Microsoft SQL Server, Oracle targets, specifies the transaction name for the transactions that the Applier and InitialSync use to replicate data.
For DB2 targets, specifies the application name that the Applier and InitialSync use to replicate data.
Use this parameter to override the default name of DbSyncTransaction.
Ensure that the transaction name or application name is valid for the target database. For more information about valid identifiers, see your target database documentation.; Default value:
DbSyncTransaction
UDP_SERVER_PORT=port_number: Specifies the User Datagram Protocol (UDP) port of the Server Manager through which the Data Replication component communicates with the Server Manager. Valid values are integers from 1 through 65535.; Default value:
8087
Ensure that the UDP_SERVER_PORT parameter value matches the value of the UDP_PORT parameter for the Server Manager.

Rename Saved Search

Table of Contents

User Guide

User Guide

Command Line Parameters for InitialSync

Command Line Parameters for InitialSync