One row exists for this table for each Change Data Capture Listener (CDCL) task defined to the current MUF.
The MUF_CDCL contains the following columns:
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
CDCL_DBID
|
SMALLINT |
No |
The database identifier specified with the CDCL_DBID Multi-User startup option, that is, the DBID containing the CDC table(s). |
|
CDCL_ERROR_REASON
|
CHAR(32) |
Yes |
Either contains blanks if no error has occurred since this listener was last opened successfully, or contains information about the last error. The many values that are possible are described in the explanatory description of message DB03153E. |
|
CDCL_NAME
|
CHAR(8) |
No |
Identifies the name, as specified in the CDCL Multi-User startup option, of the source MUF owning the LXX. |
|
CDCL_POLL_SECONDS
|
SMALLINT |
No |
Indicates how long, as specified by the CDCL_POLL Multi-User startup option, the CDCL task is to wait when there are no LXX records to process. Only used when the CDCL task operates in remote mode. |
|
CONTROL_ID
|
CHAR(1) |
No |
Identifies to the CDC monitor, as specified with the CDCM_ID Multi-User startup option, which level of support is being used by the CDCL task. This information is used in the CNTKR commands to track the correct records. The letter A is the valid control ID. |
|
CURRENT_DATETIME |
TIMESTAMP |
No |
Current date and timestamp from the MUF. |
|
CURRENT_STATUS
|
CHAR(7) |
No |
Is one of the following: OPN>CLS OPN>CLS indicates it is open but has been requested to close. CLS>OPN CLS>OPN indicates it is closed but has been requested to open. OPEN OPEN indicates it is currently open. CLOSED CLOSED indicates it is currently closed. |
|
DDNAME
|
CHAR(8) |
No |
Name of the DD statement used to read the LXX data set of the source MUF. |
|
DSNAME
|
CHAR(44) |
No |
Name of the data set that is the LXX of the source MUF. |
|
GAP_WAIT
|
CHAR(1) |
No |
The letter Y indicates that this CDCL task is in a GAP situation and waiting to be notified that it has been resolved and needs to try again. The letter N indicates that this CDCL task is not in a GAP situation. |
|
LAST_CDC_RECORD
|
TIMESTAMP |
Yes |
Timestamp in SQL format for the last log record that was subject to CDC. |
|
LAST_LOG_RECORD
|
TIMESTAMP |
Yes |
Timestamp in SQL format for the last log record processed, CDC or not. |
|
MAINT_PROCESSED
|
DECIMAL(11,0) |
No |
The number of maintenance log records processed that were subject to CDC. |
|
MODE
|
CHAR(10) |
No |
Can be LOCAL, REMOTE(DS), REMOTE(MP), REMOTE(WB), or REMOTE(XD) as follows: LOCAL LOCAL refers to local processing. REMOTE(DS) REMOTE(DS) indicates a remote status because the data set name does not match the local LXX. REMOTE(WB) REMOTE(WB) indicates a remote status because the MUF CDC startup option did not provide a work buffer. REMOTE(MP) REMOTE(MP) indicates that it is a remote status because the MUF currently has two or more MUFplex MUFs enabled. REMOTE(XD) REMOTE(XD) indicates that a remote status has been forced with a debugging option. Note: The debugging option just mentioned is intended only for use by those who have received information about it, that is, by CA. |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the MUF job name. |
|
PHYSICAL_READS
|
DECIMAL(11,0) |
No |
The number of I/O events directed to the LXX used by the source MUF. |
|
WRAP_COUNT
|
INTEGER |
No |
The number of times the CDCL task has read the LXX and found it newer than expected. This indicates that the LXX has completely circled around (wrapped) while the CDCL was running or stopped. |
|
Copyright © 2014 CA.
All rights reserved.
|
|