Define or create Apply Engine and job script - connect_cdc_sqdata - aws_mainframe_modernization_service - Latest

AWS Mainframe Modernization Data Replication for IBM z/OS
Product type
Software
Portfolio
Integrate
Product family
Connect
Product
AWS Mainframe Modernization > AWS Mainframe Modernization Service
Version
Latest
ft:locale
en-US
Product name
AWS Mainframe Modernization
ft:title
AWS Mainframe Modernization Data Replication for IBM z/OS
Copyright
2025
First publish date
2000
ft:lastEdition
2025-02-10
ft:lastPublication
2025-02-10T15:55:15.122000
Follow these steps to define and manage a new replication pipeline.
Note: The replication pipeline uses the DB2 z/OS to Oracle sample scenario with <ENGINE_NAME>=DB2ZTOORACLE but you must replace that with your own unique name.
  1. Select a unique apply <engine_name> that should also be used as the jobname in the job script file and the subdirectory path in the instance as shown in the following steps for DB2ZTOORACLE.
  2. Create the apply engine directories in $SQDATA_VAR_DIR/apply/<ENGINE_NAME>. For example,
    connect> mkdir -p $SQDATA_VAR_DIR/apply/DB2ZTOORACLE/ddl
connect> mkdir -p $SQDATA_VAR_DIR/apply/DB2ZTOORACLE/scripts
  3. Upload, create or edit the job script <engine_name>.sqd. For example,
    connect> vi $SQDATA_VAR_DIR/apply/DB2ZTOORACLE/scripts/db2ztooracle.sqd
    Note:
    • Sample job scripts are provided in $SQDATA_VAR_DIR/templates/*.sqd.
    • Sample schemas are provided in $SQDATA_VAR_DIR/templates/*.ddl
  4. Add <ENGINE_NAME> stanza to sqdagents.cfg. For example,
    > vi $SQDATA_DAEMON_DIR/cfg/sqdagents.cfg


    Note: See sample stanzas in $SQDATA_VAR_DIR/templates/sqdagents.cfg.
  5. Once the above is added to sqdagents.cfg section, reload sqdmon for changes to take effect.
    > sqdmon reload

    The above should be done whenever a new replication task (apply engine script) is being added or modified.

  6. Consider setting auto_start=1 to have the engine automatically started in case of a system restart.