Processing, DBUTLTY and SQL Messages › CA Datacom/DB Processing Messages (DB0xxxxc) › DB03131I

DB03131I

CDCM status progstat CDCL--mm:ss CDCU--mm:ss TSN-n MNT-n--DBID-n

Reason:

This message is generated in response to a STATUS_CDC command as the second line in that response.

CDCM

Refers to the Change Data Capture Monitor (CDCM) program, whose task it is to connect to the target MUF. CDCM periodically checks the Change Data Capture Listener (CDCL) program and Change Data Capture User Listener (CDCU) program to see how current they are relative to the LXX.

status

Indicates the status of the CDCM subtask, where status can be one of the following:

OPEN

Indicates that the CDCM subtask is open.

CLOSED

Indicates that the CDCM subtask is closed.

OPN>CLS

Indicates that the CDCM subtask is open, but you have requested it to close.

CLS>OPN

Indicates that the CDCM subtask is closed, but you have requested it to open.

OPN-ING

Indicates that the CDCM subtask is in the process of opening.

CLS-ING

Indicates that the CDCM subtask is in the process of closing.

progstat

Indicates the current specific status of the program, where progstat can be one of the following:

WAITPOLL

Indicates that the program is waiting for the poll interval.

WAITENBL

Indicates that the program is waiting for an enable.

CLOSED

Indicates that the program is closed.

WAIT-RQ-

WAIT-RQ- indicates that the program is waiting for a request.

RUNNING

RUNNING indicates that the program is running.

CDCL

Refers to the Change Data Capture Listener (CDCL) program, whose task it is to watch the LXX for new work and push CDC records to the CDC system databases.

mm:ss

Following the CDCL is the time it is behind in processing CXX records, given in minutes mm and seconds ss. If the time is greater than 999 minutes, the display shows plus signs (+). If the CDCM subtask has not yet successfully opened the CDCL, the time is technically unknown (UNKN).

CDCU

Refers to the Change Data Capture User Listener (CDCU) program, whose task it is to process and delete the maintenance records for each committed request that it finds, then move the changes from the source MUF to the target MUF.

mm:ss

Following the CDCU is the time it is behind from the time of the first TSN record, given in minutes mm and seconds ss. If the time is greater than 999 minutes, the display shows plus signs (+). If the CDCM subtask has not yet successfully opened the CDCU, the time is technically unknown (UNKN).

TSN

Indicates a count n of TSN (transaction sequence number) records. This count is the result of CNTKR or CNTTB commands and reflects the number of TSN records that currently exist.

MNT

Indicates a count n of CDC maintenance LXX records. This count is the result of CNTKR commands and reflects the number of MNT records that currently exist.

DBID

Indicates the output for slot 1.

If a return code closed the CDCM, the end of the message provides the command, table, and return code that occurred. The STATUS_CDC DB03131I message times and record counts are from the prior CDCM polling interval, not from the time at which the STATUS_CDC was issued. If the polling interval is 60 seconds, for example, the information in DB03131I can be from 60 seconds ago. If the CDCM subtask is closed currently, the information in DB03131I is from the last polling interval it was open.

Action:

None. This message is for information only.