Comparing DB2 Storagegroups

This document covers the following topics:

Prerequisites

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

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

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==.