Specifying alternate input to the generate apply job program

You can specify data sets for Db2® Object Comparison Tool to use as alternate inputs to the program that generates the apply job. In addition, you can create a template that specifies the batch parameter variables you want your data set to contain.

About this task

The following two members in the primary input data set store primary input variables: GOCSVARS and GOCSVAR2. You can instruct the generate apply job program to use the alternate data sets by adding a DD statement to the JCL. The alternate data sets can contain variables with customized values.

Procedure

Create a primary input data set.
1. Select option 5 on the Db2 Object Comparison Tool menu to generate the data set that is referenced by the GOCSVARS DD statement.
Create data sets based on the primary input data set.
1. Enter an I in the option field on the Db2 Object Comparison Tool menu. The I option is hidden and is not listed as an option on the menu.
  The List ISPF Table Extension Variables panel is displayed, as shown in the following figure:
  Figure 1. List ISPF Table Extension Variables panel (ADB2IIT)
```
 DB2 Admin --------- List ISPF Table Extension Variables  -------- 09:02

      Enter/verify the following:                                             
       Data Set Name  ===>                                                    
       Member Name    ===>                                            
```
2. Enter the primary data set name and the member name (GOCSVARS for Db2 Object Comparison Tool) that you want to list.
3. Press Enter.
  The list of variables and values for the specified data set and member is displayed.
4. Copy the content of the member to the newly created alternate data set.
  
  Requirement: The alternate input data set must exist before this step.
5. Edit the variables listed in the newly copied alternate data set with the alternate values that you want to use as input to the generate apply job program.
  
  Requirement: The alternate input data set must have a fixed record length of 80 characters with no sequence numbers. Each logical record begins in column one. Logical records continue on subsequent lines if they exceed the line length. Each logical record must end with a semicolon (;). All variables that are listed must exist in the alternate input data set.
6. Save the modified variable list. While in the edit session, use the REPLACE command to save your changes.
7. Repeat the previous steps, this time entering GOCSVAR2 for member name.

Add a DD statement, ALTSHV, that refers to the two input members in the alternate input data set. You must specify the member name explicitly.

Here is an example of the amended JCL:

//GOCSVARS DD DISP=SHR,DSN=HLQ.PRIMARY.SHV
//ALTSHV  DD DISP=SHR,DSN=HLQ.ALTENATE.ALTPDS(GOCSVARS)
//        DD DISP=SHR,DSN=HLQ.ALTENATE.ALTPDS(GOCSVAR2)
//CHANGES DD DISP=SHR,
//                    DSN=HLQ.THISCHG.CHG

Delete or rename members GOCSVARS and GOCSVAR2 from the primary input data set that is referenced by the GOCSVARS DD statement.