Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

PWXCCL Command Parameters

PWXCCL Command Parameters

You can specify several optional parameters in the pwxccl command that starts the PowerExchange Logger.
The following table describes each parameter:
Parameter
Description
coldstart
Indicates whether to cold start or warm start the PowerExchange Logger.
Enter one of the following values:
  • Y
    . Cold start the PowerExchange Logger. You must specify coldstart=Y to perform a cold start. If the CDCT file contains log entries, the PowerExchange Logger deletes these entries.
  • N
    . Warm start the PowerExchange Logger from the restart point that is indicated in the CDCT file. If no restart information exists in the CDCT file, the PowerExchange Logger ends with error message PWX-33239.
Default is
N
.
config
The full path and file name for a dbmover configuration file that overrides the default dbmover configuration file in the installation directory. The override file must have a path or file name that is different from that of the default file.
This override file takes precedence over any other override configuration file that you optionally specify with the PWX_CONFIG environment variable.
cs
The full path and file name for the PowerExchange Logger configuration file. Use this parameter to specify a PowerExchange Logger configuration file that overrides the default pwxccl configuration file in the installation directory. The override file must have a path or file name that is different from that of the default file.
encryptepwd
A password in encrypted format for enabling the encryption of PowerExchange Logger log files. With this password, the PowerExchange Logger can generate a unique encryption key for each Logger log file. The password is stored in the CDCT file in encrypted format. For security purposes, the password is not stored in CDCT backup files and is not displayed in the CDCT reports that you can generate with the PWXUCDCT utility. You can generate an encrypted password from the PowerExchange Navigator.
If you specify this parameter, you must also specify coldstart=Y in the same pwxccl command.
If you specify this command-line parameter and the ENCRYPTEPWD parameter in the PowerExchange Logger configuration file, the parameter in the configuration file takes precedence. If you specify this command-line parameter and the ENCRYPTPWD parameter in the PowerExchange Logger configuration file, an error occurs.
You can set the AES algorithm to use for log file encryption in the ENCRYPTOPT parameter of the pwxccl.cfg file. The default is AES128.
For optimal security, Informatica recommends that you specify the encryption password in a pwxccl command for cold starting the PowerExchange Logger rather than in the pwxccl.cfg configuration file. This practice can reduce the risk of malicious access to the encryption password for the following reasons: 1) The encryption password is not stored in the pwxccl.cfg file, and 2) You can remove the password from the command line after a successful cold start. If you specify the encryption password in a pwxccl command for a cold start and then need to restore the CDCT file later, you must enter the same encryption password in the RESTORE_CDCT command of the PWXUCDCT utility.
To
not
encrypt PowerExchange Logger log files, do not enter an encryption password in the pwxccl command for a cold start or in the pwxccl.cfg configuration file.
license
The full path and file name for a license key file that overrides the default license.key file in the installation directory. The override file must have a file name or path that is different from that of the default file.
This override file takes precedence over any other override license key file that you optionally specify with the PWX_LICENSE environment variable.
specialstart
Indicates whether to perform a special start of the PowerExchange Logger. A special start begins PowerExchance capture processing from a point in the change stream that you specify. This start point overrides the restart point based on information in the CDCT file. A special start does not delete any content from the CDCT file.
Use this parameter to progress the restart point beyond problematic parts in the source logs. None of the data that was captured prior to the special start is lost.
Enter one of the following values:
  • Y
    . Perform a special start of the PowerExchange Logger from the point in the change stream that is defined by the SEQUENCE_TOKEN and RESTART_TOKEN parameter values in the pwxccl.cfg configuration file. You must specify valid token values in the pwxccl.cfg file to perform a special start. These token values override the restart point based on information in the CDCT file. To generate valid token values, contact Informatica Global Customer Support. Ensure that the SEQUENCE_TOKEN value in the pwxccl.cfg file is greater than or equal to the current sequence token from the CDCT file.
    Because assistance from Customer Support is required to generate valid sequence and restart tokens, Informatica recommends that you use the specialstart parameter only at the direction of Customer Support.
  • N
    . Do not perform a special start. Perform a cold start or warm start as indicated by the coldstart parameter.
Default is
N
.
Do not specify both coldstart=Y and specialstart=Y. If you do, the coldstart=Y parameter takes precedence.
In these parameters, the full path is required only if the file is not in the default location.

Back to Top

0 COMMENTS

We’d like to hear from you!