HOW TO: Troubleshoot DB2 CDC on the Mainframe

[Adeeb Mass'ad]

DESCRIPTION

To activate the Journaling for a specific table in DB2, you have to execute the following SQL statement in the native interface (or a passthrough query to Attunity Connect):-

alter table owner.tablename data capture changes

When facing a problem whilst working with the DB2 CDC on the Mainframe, always check the followings:-

• APF authorize to NAVROOT.LOADAUT.
• APF authorize to all steplibs in the ATTSRVR, including NAVROOT.LOAD.
• Set generalTrace, acxTrace and driverTrace for the debugging level (env/debug).
• If the staging area and the Agent are on different machines, we will get two log files, one in each machine with same log file name.
• Capturing the changes will start after creating the Staging Area or the Agent.

Attached a sample JOB which can print the archived log (not the active one).