Syntax

To run the PowerExchange Logger in foreground mode, use the following syntax:

pwxccl [coldstart=Y|
N] [specialstart=Y|
N] [config=
directory/
myconfig_file] [cs=
directory/
mycondense_config_file] [license=
directory/
mylicense_key_file] [encryptepwd=
encrypted_encryption_password]

To run the PowerExchange Logger in background mode, add an ampersand (&) at the end of the statement, as shown in the following syntax:

pwxccl [coldstart=Y|
N] [specialstart=Y|
N] [config=
directory/
myconfig_file] [cs=
directory/
mycondense_config_file] [license=
directory/
mylicense_key_file] [encryptepwd=
encrypted_encryption_password] &

To run the PowerExchange Logger in background mode on an ongoing basis, even if the session is disconnected or the user logs out, add the prefix nohup, as shown in the following syntax:

nohup pwxccl [coldstart=Y|
N] [specialstart=Y|
N] [config=
directory/
myconfig_file] [cs=
directory/
mycondense_config_file] [license=
directory/
mylicense_key_file]] [encryptepwd=
encrypted_encryption_password] &

pwxccl [coldstart=Y|
N] [specialstart=Y|
N] [config=
directory\
myconfig_file] [cs=
directory\
mycondense_config_file] [license=
directory\
mylicense_key_file] [encryptepwd=
encrypted_encryption_password]

Parameter Descriptions

coldstart

Indicates whether to cold start or warm start the PowerExchange Logger. Enter one of the following values:

Y

Cold starts 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 starts 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 an error message. Default is N.

Do not specify both coldstart=Y and specialstart=Y. If you do, coldstart=Y takes precedence.

config

Specifies 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. The override file takes precedence over any override configuration file that you optionally specify with the PWX_CONFIG environment variable.

cs

Specifies 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.

If you specify this parameter, you must also specify coldstart=Y in the same pwxccl command.

If you specify this parameter and also specify the ENCRYPTEPWD parameter in the PowerExchange Logger configuration file, pwxccl.cfg, the parameter in the configuration file takes precedence. If you specify this parameter and also specify 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

Specifies 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. The override file takes precedence over any 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 PowerExchange capture processing from the point in the change stream that you specify in the pwxccl.cfg file. This start point overrides the restart point from the CDCT file for the PowerExchange Logger run. A special start does not delete any content from the CDCT file.

Use this parameter to skip beyond problematic parts in the source logs without losing captured data. For example, use a special start in the following situations:

You do not want the PowerExchange Logger to capture an upgrade of an Oracle catalog. In this case, stop the PowerExchange Logger before the upgrade. After the upgrade is complete, generate new sequence and restart tokens for the PowerExchange Logger based on the post-upgrade SCN. Enter these token values in the SEQUENCE_TOKEN and RESTART_TOKEN parameters in the pwxccl.cfg, and then special start the PowerExchange Logger.
You do not want the PowerExchange Logger to reprocess old, unavailable logs that were caused by outstanding UOWs that are not of CDC interest. In this case, stop the PowerExchange Logger. Edit the RESTART_TOKEN value to reflect the SCN of the earliest available log, and then perform a special start. If any of the outstanding UOWs that started before this restart point are of CDC interest, data might be lost.

Valid 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 token values from the CDCT file. Ensure that the SEQUENCE_TOKEN value in the pwxccl.cfg is greater than or equal to the current sequence token from the CDCT file.

Do not also specify the coldstart=Y parameter. If you do, the coldstart=Y parameter takes precedence.

N

Do not perform a special start. Perform a cold start or warm start as indicated by the coldstart parameter.

Usage Notes

Reads the pwxccl configuration file and displays the parameter settings in a series of PWX-15799 messages.
If the PowerExchange Logger does not find the pwxccl.cfg file it looks for dtlca.cfg.
Displays the name of the selected CAPI_CONNECTION statement in message PWX-21605.
Loads active capture registrations from the CCT file that match the database specified in the DBID parameter of the pwxccl.cfg file and that specify
Part
for the
Condense
option. Any registrations that do not apply are ignored.
If you use a group definition file, the PowerExchange Logger displays the statements in the file.
A group definition file defines groups of tables and capture registrations for which the PowerExchange Logger creates separate sets of log files.
The Controller task starts the Command Handler subtask and then the Writer subtask.
The PowerExchange Logger issues a series of Command Handler and Writer initialization messages. If you specified COLDSTART=Y in the startup statement and PROMPT=Y in the dbmover.cfg configuration file, the PowerExchange Logger prompts you to confirm the cold start by entering Y.
When the Writer initialization is complete, the following messages appear:
PWX-06111 Controller: All tasks initialization complete.
PWX-06455 Command Handler: received CAPTURE_STARTUP_COMPLETE event.
The Writer deletes any expired CDCT records and the PowerExchange log files associated with them.
If you entered VERBOSE=Y in the pwxccl.cfg file, the PowerExchange Logger issues detailed messages about this processing, such as the CDCT records and log files that were deleted, restart and sequence tokens, and CPU usage.
The Writer begins processing source data.

Example Output

