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. |
|
Copyright © 2014 CA.
All rights reserved.
|
|