In general, this command reads as
follows:
open <AS400_server_host>
user <Username> <Password>
quote rcmd "crtsavf qgpl/instfitcdc"
quote rcmd "clrsavf qgpl/instfitcdc"
bin
cd qgpl
put "<Studio_install>\plugins\org.talend.designer.cdc_<version>\resource\fitcdc.savf" instfitcdc
quote rcmd "rstlib savlib(fitcdc) dev(*savf) savf(qgpl/instfitcdc) RSTLIB(<CDC_library_name>)"
quote rcmd "CHGCMD CMD(<CDC_library_name>/RUNCDC) PGM(<CDC_library_name>/F2CD00) CURLIB(<CDC_library_name>)"
quote rcmd "dltf qgpl/instfitcdc"
quit
It is automatically executed via FTP by the Studio to install
the RUNCDC program, restore the CDC library (the CDC
database), and create the TSUBSCRIBERS table which provides
information on all tables where CDC has been set up.
The CDC library by
default contains the following tables:
- FITAB: contains the information about the last
executions and receivers used in its TBDT1 field.
- position 1-10: the library of the last receiver of previous run
- position 11-20: the name of the last receiver of previous run
- position 21-40: the last date/time process
- position 41-50: the library of the last receiver of current run
- position 51-60: the name of the last receiver of current run
- FICLH: contains the RUNCDC
command execution logs and the receivers used.
- FICLF: contains technical logs about the files
used.
Both FITAB and FICLH tables
provide information on the receivers already used by the
RUNCDC program, and can help clean up receivers if
needed.
If you extract change data frequently later, there might be an
overflow on the NUM_ORD field in the
FITAB table when its value reaches
9999999. If it happens or before it happens, you can
reset its value by executing the command Change F2CD65 NUM_ORD in FITAB to
0 (zero) and then remove all records in the
FICLH, FICLF,
FITMP, and FIRCV tables.
If
there is any issue related to the FITAB table after a
reboot of your AS/400 system, you might need to reset the value of the
NUM_ORD field.