Cleaning the journal - 7.3

Talend Change Data Capture User 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-12-22

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.
Note: Make sure that the journal receivers are not needed by another application on your AS/400 IBMi before you automate the cleaning with the DDJRN command. To do so, contact your operation or database administrator. 
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.