Example 1: Using the online interface to generate High-speed Apply Engine JCL

• Shows the use of High-speed Apply Engine to translate the table names during execution (instead of the SQLXLAT DD statement used with EXECSQL)

• Shows the use of a High-speed Apply Engine parameter to enable multi-threaded execution

  High-speed Apply Engine can use multiple agents (separate Db2 threads) to access and update Db2 objects during SQL execution. High-speed Apply Engine uses only the number of agents that it needs. You can influence the number of agents by using configuration parameters. For more information, see the section about configuration parameters in the High-speed Apply Engine documentation.

To generate High-speed Apply JCL

1. On the Main Menu panel, select Generate High-speed Apply JCL and press Enter.

2. On the High-speed Apply JCL Generation panel, complete the following steps:

   1. In the Input Type field, type SQL.We recommend that you explicitly specify input type SQL.
   2. In the SSID field, type DGA1.
   3. In the FileName field, type DB2DBA.DEV.OUTSQ1.
   4. In the Edit Object Mapping Rules field, type E.
   5. Press Enter.

                     High-speed Apply JCL Generation
   Command ===>                                                       
                                                                     
       StartUp Parameters                DistributionTuning Parameters
            InputType: SQL                PartitionClustering: N  (Y=Yes, N=No)
                 SSID: DGA1                      RIClustering: Y  (Y=Yes, N=No)
             FileName: DB2DBA.DEV.OUTSQ1                              
                                                                     
       Conflict Parameters               BindTuning Parameters        
            RetryFail: _________               StatementCount: _____  
           RetryLimit: _____                      MaxPackages: _____  
           RetryValue: _____                       Syncronous: N (Y=Yes, N=No)
                                                                     
       Bind Parameters                   LogicalLog Parameters        
               AuthId: ________                       SqlType: _______
            BindOwner: ________                                       
         CollectionId: ________                                       
                                                                 
       ConflictFile Parameters                                        
             FileName: ___________________________________________    
           SingleFile: Y (Y=Yes, N=No)
                                                                     
       CommitTriggers Parameters         Agent Parameters             
       StatementCount: _____                        MaxAgents: _____  
                                                                     
       Edit Conflict Rules: _   (E=Edit)  Edit Object Mapping Rules: E (E=Edit)
   --------------------------------------------------------------------------------
   Press PF3 to save the workid or to generate JCL. Press PF12 to cancel.

3. On the High-speed Apply Engine Object Mapping Specification panel, perform the following steps:

   Important

   This step specifies the High-speed Apply Engine configuration parameters (object mapping parameters) to translate table names for migration.

   This example translates only table names, but you can also translate column names within a table. If you translate column names, insert column rows below the row of the table that contains the columns.

   1. In the SOURCE NAME field, type DB2DBADB.DB2DBAT1.
   2. In the TARGET NAME field, type DB2DBADB.MIGSQLT1.
   3. Press Enter.
   4. To insert a new row, type T in the ACT field and press Enter.

   5. Using the values shown in the following figure, in the new row, type the original and translated names of the second table in their respective fields, and then press Enter.

                        High-speed Apply Object Mapping Specification     Line 1 of 3
      Command ===>                                                  Scroll ===> HALF
                                                                                   
      Specify values for the High-speed Apply ObjectMap Parameters.                       
      Edit displayed objects or type an action code (ACT) and press Enter.          
                                                                                   
      ACT - T=Insert Table, C=Insert Column, D=Delete, R=Repeat                     
      ACT  TYPE  SOURCE NAME                  TARGET NAME                        
      _    TABLE  DB2DBA.DB2DBAT1               DB2DBA.MIGSQLT1                    
      _    TABLE  DB2DBA.DB2DBAT3               DB2DBA.MIGSQLT3                    
      _    TABLE  DB2DBA.DB2DBAT5               DB2DBA.MIGSQLT5                    
      ***************************** End Of List ******************************
   6. Repeat these substeps for the third table.
   7. Press F3 until you return to the Work ID File Menu.

4. On the Work ID File Menu panel, perform the following steps:

   1. Select Save As.
   2. Select Generate JCL.

   For an example, see Creating-a-batch-job-from-a-work-ID.