Previous Topic: MUF_CBS_OLD_SETS (MCO)Next Topic: MUF_CDC_BASE_TABLE (MCT)


MUF_CDC (MCD)

This Dynamic System Table contains information about Change Data Capture (CDC) and the current MUF. The MUF_CDC table contains one row if the current MUF had CDC Multi-User startup option defining this MUF as a source MUF.

The MUF_CDC contains the following columns:

Column Name

SQL Data Type

Nullable

Description

CDC_BUFFER_SIZE

 

INTEGER

No

The CDC work buffer size, taken from the size parameter of the CDC Multi-User startup option.

CDC_DBID

 

SMALLINT

No

The database identifier (database ID) for the CDC database, taken from the CDCM_DBID Multi-User startup option (or default).

CDCM_ERROR_REASON

 

CHAR(16)

Yes

Is set to null if the CDCM task last request returned a blank return code. Otherwise, the field contains information about the request, the command, the table name if not an open or close, the external return code, and the internal return code.

CDCM_POLL_SECONDS

 

SMALLINT

No

The interval in seconds, as specified with the CDCM_POLL Multi-User startup option, between subsequent checkings (by the subtask) of the target MUF, to determine the status of the CDCL and CDCU programs.

CDCM_POLL_STATUS

 

CHAR(8)

No

Contains a value of either WAITENBL, CLOSED, WAITPOLL, WAIT-RQ-, or RUNNING, described as follows:

WAITENBL

WAITENBL means waiting on the source MUF to be enabled, where CDCM is not running its target MUF.

CLOSED

CLOSED means CDCM is currently defined as closed and is waiting for a CDCM_OPEN request.

WAITPOLL

WAITPOLL means CDCM is connected to the source MUF and is waiting for the next poll interval to verify the status again.

WAIT-RQ-

WAIT-RQ- means CDCM is connected or connecting to the source MUF and waiting on a request.

RUNNING

RUNNING means CDCM is actively running or waiting on a CP to run.

CDCM_SIDNAME

 

CHAR(8)

No

As specified with the CDCM_SIDNAME Multi-User startup option, identifies the target MUF to the CDCM subtask.

CDCM_SUBTSK_STATUS

 

CHAR(7)

No

Can be OPEN, CLOSED, CLS>OPN, OPN>CLS, OPN-ING, or CLS-ING as follows:

OPEN

OPEN indicates that the CDCM subtask is open.

CLOSED

CLOSED indicates that the CDCM subtask is closed.

CLS>OPN

CLS>OPN indicates that the CDCM subtask is closed, but you have requested it to open.

OPN>CLS

OPN>CLS indicates that the CDCM subtask is open, but you have requested it to close.

OPN-ING

OPN-ING indicates that the CDCM subtask is in the process of opening.

CLS-ING

CLS-ING indicates that the CDCM subtask is in the process of closing.

CDCM_WARN

 

SMALLINT

No

Identifies how many seconds, as specified with the CDCM_WARN Multi-User startup option, that the CDCL or CDCU program can fall behind the LXX before a warning message is issued. The CDCL task is measured from the last log record it saw compared to the current last log record on DASD. The CDCU task is measured from the oldest TSN record in the CDC database to the current last log record on DASD.

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.

LAST_CDC_RECORD

 

CHAR(6)

Yes

The time, given in minutes mm and seconds ss, that CDCL is behind in processing LXX records. If the time is greater than 999 minutes, the display shows +++:++. If the CDCM subtask has not yet successfully opened the CDCL, the time is technically unknown and is therefore indicated by UNKN.

LAST_LOG_RECORD

 

CHAR(6)

No

The time, given in minutes mm and seconds ss, that CDCU is behind in processing TSN records. If the time is greater than 999 minutes, the display shows +++:++. If the CDCU user task has not yet started, the time is technically unknown and is therefore indicated by UNKN.

MAINT_POLL_COUNT

 

INTEGER

No

At the time of the last CDCM poll, this is the count of MNT table records based upon the rows in the table returned from either a CNTTB or CNTKY command.

MAINT_REQUESTS

 

DECIMAL(11,0)

No

Count of maintenance requests defined as subject to CDC during the physical life of this MUF.

MUF_NAME

 

CHAR(8)

No

Name of the MUF specified in the MUF Multi-User startup option or the MUF job name.

MUFPLEX_NAME

 

CHAR(8)

No

If running full Data Sharing as a MUFplex, the name of the group.

TSN_POLL_COUNT

 

INTEGER

No

At the time of the last CDCM poll, this was the count of TSN table records based upon the rows in the table returned from either a CNTTB or CNTKY command.

USE_CNTTB

 

CHAR(1)

No

Provides information regarding the performance option, as specified with the CDCM_CNTTB Multi-User startup option, that allows the CDCM subtask to use CNTTB commands to determine the number of transaction sequence number (TSN) records and maintenance (MNT) LXX records in the CDC database. This count of records is checked at the polling intervals set with the CDCM_POLL Multi-User startup option. In a MUFplex with two or more MUFs enabled, a CNTTB command provides only the number known to the local MUF, not to the MUFplex as a whole.