PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.4.0 HotFix 1
- All Products
LOGPRT [database keywords] [CCATALOG=table_name] [PART=DBpartition_number] [FILE=file_name] [REPLACE={N|Y}] [RECSPERFILE=records_per_output_file] BLSN={begin_LSN|BVTS=begin_VTS} [ELSN=end_LSN] [EVTS=end_VTS] [RECS=records_to_select] [TRANID=transaction_ID] [LOGICAL={Y|N}] [UDB={N|MIN|FMT|MAX}] ;
Parameter | Description |
---|---|
CCATALOG | Name of the capture catalog table. |
PART | Database partition number. |
FILE | Name of the formatted log file. This overrides the default “<database name>.logprt“ file. |
REPLACE | Indicates whether to overwrite an existing file. Specify Y to overwrite an existing file. |
RECSPERFILE | An option that can be used to divide a large amount of output into multiple files. The generated file names have the format: database_name .first_lsn_value_in_file .logprt. If the FILE keyword has also been specified, the generated file names have the format: file_name . first_lsn_value_in_file . |
BLSN | A 6-byte DB2 Log Sequence Number (LSN), in hexadecimal digits, that indicates where the command is to start reading in the log. This value must represent an actual LSN. If fewer than 12 hexadecimal digits are specified, zeros are logically added to the left. BLSN defaults to the beginning of the active log. You must specify either BLSN or BVTS. |
BVTS | Starting timestamp that indicates where the command is to start reading in the log. You must specify either BLSN or BVTS. |
ELSN | A 6-byte DB2 Log Sequence Number (LSN), in hexadecimal digits, that specifies where the command is to stop. This value is not required to correspond to an actual LSN. If fewer than 12 hexadecimal digits are specified, zeros are logically added to the left. You can use this option to filter the output. ELSN defaults to the end of the log. You must specify either BLSN or BVTS. |
EVTS | Ending timestamp that indicates where the command is to stop. You can use it to filter the output. |
RECS | Number of records that indicates where the command is to stop. You can use this option to filter the output. |
TRANID | Criteria for filtering output. This option does not stop the reading of log records when transaction-end log records are processed. |
LOGICAL | DB2 log reading consists of reading actual DB2 log records and interpreting them into logical events (known as logical log records). The LOGICAL keyword can be used to force these log records to be printed in the file. Default is Y. |
UDB | Controls how “real” DB2 log records are formatted in the file. Valid options are:
|