Please enable JavaScript to view this site.

Navigation: Quickstart Guides > Db2/z Quickstart

Apply Engine Configuration

 Scroll

The Apply Engine script generated in this step is a no-map replication script for an Apply Engine running on z/OS where the source and target tables are identical.

If you have a use case that involves replication of identical source/target tables, you will need to create the target tables before running the Apply Engine. If primary indexes are created on the target tables (recommended), you can use the auto-detect feature of Connect CDC SQData to identify and use the primary keys.  Otherwise, you will need to specify the target keys in the replication script as explained in this section.

Note, even though your use case may not be simple replication, you can use the generated script as a starting point for a script that you can then modify as needed to satisfy your requirements.

This section guides you through the following tasks:

1.Create a new no-map replication Apply Engine script

2.Generating JCL to run the Apply Engine in standalone batch mode

3.Prepare the Apply Engine to run as a Started Task

Select option 3 from the Connect CDC SQData menu and press ENTER to get started with this section.

 -------------------------- Capture/Publisher Summary -------------- Row 1 of 1 

 Option ===>                                                                    

                                                                                

   I Insert New                                                                 

   ----------------------------                                                 

   s Select  i Insert  d Delete                                                 

                                                                                

                                     Session                            Lag     

    CAB File             Status    # Published      Last Commit     hh:mm:ss.th 

 v -------------------  --------- ------------- ------------------- ----------- 

 S DB2CDCT.cab          Stalled               0 2017-11-17 16:03:34  0:09:17.20 

 ******************************* Bottom of data ********************************

Select the Capture for which you wish to generate a replication script.

 ------------------------ Db2 Capture/Publisher Detail ------------ Row 1 of 1 

 Option ===> G                                                                 

                                                                               

 C Cycle  S Start  T Stop  A StopAll  P Pause  R Resume  L SetLRSN  G Gen      

 ------------------------------------------------------------------------      

 s Select  x Disconnect                                                        

                                                                               

  CAB File          : /home/sqdata/test/DB2CDCT.cab                           

  Status            : MOUNTED,STARTED,STALLED                                  

  Db2 Subsystem     : DBBG  

 ... 

                                                   

Type G on the Publisher Detail panel for the Capture agent that was just created and press ENTER to display the Generation menu.