Comparing DB2 Databases

#### Search Results

Search

# Comparing DB2 Databases

This document covers the following topics:

- Prerequisites for DB2 Databases

- Calling the Function: Compare DD Objects with DB2 DBs

- Parameters for DB2 Databases

- Comparing DB2 Databases in Batch Mode

## Prerequisites for DB2 Databases

DB2 must be installed. See the section DB2 and SQL/DS in the Predict and Other Systems documentation.

See also General Prerequisites for Comparison Functions.

## Calling the Function: Compare DD Objects with DB2 DBs

The Compare DD Objects with DB2 DBs screen is called with code C and object code D2 in any Predict main menu or with the command `COMPARE D2`.

    17:00:13             *****  P R E D I C T  *****              2007-05-31
    Plan   0            - Compare DD Objects with DB2 DBs -          Profile SYSTEM

    Database ID ...........
    Belongs to VM .........

    SQL Server ...........*                                  <Default Server>

    List options                          Update options
      DB attributes ......* D               DB attributes ......... N (Y/N)
      Dataspace list .....* D               Links
      File list ..........* D                 Unlink dataspaces ... N (Y/N)
                                              Unlink files ........ N (Y/N)

    Restrictions ........*    Profile Default ,used

    Command ===>
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Next  Stop  Last  LnkEl Flip  Print Impl  AdmFi SelFi Prof  Main

## Parameters for DB2 Databases

Common parameters which are not included in the table below are described under Common Parameters for All DB2 Types.

Parameters
Selection criteria
Database ID | The ID of the Predict database object or objects of type D which are to be compared with the connected DB2 database or databases. Asterisk notation can be used.
Belongs to VM | Limits the scope of the function to DB2 databases linked to this virtual machine via association "Contains DA". Asterisk notation can be used.
List options
DB attributes |
How attributes of the Predict database object are to be displayed.
Y | All database attributes
N | No database attributes
D | Different: only database attributes whose Predict values differ from the implementation.
Dataspace list |
How Predict dataspace objects linked to the Predict database object via association "Contains DC" are to be displayed.
Y | All dataspaces.
N | No dataspaces.
D | Different: only dataspaces that are not implemented as DB2 tablespaces and DB2 tablespaces that are not documented with Predict dataspaces are contained in the list.
File list |
How files linked to the Predict database object are to be displayed.
Y | All files.
N | No files.
D | Different: only files that are either not implemented in the DB2 database or not defined in Predict.
Update options
DB attributes |
Y | The attributes of the Predict database object are to be updated.
Unlink dataspaces |
Y | Dataspaces not implemented as DB2 tablespaces are to be removed from the dataspace list of the Predict database object.
Unlink files |
Y | Files that are not implemented in the DB2 database are to be removed form the file list of the Predict database object. Note Unlink files can only be set to Y if Unlink dataspaces is also set to Y.

## Comparing DB2 Databases in Batch Mode

Command: `COMPARE DB2`

Enter parameters on the next line in positional or keyword form.

Field | Keyword | Position
--- | --- | ---
Database ID | DATABASE-ID | 1
Belongs to VM | PARENT | 2
List options
DB attributes | LIST-DB | 3
Dataspace list | LIST-DS | 4
File list | LIST-FILE | 5
Update options
DB attributes | UPD-DB | 6
Unlink dataspaces | UNLINK-DS | 7
Unlink files | UNLINK-FILE | 8
SQL Server | SQL-SERVER | 9

If you explicitly set SQL-SERVER to blank in order to use the default server, another keyword must be specified after the SQL-SERVER keyword. If it is not possible to specify another keyword, the SQL-SERVER keyword must be followed by "D1=*" as shown below:

    SQL-SERVER= ,D1=*

### Example

To compare all databases of type D with prefix "TEST" and to display the file lists code the command:

    COMPARE DB2
    DATABASE-ID=TEST*,LIST-FILE=Y

or

    COMPARE DB2
    TEST*,,,,Y

The above example uses the Natural parameter `ID=,` and `IA==`.

### On this page

- Prerequisites for DB2 Databases
- Calling the Function: Compare DD Objects with DB2 DBs
- Parameters for DB2 Databases
- Comparing DB2 Databases in Batch Mode