2. Specifying target objects

After you specify the comparison source, the next step is to specify the target. The target is the object or objects that you want to compare to the source.

Procedure

To specify the target object definitions:
  1. On the DB2 Object Comparison Tool Menu (GOCMENU) panel, specify option 2, and press Enter.
  2. On the Specify Compare Target (GOC1) panel, specify where you want Object Comparison Tool to retrieve the definitions for the target objects, and press Enter: 
     
 GOC1 re -------------------- Specify Compare Target --------------------- 17:15 
 Option ===>                                                                     
                                                                                 
                                                                                 
   1  - Target is from a DDL file                                                
   2  - Target is from the DB2 catalog                                           
   3  - Target is from a compare version file                                    
   4  - Target is from the DB2 catalog and the objects are automatically         
        selected based on the selected source objects                            
   VS - Target is from the DB2 catalog and the objects are selected from         
        a version scope                                                          
                                                                                 
 Exclude Specification:                                                          
   Owner . . . . . . . .           >  (Optional, default is ELACZ, ? to lookup)  
   Name  . . . . . . . .                               >  (Required, ? to lookup)
   Edit objects  . . . . YES   (Yes/No)

    You can specify one of the following options:

    OptionDescription
    1 Specifies that the definitions of the target objects are to be retrieved from a DDL file, that is, a file that contains SQL CREATE statements.
    2 Specifies that the definitions of the target objects are to be extracted from the Db2® catalog. The definitions are extracted for one or more databases, table spaces, or tables and all dependent objects.

    With option 2, you can optionally specify your own SQL SELECT statement against the catalog to identify the objects.
    3 Specifies that the definitions of the target objects are to be retrieved from a previously created version file.
    4 Specifies that the target objects are selected based on the source objects.
    VS Specifies that the definitions of the targets objects are to be extracted from the Db2 catalog, and the objects are selected based on a version scope. Change Management must be enabled to select this option.
  3. Optional: If you want to exclude specific objects, specify an exclude specification in the Exclude Specifications fields.
    You can specify an existing exclude specification or create one. If you specify an existing one, you can edit it.

    For detailed instructions on how to create an exclude specification or edit an existing one, see Creating or editing exclude specifications during a comparison.

  4. Press Enter, and complete one of the following procedures depending on that the option that you chose in step 2:
    OptionDescription
    1 Specifying a DDL file for the source or target definition
    2 If you want to identify individual objects: Specifying the Db2 catalog for the source or target definition

    If you want to specify a SELECT statement against the catalog: Specifying a SELECT statement for the source or target definition
    3 Specifying a version file for the source or target definition
    4 Specifying that the target definition is automatically selected based on the source
    VS Specifying a version scope for the source or target definition