Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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

This example shows the actions that you take in the Log Master online interface to generate High-speed Apply JCL that will execute the SQL statements contained in a specific file.

This example:

  • Includes three tables

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

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

    High-speed Apply can use multiple agents (separate Db2 threads) to access and update Db2 objects during SQL execution. High-speed Apply 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.

      BMC recommends 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 Object Mapping Specification panel, perform the following steps:

    Note

    This step specifies the High-speed Apply 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.

Was this page helpful? Yes No Submitting... Thank you

Comments