Previous Topic: MUF_CDC_BASE_TABLE (MCT)Next Topic: MUF_CONFIG (MCF)


MUF_CDCL (MCL)

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.