Troubleshooting Tips: Can we replicate user defined journal entries in ICDC subscription
madavid 270001CJGW Visits (1115)
If you are running DB2 on AS400, you should be able to create the custom journal entry types and use it for CDC replication.
However, note the following steps
CDC for DB2 is running on AS400 with version 6.1
1. Modify system parameter Replicate User Defined Journal Entries to *yes
2. Define the custom entries into the following metadata file 'DMFS522P'.
3. Insert custom entries by using the strsql (SQL statement).
Eg, INSERT INTO DMIRROR/DMFS522P VALUES('File1', 'Lib1', 'SUB1', 'U', 92, 'R', 'PT', ' ', ' ')
The above example is assuming the custom entry U 92 is to be read as an insert for Lib1/File1 in subscription SUB1 and that your metadata lib is DMIRROR. Please modify the values to fit your environment.