C:\Informatica\PowerExchange9.0.0>pwxccl coldstart=y
PWX-33314 TIMEOUTS configuration parameter is deprecated
PWX-00607 PWXCCL VRM 9.0.0 Build V900_B10 started.
PWX-06036 Controller: Started 09/11/06 15:38:41.
PWX-33250 pwxccl started as a foreground process. pid="4500". coldstart="Y"

PWX-15799 ##PWXCCL <C:\Informatica\PowerExchange9.0.0\pwxccl.cfg> PARM INPUT FILE: START>>> .
PWX-15799 DBID=NORT000.
PWX-15799 DB_TYPE=MSS.
PWX-15799 EXT_CAPT_MASK=C:\Informatica\PowerExchange9.0.0\capture\condenseO.
PWX-15799 CHKPT_NUM=3.
PWX-15799 CHKPT_BASENAME=C:\Informatica\PowerExchange9.0.0\capture\condenseO.chkpt.
PWX-15799 COND_CDCT_RET_P=50.
PWX-15799 CONDENSENAME=msssvc.
PWX-15799 COLL_END_LOG=0.
PWX-15799 NO_DATA_WAIT=5.
PWX-15799 NO_DATA_WAIT2=60.
PWX-15799 FILE_SWITCH_VAL=20.
PWX-15799 FILE_SWITCH_CRIT=M.
PWX-15799 CAPT_IMAGE=BA.
PWX-15799 SIGNALLING=N.
PWX-15799 VERBOSE=Y.
PWX-15799 ##PWXCCL <C:\Informatica\PowerExchange9.0.0\pwxccl.cfg> PARM INPUT FILE: END(COMPLETE).

PWX-21605 Connection selected vpmsql found from covr< > tag< > type< MSS> int< FALSE> method< SRC_DFLT for TYPE>.

PWX-25802 Process pwxccl pid 4500 locked file C:\Informatica\PowerExchange9.0.0\CDCT_instance_NORT000_lockfile.lck
PWX-25802 Process pwxccl pid 4500 locked file C:\Informatica\PowerExchange9.0.0\capture\condenseO_loggerfiles_lockfile.lck

PWX-33261 Loaded "customer.1". Table "dbo.Customers". Tag "MSSNORT000customer1"
PWX-33261 Loaded "employee.1". Table "dbo.Employees". Tag "MSSNORT000employee1"
PWX-33262 Discarded "orderdet". Creator "dbo". Condense option "None"
PWX-33261 Loaded "orders.1". Table "dbo.Orders". Tag "MSSNORT000orders1"
PWX-33261 Loaded "products.2". Table "dbo.Products". Tag "MSSNORT000products1"
PWX-33262 Discarded "region". Creator "dbo". Condense option "None"
PWX-33263 4 registrations loaded

PWX-06112 Controller: Starting the capture subtasks.

PWX-06076 Starting Subtask program PWXCCLH.
PWX-06450 Command Handler: Starting.
PWX-32503 Command Handler initialization complete, listening on port 6988 .

PWX-26002 Command handler is waiting for the writer to initialize before accepting commands
PWX-06076 Starting Subtask program PWXCCLW.
PWX-06400 Condense: Starting. Instance=NORT000.
PWX-33232 No tokens specified. Cold start at the current data stream file position
PWX-33236 Type Y to confirm the cold start position or N to terminate the CCL logger
PWX-33238 Cold start accepted

PWX-09964 CAPI i/f: Current PowerExchange Logger log files position: Sequence=07D9000B0006000F0022003B111B45C00000000100000035000000630004FFFFFFFF Restart=07000000434158313730313031
PWX-09950 CAPI i/f: Connect OK. Sources = 4
PWX-25229 Started initialization of the CDCT Retention Array
PWX-25230 Retention array initialized. Files 1. CDCTs read 2. Allocated 300000. Memory 1500236
PWX-25211 Rolling back 2 CDCT records
PWX-06455 Command Handler: received CAPTURE_STARTUP_COMPLETE event.
PWX-06111 Controller: All tasks initialization complete.
PWX-26003 Command handler is accepting commands
PWX-25204 Deleted expired file "C:\Informatica\PowerExchange9.0.0\capture\condenseO.CND.CP091106.T1532001"
PWX-25221 Deleted 2 expired CDCT records and 1 files
PWX-33279 CPU total 390625. This file total 390625. CAPI Reads 0. Writing file 0. Other 390625

PWX-33274 CPU Total 406250. CAPI Read 0. Writing 0. File switching 0. Other 406250
PWX-33271 Writer starts reading source data. First processing cycle since initialization
PWX-09957 CAPI i/f: Read times out after 60 seconds
PWX-09967 CAPI i/f: End of log for time 09/11/06 15:38:44 reached

Caution

pwxsettask pwxccl 
   ["coldstart={Y|
N}"]
   ["config=
path/
pwx_config_file"] 
   ["cs=
path/
pwxlogger_config_file"]
   ["license=
path/
license_file"]

pwxsettask.sh pwxccl 
   ["coldstart={Y|
N}"]
   ["config=
path/
pwx_config_file"] 
   ["cs=
path/
pwxlogger_config_file"]
   ["license=
path/
license_file"]