1. Specifying source objects

The first step in comparing Db2® objects is to specify the definition for the source object or objects. A source object is an object as you want it defined. The target object is compared to this source object and optionally changed to match it.

About this task

The definitions for source objects can be in a DDL file, the Db2 catalog, or a version file. When you specify one of these definition sources, Db2 Object Comparison Tool uses the object definition (and attributes) from that source for the comparison.

Procedure

To specify source object definitions:
  1. On the DB2 Object Comparison Tool Menu (GOCMENU) panel, specify option 1, and press Enter.
  2. On the Specify Compare Source (GOC1) panel, specify where you want Object Comparison Tool to retrieve the definitions for the source objects.
    Figure 1. Specify Compare Source (GOC1) panel
     
 GOC1 re -------------------- Specify Compare Source --------------------- 17:01
Option ===> VS                                                                  
                                                                                
                                                                                
   1   - Source is from a DDL file                                              
   2   - Source is from the DB2 catalog                                         
   3   - Source is from a compare version file                                  
                                                                                
                                                                                
   VS  - Source 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 source 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 source 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 source objects are to be retrieved from a previously created version file.
    VS Specifies that the definitions of the source 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
    VS Specifying a version scope for the source or target definition