Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Replication 9.7.0 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Data Replication Overview
  3. Understanding Data Replication
  4. Sources - Preparation and Replication Considerations
  5. Targets - Preparation and Replication Considerations
  6. Starting the Server Manager
  7. Getting Started with the Data Replication Console
  8. Defining and Managing Server Manager Main Servers and Subservers
  9. Creating and Managing User Accounts
  10. Creating and Managing Connections
  11. Creating Replication Configurations
  12. Materializing Targets with InitialSync
  13. Scheduling and Running Replication Tasks
  14. Implementing Advanced Replication Topologies
  15. Monitoring Data Replication
  16. Managing Replication Configurations
  17. Handling Replication Environment Changes and Failures
  18. Troubleshooting
  19. Data Replication Files and Subdirectories
  20. Data Replication Runtime Parameters
  21. Command Line Parameters for Data Replication Components
  22. Updating Configurations in the Replication Configuration CLI
  23. DDL Statements for Manually Creating Recovery Tables
  24. Sample Scripts for Enabling or Disabling SQL Server Change Data Capture
  25. Glossary

User Guide

User Guide

Back Next

Editing Properties for the Main Server or a Subserver

Editing Properties for the Main Server or a Subserver

From the Data Replication Console, the idradmin user can optionally edit properties of the Server Manager Main server or a subserver, such as the locations of certain file types and the log file name and logging level.
  1. On the
    Server Manager
     tab >
    Configs
     view, connect to the Main server as the idradmin user.
  2. On the
    Server Manager
     tab >
    Servers
     view, select a server.
  3. Click the
    Properties
     icon button on the Server Managers toolbar, or right-click the server row and click
    Properties
    .
    The
    Properties
     dialog box appears.
  4. On the
    Paths
     tab, change the locations of log files, configuration files, intermediate files, and backups of configuration SQLite database files and intermediate files for configurations that have undergone a Clean operation. Click the
    Browse
     button next to a field to browse to another location.
    Ensure that the path to a new location does not include space characters.
    Do not specify a Network File System (NFS) location for the configuration files. SQLite databases on NFS do not support access by multiple Data Replication processes at the same time. Access by multiple processes might cause incorrect behavior of the replication components.
    After you change a location for a file type, stop the Server Manager and copy any existing files to the new location manually. The Server Manager does not move these files to the new location. Even if you do not have existing files to copy to the new location, you must restart the Server Manager to apply the changes to file locations.
  5. On the
    Logs
     tab, change the log file base name, logging level, and log compression setting for the selected server.
    You can use GZIP or ZIP as the compression method, or turn off compression of the log file.
  6. On the
    Statistics
     tab, specify settings for storing and collecting replication statistics.
    You can edit the following properties that appear by default:
    Maximum number of the intermediate file records
    The maximum number of records with metadata for the processed intermediate files that Data Replication can store in the Extractor SQLite database and the buffer SQLite database. The Server Manager uses the buffer SQLite database to pass data to the Applier. When the number of intermediate-file records exceeds this maximum, the Server Manager deletes records down to the maximum limit, starting with the records for the earliest intermediate files. Default is 40000 records.
    Update frequency
    The number of milliseconds that must elapse before Data Replication updates replication statistics. This value determines the frequency at which Data Replication transmits statistical data from Server Manager subservers to the Server Manager Main server. Default is 30 milliseconds, which is equivalent to 33 updates per second.
  7. On the
    Advanced Settings
     tab, edit advanced properties for the selected Server Manager server.
    Edit any of the following properties:
    ApiThreadsCount
    If the DynamicThreadAllocation property of the Server Manager is set to 0, specifies the number of threads that the Server Manager uses for processing incoming requests from other Server Manager instances in unidirectional mode.
    If the DynamicThreadAllocation property of the Server Manager is set to 1, the Server Manager uses this property for the initial allocation of threads and then dynamically adjusts the thread count.
    Valid values: 1 through 1024.
    Default: 10.
    ApproximateCalculationStat
    Determines the accuracy level for replication statistics. This setting affects the end-to-end replication latency that is displayed in the Statistics windows. Options are:
    • 0
      . Provide replication statistics that have a higher level of accuracy but that are updated less frequently. When calculating replication statistics, the Server Manager analyzes only the intermediate files that contain committed transactions. If an intermediate file contains at least one open transaction, the Server Manager waits to get the intermediate file until the transaction commits and then calculates the statistical data for all transactions in the intermediate file. This processing can cause delays in getting the statistical data.
    • 1
      . Provide approximated replication statistics. When calculating the replication statistics, the Server Manager analyzes all of the intermediate files that the Applier processed. The intermediate files might contain open transactions. Use this option to avoid delays in getting the statistical data related to large transactions.
    Default: 1.
    After you edit this property value, you must restart the Server Manager.
    AsyncHttpEnabled
    Determines whether the Server Manager uses bidirectional or unidirectional connections. Options are:
    • 0
      . Use bidirectional connections between the Server Manager Main server and its subservers.
    • 1
      . Use unidirectional connections between the Server Manager Main server and its subservers. Unidirectional connections are slower than bidirectional connections. Use this option only if you deploy the Server Manager Main server in a local area network with NAT.
    Default: 0.
    BodyResponseTimeout
    Specifies the number of seconds that a Server Manager subserver must wait for a response from the Server Manager Main server in the unidirectional mode.
    Valid values: 0 through 2147483647 seconds.
    Default: 60 seconds.
    BuiltinTaskManagersCountThreads
    If the DynamicThreadAllocation property of the Server Manager is set to 0, specifies the number of threads for running replication tasks on one Server Manager. Each thread can run a single replication task.
    If the DynamicThreadAllocation property of the Server Manager is set to 1, this property is used for initial allocation of threads. If necessary, the Server Manager can create more threads and then close threads after they complete their tasks.
    Valid values: 1 through 1024.
    Default: 20.
    CdcJobsDisableMode
    For configurations with Microsoft SQL Server sources, determines whether the Server Manager disables the SQL Server [cdc].
    database_name
    _capture job and [cdc].
    database_name
    _cleanup job after enabling SQL Server Change Data Capture for the source database and tables. Options are:
    • 0
      . Do not disable the SQL Server CDC jobs. Select this option if you do not want Data Replication to disable the CDC jobs because the jobs have already been disabled from Microsoft SQL Server Management Studio or you accept that Data Replication might not capture all of the change data.
    • 1
      . Disable the SQL Server CDC jobs if SQL Server Change Data Capture is not enabled for any source tables when you create the configuration in Data Replication. If SQL Server Change Data Capture is enabled for any source table, the SQL Server CDC jobs are not disabled.
    • 2
      . Disable the SQL Server CDC jobs regardless of whether SQL Server Change Data Capture is enabled or not enabled for the source tables.
    Default: 0.
    If you select
    0
     or
    1
     and the Server Manager does not disable the SQL Server CDC jobs, disable Data Replication management of the secondary truncation checkpoint on the
    Runtime Settings
     tab >
    General
     view. Also, ensure that the Extractor reads both the transaction and backup logs. Otherwise, Data Replication might not capture all of the change data.
    The options for this property are equivalent to the options in the
    SQL Server CDC Jobs
     list in the
    Microsoft SQL Server Instances
     dialog box. When you edit either this property or the
    SQL Server CDC Jobs
     setting, the other value is updated to the equivalent setting. For more information, see Editing Microsoft SQL Server Instance Settings.
    CheckPasswordLength
    Main server only
    . Specifies the minimum number of characters that passwords for user accounts must contain. If this property is set to 0, the Data Replication Console and the Server Manager Command-Line Interface (CLI) do not enforce a minimum password length.
    Valid values: 0 through 2147483647.
    Default: 0.
    CountDaysOfStorageHistory
    Determines the number of days to store replication log data. This data includes the following types of information:
    • Statistical data on Extractor performance, which is displayed on the
      Extractor Performance
       tab of the Statistics window.
    • Data for Server Manager events related to schedules and tasks, which is displayed on the
      Server Manager
       tab >
      Logs
       view >
      Journal
       tab.
    Valid values: 0 through 2147483647 days.
    Default: 30 days.
    CountDaysofStorageSMLogs
    Determines the number of days to store Server Manager log data.
    Valid values: 1 through 60 days.
    Default: 30 days.
    CountThreads
    Specifies the number of active threads for receiving messages.
    After you edit this property value, you must restart the Server Manager.
    Valid values: 1 through 1024.
    Default: 50.
    After you edit this property value, you must restart the Server Manager.
    DBPasswordEncryptionEnabled
    Main server only
    . Indicates whether Data Replication encrypts the database passwords that you specify for the source and target database connections. Options are:
    • 0
      . Do not encrypt database passwords.
    • 1
      . Encrypt database passwords by using the AES256 encryption algorithm.
      If you did not add the Java Cryptography Extension (JCE) files to the
      JRE_HOME
      /bin/security folder, the Data Replication Console does not allow you to set this property to 1.
    Default: 0.
    DisableStatistics
    Determines whether the Server Manager collects statistics on the latency of the Extractor, Applier, and Send File tasks by heartbeat for continuous replication. Options are:
    • 0
      . Collect latency statistics.
    • 1
      . Do not collect latency statistics.
    Default: 0.
    DynamicThreadAllocation
    Determines whether the Server Manager dynamically allocates threads for running replication tasks, processing incoming requests, and sending messages to other Server Manager instances. Options are:
    • 0
      . Do not allocate Server Manager threads dynamically. Use the ApiThreadsCount, BuiltinTaskManagersCountThreads, IntermediateFileTransfersCountThreads, and SendCountThreads properties to specify the number of active threads that the Server Manager allocates to these tasks.
    • 1
      . Allocate Server Manager threads dynamically. The Server Manager uses the values of the ApiThreadsCount, BuiltinTaskManagersCountThreads, IntermediateFileTransfersCountThreads, and SendCountThreads properties for initial allocation of threads. If necessary, the Server Manager can create more threads and then close threads after they complete their tasks.
    Default: 1.
    ExpirationPeriodForPasswords
    Main server only
    . Specifies the number of days after which passwords for user accounts expire. When a password for a user account expires, the Server Manager Main server stops responding to user requests from the Data Replication Console. After the Server Manager Main server refuses a user request, the Data Replication Console or the Server Manager Command-Line Interface (CLI) in interactive mode prompts the user to change the expired password.
    Valid values: 0 through 24000 days. To disable password expiration, specify 0.
    Default: 0.
    FileAndLineLogInfoEnable
    Determines whether the Server Manager includes the source code file name and line number in Server Manager logs. The file name and line information indicate the location in the source code from which the Server Manager generated the logs. Options are:
    • 0
      . Do not include the file name and line information in Server Manager logs.
    • 1
      . Include the file name and line information in Server Manager logs.
    Default: 0.
    Generate Internal Master Key
    Main server only
    . Indicates whether the Server Manager Main server can generate an internal master key to encode master keys from an Oracle TDE wallet. Options are:
    • 0
      . Do not generate an internal master key.
    • 1
      . Generate an internal master key if one is not available in the directory that is specified in the
      Internal Master Key Path
       property.
    Default: 1.
    HeaderResponseTimeout
    Specifies the number of seconds that a Server Manager subserver must wait for the Server Manager Main server to retrieve a request in unidirectional mode.
    Valid values: 0 through 2147483647 seconds.
    Default: 5 seconds.
    HTTP
    Indicates whether to enable HTTP communication for the Server Manager. Options are:
    • 0
      . Do not use HTTP connections for the Server Manager.
    • 1
      . Use HTTP connections for the Server Manager.
    Default: 1.
    After you edit this property value, restart the Server Manager. This property is a synonym for the http command line parameter for the Server Manager.
    HttpCharsetEncoding
    Specifies the character encoding of the system console that runs the Server Manager.
    Default: UTF-8.
    HttpCurlDebug
    Indicates whether the libcurl library logs debug information about HTTP requests and responses between the Data Replication Console and Server Manager instances. This information is added to the Server Manager logs. Options are:
    • 0
      . Do not log libcurl debug messages about HTTP requests and responses.
    • 1
      . Log libcurl debug messages about HTTP requests and responses. Set this property to 1 only at the request of Informatica Global Customer Support.
    Default: 0.
    HttpCurlVerbose
    Indicates whether the libcurl library logs verbose information about HTTP requests and responses between the Data Replication Console and Server Manager instances. This information is added to the Server Manager logs. Options are:
    • 0
      . Do not log libcurl verbose messages about HTTP requests and responses.
    • 1
      . Log libcurl verbose messages about HTTP requests and responses. Set this property to 1 only at the request of Informatica Global Customer Support.
    Default: 0.
    HttpKeepAlive
    Indicates whether the Server Manager uses keep-alive sessions. Options are:
    • 1
      . Enable keep-alive sessions.
    • 0
      . Disable keep-alive sessions.
    Default: 1.
    After you edit this property value, you must restart the Server Manager.
    HttpKeepAliveTimeout
    If the Server Manager HttpKeepAlive advanced property is set to 1, specifies the amount of time, in milliseconds, that a TCP/IP keep-alive session that the Server Manager uses can have no network traffic before the session times out.
    Valid values: 0 through 2147483647 milliseconds.
    Default: 10000 milliseconds.
    HTTPS
    Indicates whether to enable HTTPS communications for the Server Manager. Options are:
    • 0
      . Do not use HTTPS connections for the Server Manager.
    • 1
      . Use HTTPS connections for the Server Manager.
    Default: 0.
    After you edit this property value, restart the Server Manager. This property is a synonym for the https command line parameter for the Server Manager.
    HttpsVerifyHost
    For HTTP and HTTPS protocols, indicates whether the Server Manager uses the libcurl library to verify that the machine that hosts the database server has the same name in the certificate as in the URL. Options are:
    • 0
      . Disable host verification.
    • 1
      . Enable host verification.
    Default: 0.
    HttpsVerifyPeer
    For HTTP and HTTPS protocols, indicates whether the Server Manager uses the curl open source tool and library to verify the authenticity of a peer certificate. When negotiating a TLS or SSL connection to the Server Manager, the server sends a certificate that identifies itself for verification. Options are:
    • 0
      . Disable peer verification.
    • 1
      . Enable peer verification.
    Default: 0.
    IFViewersMaxBlobSize
    Specifies the maximum size, kilobytes, of the LOB data that the Data Replication Console displays in the
    Intermediate File Information
     dialog box for the before- and after-image values in an intermediate file. If the size of the LOB data in the intermediate file exceeds the specified value, the Data Replication Console displays a truncated LOB value.
    When determining this value, consider the amount of memory that you allocated for the Java Virtual Machine (JVM.) The Data Replication Console might hang when allocating space for multiple large LOB values in the intermediate file.
    Valid values: 1 through 2147483647 KB.
    Default: 1 KB.
    IntermediateFilesDeleteLatency
    Determines the period of time, in seconds, that transaction-related statistics for intermediate files are available for viewing in the Data Replication Console after the Applier processes the files.
    Valid values: 0 through 2147483647 seconds.
    Default: 60 seconds.
    IntermediateFileTransfersCountThreads
    If the DynamicThreadAllocation property of the Server Manager is set to 0, specifies the number of threads that the Server Manager uses for running Send File tasks on one Server Manager.
    Valid values: 1 through 1024.
    Default: 10.
    If the DynamicThreadAllocation property of the Server Manager is set to the default value of 1, the Server Manager uses this property for initial allocation of threads and then dynamically adjusts the thread count.
    Internal Master Key Path
    Specifies the path to the internal master key that Server Manager instances use to encode master keys from an Oracle TDE wallet. The Server Manager Main server can generate an internal master key if the
    GenerateInternalMasterKey
     property is set to 1.
    Default: ./idrkey.
    After you edit this property value, you must restart the Server Manager.
    LimitValueFreeSpace
    Main server only
    . Specifies the minimum amount of available disk space, in gigabytes, required for the directories that the Server Manager Main server uses. These directories are logs, configs, output, and DBSYNC_HOME. When the amount of available disk space for these directories is less than this property value, the Server Manager is disabled. To enable the Server Manager again, create at least the amount of available disk space that is specified in the
    ThresholdValueFreeSpace
     property for each directory that the Server Manager Main server uses.
    Valid values: 0 through 2147483647 GB.
    Default: 1 GB.
    LogBytesToRead
    If you select an event message in the
    Event Viewer
     view and click
    Show Log
    , controls how many bytes of information that the Event Viewer reads from the Server Manager log and displays in the
    Log
     dialog box, after the selected message. You can use this property to limit the amount of log information that is displayed when you are trying to diagnose an error.
    Valid values: 200 through 1000000 bytes.
    Default: 2000 bytes.
    LoginBlockTimeout
    Main server only
    . Specifies the duration, in seconds, that a user account is locked out from logging in to the Server Manager Main server after the maximum number of failed login attempts that is specified in the MaxLoginAttempts property is reached.
    The idradmin user can unlock an account. To unlock an account, click
    File
     >
    Users
     and then click
    Unlock Account
     in the
    Users
     dialog box.
    Valid values: 1 through 2147483647 seconds.
    Default: 1800 seconds (30 minutes).
    LogReadIndent
    If you select an event message in the
    Event Viewer
     view and click
    Show Log
    , controls how many bytes of information that the Event Viewer reads from the Server Manager log and displays in the
    Log
     dialog box, before the selected message. You can use this property to limit the amount of log information that is displayed when you are trying to diagnose an error.
    Valid values: 50 through 1000000 bytes.
    Default: 2000 bytes.
    MaxChangesNumberInConfigForPatching
    Controls the method of processing the configuration file. When Data Replication synchronizes the configuration file with the configuration file that is stored in the Server Manager SQLite subsystem, it calculates the difference between these files. If the change record volume is less than the maximum value that this property specifies, Data Replication processes only the change records. Otherwise, Data Replication processes the entire configuration file.
    Valid values: 0 through 2147483647 rows or lines.
    Default: 1000 rows or lines.
    MaxLoginAttempts
    Main server only
    . Specifies the maximum number of times that users can try to log in to the Server Manager Main server from the Data Replication Console or the Server Manager CLI. If a user fails to enter a correct password after the specified number of retries, the Server Manager locks out the user account for the duration that is specified in the LoginBlockTimeout property.
    To allow users an unlimited number of login attempts, set this property to 0.
    Valid values: 1 through 2147483647.
    Default: 5.
    MaxRequestSize
    Specifies the size of the buffer, in bytes, that is allocated to each Server Manager thread for receiving messages. Increase this value if the Data Replication Console fails to save your configuration.
    Valid values: 1 through 2147483647 bytes.
    Default: 1048576 bytes.
    After you edit this property value, you must restart the Server Manager.
    MonitoringEnable
    Main server only
    . Determines whether Data Replication monitors the amount of available disk space for the Server Manager Main server directories and the creation of a new Server Manager log file each time the number of hours specified in the
    PeriodForSwitchSMLog
     property elapses. Options are:
    • 0
      . Do not enable the monitoring of available disk space and the creation of new log files at the PeriodForSwitchSMLog interval.
    • 1
      . Enable the monitoring of available disk space and the creation of new log files at the PeriodForSwitchSMLog interval.
    Default: 1.
    NotDeleteIntermediateFiles
    Controls whether the Server Manager automatically deletes the intermediate files after the Applier processes them. Options are:
    • 0
      . Delete the intermediate files.
    • 1
      . Do not delete the intermediate files.
    Default: 0.
    Number of restart attempts
    Specifies the maximum number of restart attempts for replication tasks that run in continuous mode. If a replication task that runs in continuous mode fails, the Server Manager tries to restart the task at adaptive intervals that are based on the
    TaskMaxTimeOut
     and
    TaskResetTimeoutTime
     properties. After the Server Manager reaches the specified maximum number of restart attempts without restarting the task, the Server Manager reports a task failure.
    Valid values: 1 through 2147483647.
    Default: 3.
    Number of tables per query for Microsoft SQL Server Change Data Capture
    For Microsoft SQL Server Standard Edition sources, determines the maximum number of source tables for which SQL Server enables Change Data Capture in response to each Server Manager request.
    Valid values: 1 through 2147483647.
    Default: 10000.
    After you edit this property value, you must restart the Server Manager.
    PassThroughFileQueueSize
    Specifies the maximum internal queue size, in kilobytes, for chunks of subserver task log files that pass through the Main server. After the log file chunks pass through the Main server, you can download the log files from the Data Replication Console. If the log file queue size is greater than this property value, the Server Manager does not place additional chunks of subserver task log files in the queue until the Server Manager has processed the accumulated chunks.
    Valid values: 1 through 2097152 KB.
    Default: 1000 KB.
    PasswordCaseSensitive
    Main server only
    . Indicates whether passwords for user accounts must include both lowercase and uppercase alphabetic characters. Options are:
    • 0
      . Passwords are not required to include both lowercase and uppercase alphabetic characters.
    • 1
      . Passwords must include both lowercase and uppercase alphabetic characters.
    Default: 0.
    PasswordContainNumbers
    Main server only
    . Indicates whether passwords for user accounts must include one or more numbers. Options are:
    • 0
      . Passwords are not required to include numbers.
    • 1
      . Passwords must include numbers.
    Default: 0.
    PasswordContainSpecialCharacters
    Main server only
    . Indicates whether passwords for user accounts must include one or more special characters. Options are:
    • 0
      . Passwords are not required to include special characters.
    • 1
      . Passwords must include at least one of the following special characters:
      • Space ( )
      • Exclamation mark (!)
      • Double quotation mark (")
      • Hash sign (#)
      • Dollar sign ($)
      • Percent sign (%)
      • Ampersand (&)
      • Single quotation mark (')
      • Left parenthesis (()
      • Right parenthesis ())
      • Asterisk (*)
      • Plus sign (+)
      • Comma (,)
      • Minus sign (-)
      • Full stop (.)
      • Slash (/)
      • Colon (:)
      • Semicolon (;)
      • Less than (<)
      • Equal sign (=)
      • Greater than (>)
      • Question mark (?)
      • At sign (@)
      • Left bracket ([)
      • Backslash (\)
      • Right bracket (])
      • Caret (^)
      • Underscore (_)
      • Grave accent (`)
      • Left brace ({)
      • Vertical bar (|)
      • Right brace (})
      • Tilde (~)
    Default: 0.
    PeriodForAskServersForFreeSpace
    Main server only
    . Specifies the interval, in seconds, between each Server Manager Main server check of available disk space for the Server Manager Main server directories.
    Valid values: 0 through 2147483647 seconds.
    Default: 60 seconds.
    PeriodForSwitchSMLog
    Specifies the maximum number of hours that a Server Manager instance can write messages to its log file. When this time period elapses, the Server Manager creates a new log file.
    If the size of a log file exceeds the
    Size For Switching SM Log
     property value before this time period elapses, the Server Manager creates a new log file.
    Valid values: 1 through 168 hours.
    Default: 24 hours.
    PeriodOfDumpStatistic
    Main server only
    . Specifies the number of hours that the Server Manager Main server keeps detailed statistics. After this period elapses, the Server Manager Main server archives the data. Archived statistics are accurate to 5 seconds.
    Valid values: 0 through 2147483647 hours.
    Default: 24 hours.
    RestartMSSQLInstance
    For configurations with Microsoft SQL Server Enterprise Edition sources, determines whether the Server Manager restarts the SQL Server instance in single-user mode to enable a dedicated administrator connection to the source database when you edit the Change Data Capture settings for source tables on the
    Map Tables
     tab. Options are:
    • 0
      . The Server Manager does not restart the SQL Server instance when you change the Change Data Capture setting for a source table.
    • 1
      . The Server Manager restarts the SQL Server instance every time you change the Change Data Capture setting for a source table.
    Default: 0.
    • For Microsoft SQL Server Standard Edition sources, the Server Manager always restarts the SQL Server instance when you change the Change Data Capture setting for a source table, regardless of the value for the RestartMSQLInstance property.
    • If the RestartMSSQLInstance property is set to 1, and you edit the Change Data Capture settings for source tables when multiple SQL Server sources are running on the source system, Data Replication might display an error. To avoid this error, Informatica recommends that you ensure that only the SQL Server Database Engine service is running before editing Change Data Capture settings.
    • The values for the RestartMSSQLInstance property are equivalent to the
      Restart instance
       check box on the
      Microsoft SQL Server Instances
       dialog box. When you edit either the check box selection or the Server Manager property value, the other value updates to match the new setting. For more information, see Editing Microsoft SQL Server Instance Settings.
    Seconds of sleep between operations for Microsoft SQL Server Change Data Capture
    For Microsoft SQL Server Standard sources, specifies the interval, in seconds, between Server Manager requests to SQL Server to enable Change Data Capture at the table level and at the column level. After the Server Manager sends a request to SQL Server to enable Change Data Capture at the table level, the Server Manager waits the specified number of seconds and then sends a request to SQL Server to enable Change Data Capture at the column level.
    Increase this property value if you configured the Server Manager to enable Change Data Capture for a large number of source tables in a single request. If the Server Manager fails to enable Change Data Capture for a subset of tables, increase this value and try to enable Change Data Capture from the Data Replication Console again.
    Valid values: 0 through 2147483647 seconds.
    Default: 5 seconds.
    SendCountThreads
    If the DynamicThreadAllocation property of the Server Manager is set to 0, specifies the number of threads that the Server Manager uses for sending messages.
    If the DynamicThreadAllocation property of the Server Manager is set to 1, the Server Manager uses this property for initial allocation of threads and then dynamically adjusts the thread count.
    Valid values: 1 through 1024.
    Default: 20.
    SendFileWaitTimeout
    Specifies the interval, in seconds, that the Send File task waits for the Extractor to notify the Server Manager that intermediate files have been transferred to the Applier. If this interval elapses without the notification being sent, the Server Manager retrieves the intermediate file information from the configuration SQLite database manually.
    Valid values: 10 through 3600 seconds.
    Default: 60 seconds.
    SendMailTimeOut
    Main server only
    . Specifies the interval, in minutes, that the Server Manager Main server waits after sending an email notification to users about a specific event type, such as an error, before sending another email notification for the same event type.
    Valid values: 0 through 2147483647 minutes.
    Default: 10 minutes.
    Server ID
    Specifies the unique key that identifies the Server Manager servers in a replication group of servers. The Server Manager Main Server generates keys for all of the subservers for security purposes. Do not modify this value.
    ServerActivityEnable
    Determines whether to enable server activity. This property is read-only. You cannot edit it in the Data Replication Console. The Server Manager determines the value of this property during the check for available disk space. If the available disk space is sufficient for the Server Manager, Data Replication selects the default value. Options are:
    • 0
      . Do not enable server activity.
    • 1
      . Enable server activity.
    Default: 1.
    Set NLS_LANG
    Indicates whether the Server Manager sets the NLS_LANG environment variable for the Oracle Extractor and Oracle Applier tasks. The Server Manager gets the NLS_LANG value from the replication configuration that includes the character sets of the source and target databases. Options are:
    • 0
      . Do not set the NLS_LANG environment variable. The Extractor and Applier tasks use the local NLS_LANG environment variable that is set for the database server on the operating system.
    • 1
      . Set the NLS_LANG environment variable for the Extractor and Applier tasks to the values from the replication configuration.
    Default: 1.
    Size For Switching SM Log
    Specifies the maximum size of a log file, in megabytes, to which a Server Manager instance logs messages. When this log size limit is exceeded, the Server Manager creates a new log file.
    If the time period that is specified in the
    PeriodForSwitchSMLog
     property elapses before this log size limit is exceeded, the Server Manager creates a new log file.
    Valid values: 1 through 100 MB.
    Default: 10 MB.
    SmtpCurlDebug
    Main server only
    . Indicates whether the libcurl library adds debug information about email notifications to the Server Manager Main server logs. Options are:
    • 0
      . Do not log libcurl debug messages about email notifications.
    • 1
      . Log libcurl debug messages about email notifications. Set this property to 1 only at the request of Informatica Global Customer Support.
    Default: 0.
    SmtpCurlVerbose
    Main server only
    . Indicates whether the libcurl library adds verbose information about email notifications to the Server Manager Main server logs. Options are:
    • 0
      . Do not log libcurl verbose messages about email notifications.
    • 1
      . Log libcurl verbose messages about email notifications. Set this property to 1 only at the request of Informatica Global Customer Support.
    Default: 0.
    SQLiteBusyTimeout
    Specifies the number of milliseconds that the Server Manager or a replication task can wait to open the configuration SQLite database to run a SQL statement when the database is locked by another task. When the specified time elapses and the database is still locked, the request to the SQLite database fails.
    Valid values: 1 through 2147483647 milliseconds.
    Default: 30000 milliseconds.
    SQLite_cache_size
    Controls the cache size that the SQLite subsystem uses.
    Valid values: 1 through 2147483647 bytes.
    Default: 16384 bytes.
    SQLite_page_size
    Controls the page size that the SQLite subsystem uses.
    Valid values: 1 through 2147483647 bytes.
    Default: 16384 bytes.
    StatisticCacheSendCount
    Specifies the number of statistic objects that the Server Manager sends at one time from an internal cache to the Main server. The Server Manager retrieves statistical data from intermediate files for the Extractor and Applier, stores the data in an internal cache, and then sends the data in batches to the Main server. This property regulates the amount of statistical data that Data Replication transmits between servers at one time. Use this property to limit the network load for large requests of statistical data.
    Valid values: 1 through 2147483647.
    Default: 100.
    StopChainWhenTaskFails
    Controls whether to stop the continuous schedule and all of the schedule tasks when one or more tasks in the schedule end abnormally. Options are:
    • 0
      . Do not stop the schedule and its running tasks. If one or more tasks in the schedule end abnormally, the remaining tasks continue to run.
    • 1
      . Stop the schedule and all of its running tasks.
    Default: 0.
    SynchronizePeriod
    Main server only
    . If you set the
    UseSynchronizationTimeWithMain
     to synchronize clock times of the Server Manager subservers with the clock time of the Main server, specifies the number of hours that must elapse before clock synchronization occurs.
    Valid values: 0 through 2147483647 hours.
    Default: 1 hour.
    TaskMaxTimeout
    Specifies the maximum duration, in minutes, of the adaptive sleep interval for replication tasks that run in continuous mode. If the Server Manager fails to start a replication task, it attempts to restart the task after 1 second. If the restart fails, the Server Manager doubles the interval. For subsequent restart attempts, the Server Manager continues to double the interval until this specified maximum timeout value is reached. Thereafter, the Server Manager uses this specified timeout value until the TaskResetTimeoutTime interval elapses.
    Valid values: 0 through 2147483647 minutes.
    Default: 5 minutes.
    TaskResetTimeoutTime
    Specifies the number of hours that a replication task must run in continuous mode before the Server Manager resets the adaptive sleep interval that is specified by the
    TaskMaxTimeOut
     property. If the task fails after the specified number of hours elapses, the Server Manager tries to restart the task after 1 second and thereafter at increasing intervals based on the
    TaskMaxTimeOut
     property.
    Valid values: 0 through 2147483647 hours.
    Default: 2 hours.
    ThresholdValueFreeSpace
    Main server only
    . Specifies the minimum amount of available disk space, in gigabytes, required for the Server Manager Main server to resume processing after it is disabled based on the
    LimitValueFreeSpace
     property value.
    Valid values: 0 through 2147483647 GB.
    Default: 5 GB.
    TimeToStoreBackups
    Specifies the number of days that the Server Manager Main server stores backups of configuration SQLite database files and intermediate files for configurations that were cleaned.
    Valid values: 0 through 24000 days.
    Default: 30 days.
    TimeoutOfEditConfig
    Specifies the maximum number of minutes that a configuration can remain locked to the Applier while the Server Manager is saving the configuration. The Server Manager locks a configuration if you allowed the tasks to keep running while the configuration is open for editing. When the specified time elapses, the Server Manager unlocks the configuration.
    Valid values: 0 through 2147483647 minutes.
    Default: 2 minutes.
    TmpDirectory
    Specifies the directory in which a Server Manager instance stores temporary service files for viewing intermediate files.
    Default:
    DataReplication_installation
    /tmp.
    TransferThreadPoolsCountThreads
    Specifies the maximum number of intermediate files that are transferred simultaneously.
    Valid values: 1 through 1024.
    Default: 10.
    After you edit this property value, you must restart the Server Manager.
    UseSynchronizationTimeWithMain
    Main server only
    . Indicates whether to synchronize the clock times of the Server Manager subservers with the clock time of the Main server. Options are:
    • 1
      . Disables clock synchronization. Select this option if you use the Network Time Protocol (NTP) to connect to Server Manager servers.
    • 0
      . Enables clock synchronization to get realistic replication statistics for the Send File task. The related
      SynchronizePeriod
       property determines the frequency of clock synchronization.
    Default: 1.
    WarningValueFreeSpace
    Main server only
    . Specifies the amount of available disk space, in gigabytes, below which the Server Manager Main server sends a notification that disk space is low. The Server Manager sends this notification only if the amount of available disk space is still greater than the minimum available disk space that is specified in the
    LimitValueFreeSpace
     property.
    Valid values: 0 through 2147483647 GB.
    Default: 10 GB.
  8. Click
    Save
    .
0 COMMENTS
We’d like to hear from you!