Managing messages log (DDMSGQ) - 7.3

Talend Change Data Capture Installation Guide

Version
7.3
Language
English
Product
Talend Change Data Capture
Module
Talend Change Data Capture
Content
Data Governance > Third-party systems > Database components (Integration) > Change Data Capture
Data Quality and Preparation > Third-party systems > Database components (Integration) > Change Data Capture
Design and Development > Third-party systems > Database components (Integration) > Change Data Capture
Last publication date
2023-10-05

The messages are centralized in a message queue on the AS/400 IBMi (DD_USRDATA/DDMSGQ), and in a text file on NT (sub-directory data\DDMSGQ.ddm). The target engines write and send their messages to the source engine which also writes messages.

About this task

Procedure

  1. You can use the Manager to view the messages or read them directly:
    • on AS/400 IBMi, using the DSPMSG DD_USRDATA/DDMSGQ command.
    • on Windows NT Server, by opening the data\DDMSGQ.ddm file in MFC WordPad (do not use Notepad as it does not recognize line skips).
  2. To clean up messages, click Clear message queue in the Manager. It empties the message queue on the source. You can also clear it manually on AS/400 IBMi using the CLRMSGQ command (DD_USRDATA/DDMSGQ) and on NT by deleting the data\DDMSGQ.ddm file. On NT, a parameter specifies the maximum size in kilobytes beyond which the file is cleared automatically (see MaxLogSizeKo parameter).
    Warning: Based on the AS/400 IBMi system setup, when the message queue is full (64MB), it may obstruct source and target startup. You must clean it regularly. We recommend you use scheduler (WRKJOBSCDE) to clean it Monday through Friday before you leave in the evening, so that messages generated during the night are kept. Since the message queue in AS/400 IBMi is not linked to a user profile, it is not included in the cleanup tasks.