Comparing DB2 Tablespaces

#### Search Results

Search

# Comparing DB2 Tablespaces

This document covers the following topics:

- Prerequisites for DB2 Tablespaces

- Calling the Function: Compare DD Objects with Tablespaces

- Parameters for DB2 Tablespaces

- Comparing DB2 Tablespaces in Batch Mode

## Prerequisites for DB2 Tablespaces

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 Tablespaces

The Compare DD Objects with Tablespaces screen is called with code C and object code TS in any Predict main menu or with the command `COMPARE TABLESPACE`.

    18:06:13             *****  P R E D I C T  *****              2007-05-31
    Plan   0          - Compare DD Objects with Tablespaces -        Profile SYSTEM

    Dataspace ID ..........
    Located in DA .........

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

    Check options                           List options
      Dataspace attributes ... Y (Y/N)        Dataspace attributes .....* D
      Files .................. Y (Y/N)        Files ....................* D

    Update options
      Dataspace attributes ... 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 Tablespaces

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

Parameters
Dataspace ID | ID of the Predict dataspace object that is to be compared. Asterisk notation can be used.
Contained in DA | Predict database object the dataspace object is linked to (via association "Contains DC"). Asterisk notation can be used.
Check options
If check options are not set, compare functions will not reset the Modified after generation flag. See Resetting the Modified after generation Flag for more information.
Dataspace attributes |
Y | Attributes of the Predict dataspace are compared with the DB2 tablespace.
Files |
Y | The file list of the dataspace is to be compared with the DB2 tablespace.
List options
Dataspace attributes |
How dataspace attributes are reported.
Y | All attributes of the Predict dataspace are reported.
N | No attributes are reported.
D | Different: only attributes of dataspace that are different from the tablespace are reported.
Files |
How files linked to the dataspace via association "Contains FI" are to be reported:
Y | All files
N | No files
D | Different: only files that are either not implemented in the DB2 tablespace or not defined in Predict.
Update options
Dataspace attributes |
Y | Attributes of the Predict dataspace that differ from the DB2 tablespace are changed.
Unlink files |
Y | Files that are not implemented in the DB2 tablespace are removed from the file list of the Predict dataspace object and from the file list of the database object to which the dataspace belongs.

## Comparing DB2 Tablespaces in Batch Mode

Command: `COMPARE TABLESPACE`

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

Field | Keyword | Position
--- | --- | ---
Dataspace ID | DATASPACE-ID | 1
Contained in DA | DB | 2
Check options
Dataspace attributes | CHECK-DS | 3
Files | CHECK-FILE | 4
List options
Dataspace attributes | LIST-DS | 5
Files | LIST-FILE | 6
Update options
Dataspace attributes | UPD-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 dataspaces with prefix "TEST" and display all files, code the command:

    COMPARE TABLESPACE
    DATASPACE-ID=TEST*,LIST-FILE=Y

or

    COMPARE TABLESPACE
    TEST*,,Y

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

### On this page

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