Comparing DB2 Storagegroups

#### Search Results

Search

# Comparing DB2 Storagegroups

This document covers the following topics:

- Prerequisites for DB2 Storagegroups

- Calling the Function: Compare DD Objects with Stogroups

- Parameters for DB2 Storagegroups

- Comparing DB2 Storagegroups in Batch Mode

## Prerequisites for DB2 Storagegroups

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 Stogroups

The Compare DD Objects with Stogroups screen is called with code C and object code SG in any Predict main menu or with the command `COMPARE STORAGEGROUP`.

    18:02:51             *****  P R E D I C T  *****              2007-05-31
    Plan   0            - Compare DD Objects with Stogroups -        Profile SYSTEM

    Storagespace ID .....
    SQL Server .........*                                  <Default Server>

    Update option                           List option
      Storagespace attributes .. N (Y/N)      Storagespace attributes ....* D

    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 Storagegroups

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

Parameters
Selection criteria
Storagespace ID | ID of the Predict storagespace object to be compared with a DB2 storagegroup. Asterisk notation can be used

List option
Storagespace attributes |
How attributes of the Predict storagespace object are to be displayed.
Y | All attributes are listed.
N | No attributes are listed.
D | Different: only attributes of storagespace that are different from the storagegroup are listed.

Update option
Storagespace attributes |
Y | Attributes of the Predict storagespace that differ from the DB2 storagegroup are updated.

## Comparing DB2 Storagegroups in Batch Mode

Command: `COMPARE STORAGEGROUP`

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

Field | Keyword | Position
--- | --- | ---
Storagespace ID | STOSPACE-ID | 1
List option
Storagespace attributes | LIST-ST | 2
Update options
Storagespace attributes | UPD-ST | 3
SQL Server | SQL-SERVER | 4

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 storagespaces with prefix "TEST" and list all attributes, code the command:

    COMPARE STORAGEGROUP
    STOSPACE-ID=TEST*,LIST-ST=Y

or

    COMPARE STORAGEGROUP
    TEST*,Y

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

### On this page

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