Cleaning the journal
DDJRN command – Journal receiver management
Talend Change Data Capture uses the database journalization to distribute data to remote sites. The journalization uses receiver-type objects (*JRNRCV) that can soon become bulky and must be deleted regularly. The deletion must also take the distribution into account, so that no receiver is deleted until it has been fully processed by Talend Change Data Capture, for all the sites, and all the files, bearing in mind that they are not all enabled according to the same rules. Talend Change Data Capture integrates a receiver management command to assist the operator in his or her management tasks.Delete unused receivers (DDJRN)
Specify your choices, and press ENTER.
Environment. . . . . . . . . . *_ ID, generic*, *
Environment type. . . . . . . PROD PROD, TEST, TRNG, *ALL
Option to process . . . . . . *MSG___ *MSG, *DLTSAV, *DLTALL
Journal . . . . . . . . . . . __________ Name
Library. . . . . . . . . . . __________ Name
End
F3=Exit F4=Prompt F5=Redisplay F12=Cancel F13=Instructions
F24=Other keys
This command calls for the parameters below:
- Deletion option
*DLTSAV Delete unused receivers that have been saved
*DLTALL Delete all unused receivers
*MSG Check and transmit message regarding the receiver status
- Journal
Specify the name of the journal to process and its library.
You can integrate this command in the site's daily operating procedures after the daily backup. This way, the *DLTSAV option can be used to delete all the receivers that Talend Change Data Capture no longer requires and which have been saved.
When using the *DLTALL option to delete, do not forget to include an automatic reply for the message prompting you to confirm the deletion of an unsaved receiver.
- Deleting receivers using the DDJRN command
If a journal receiver is eligible for deletion, the DDJRN command calls the XDLTJRNRCV program whose source is delivered in the DD_V4/QSAMPLE source file.
You can modify the processing by DDJRN by modifying the XDLTJRNRCV program in order to work together with another tool that manages receivers. To do so, copy the XDLTJRNRCV source to another library (DD_USRDATA for example) before modifying it. The new XDLTJRNRCV program must be placed in the DD_USRDATA library. This is because the DDJRN command looks for the XDLTJRNRCV program in the DD_USRDATA library to run it. If it does not find it, it runs the version located in the DD_V4 library.