CONVERT_CDCT
|
If you upgrade to 9.5.1 HotFix 1 or later from an earlier release, you can issue this command to manually perform a one-time conversion of the CDCT file to the new format. Alternatively, the first time the PowerExchange Logger is warm started, it automatically converts the CDCT file to the new format.
The conversion creates a CDCT_ dbid file instance from the original CDCT file. Ensure that the
dbid value in the CDCT file name matches the DBID parameter value in the PowerExchange Logger pwxccl configuration file under which you run the command.
If the old CDCT file contains information for multiple database instances, you must run this command multiple times, once for each instance. Each time you run the command, ensure that the CS parameter points to the correct pwxccl configuration file for the instance.
|
CREATE_CDCT_BACKUP
|
Manually creates a backup of all records in a CDCT file instance for a source database based on the latest configuration incarnation.
The PowerExchange Logger automatically generates a backup at initialization and at termination.
|
DELETE_EXPIRED_CDCT
|
This command is deprecated but is still supported for backward compatibility. Use DELETE_EXPIRED_FILES instead.
|
DELETE_EXPIRED_FILES
|
Delete the log files for which the retention period has expired and the CDCT records that reference those expired logs. For this command to work, you must set the LOGGER_DELETES_EXPIRED_CDCT_RECORDS parameter to N in the pwxccl configuration file.
|
DELETE_ORPHAN_FILES
|
Delete PowerExchange Logger log files that are not referenced by any record in the CDCT file.
|
DERIVE_CDCT_BACKUP
|
If the CDCT file is corrupted or deleted and if a CDCT backup is not available or the latest available backup would result in significant reprocessing of data, use this command to derive a backup text file for recovery purposes.
The command uses the EXTERNAL_CAPTURE_MASK parameter value from the PowerExchange Logger configuration file or the
external_capture_mask positional parameter from the group definition file to generate a list of PowerExchange Logger log files. The command then uses the content of these log files to generate a text file that can be used as input to the RESTORE CDCT command.
Do not use this command if the PowerExchange Logger log files were also corrupted or deleted.
Use the PREVBACKUPFILE parameter to supply the name of the last available backup file. By using a previous backup file, you preserve more historic information in the CDCT file. Also, the utility will add any log files that were created since the backup was taken to the derived backup file.
|
REPORT_CDCT
|
Print the contents of the CDCT file. This information is primarily for debugging purposes.
For the current Logger configuration incarnation, the report shows:
Incarnation identifier, status, and reason (Rsn) for creation. The reason can be a cold start or a change in the configuration.
Source instance (or DBID) name and image type.
Number of groups defined in the group definition file. If no groups are defined, the default of 1 is used.
Begin and end timestamps.
Begin and end restart and sequence tokens.
For each Logger group, the report shows:
Group number and name.
Incarnation to which the group belongs.
Path to the group log files.
Registration count.
Log file count and the first and current log sequence numbers.
Oldest log file timestamp.
For each registration, the report shows:
Registration tag name and status.
Incarnation and group to which the registration belongs.
Default schema name.
|
REPORT_CDCT_FILES
|
Report the following information for each log file that is recorded in the CDCT:
Log file name and sequence number.
Configuration incarnation and group to which the log file belongs.
Record count, commit count, and whether any uncommitted data exists.
Begin and end timestamps.
Begin and end restart and sequence tokens.
File open timestamp.
File close timestamp.
|
REPORT_CONFIG
|
List the parameter settings that are defined in the associated PowerExchange Logger pwxccl configuration file.
If you created a group definition file and specified it in the GROUPDEFS parameter in the pwxccl file, the command also reports the group statements in the group definition file.
|
REPORT_EXPIRED_CDCT
|
This command is deprecated but is still supported for backward compatibility. Use REPORT_EXPIRED_FILES instead.
|
REPORT_EXPIRED_FILES
|
List the PowerExchange Logger log files for which the retention period has elapsed.
|
REPORT_FILES_BY_NAME
|
List PowerExchange Logger log files by file name. This information is based on directory information for the log files and not on the CDCT file.
For each file, the command reports the following information:
Date and time when the file was written.
Sequence number
Path and file name.
Also, the command reports the number of log files that match the default mask that is specified in the EXT_CAPT_MASK parameter of the pwxccl configuration file. If you specified a group definition file in the GROUPDEFS parameter of the pwxccl file, the command reports the number of log files that match any masks in the group definition file.
|
REPORT_FILES_BY_TIME
|
List PowerExchange Logger log files in the order in which they were created, from earliest to latest. This information is based on directory information for the log files and not on the CDCT file.
For each file, the command reports the following information:
Date and time when the file was written.
Sequence number.
Path and file name.
Also, the command reports the number of log files that match the default mask that is specified in the EXT_CAPT_MASK parameter of the pwxccl configuration file. If you specified a group definition file in the GROUPDEFS parameter of the pwxccl file, the command reports the number of log files that match any masks in the group definition file.
|
REPORT_ORPHAN_FILES
|
List PowerExchange Logger log files that are not referenced by any record in the CDCT file.
|
RESTORE_CDCT
|
Restore the CDCT file from a backup, up to a specific point in time. The PowerExchange Logger will reprocess any data that is later than this point in time.
After the restore operation completes, run the DELETE_ORPHAN_FILES command.
|
