Incorporating DB2 Storagegroups

This document covers the following topics:


Incorporation of DB2 objects is subject to DB2 security mechanisms. See the section DB2 and SQL/DS in the Predict and Other Systems documentation.

See Concepts of Incorporation for basic information on how to use incorporation functions.

Selecting DB2 Storagegroups

The Incorporate DB2 Storagegroup screen is called with function code I and object code SG in a Predict main menu or with the command INCORPORATE STORAGEGROUP.

17:28:31             *****  P R E D I C T  *****              2007-05-31
Plan   0             - Incorporate DB2 Storagegroups -                         
Storagegroup name .........                                                    
SQL Server ...............*                                  <Default Server>  
Select option                                                                  
  Creator name ............                                                    
Processing option                                                              
  Connect automatic ....... N (Y,N)                                            
Update when connecting                                                         
  Storagespace attributes . Y (Y/N)                                            
Command ===>                                                                   
      Help  Next  Stop  Last  LnkEl Flip  Print Impl  AdmFi SelFi Prof  Main   

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

Storagegroup name DB2 storagegroup name. Asterisk notation is allowed.
Creator name DB2 creator name. Asterisk notation is allowed.
Connect automatic Y - With the Compare function: the DB2 storagegroup and the Predict object are connected if no differences are detected between the two objects.
Storagespace attributes Y - Attributes of the Predict storagespace that differ from the DB2 storagegroup are updated.
14:49:42             *****  P R E D I C T  *****              2007-05-31
                     - Incorporate DB2 Storagegroups -                         
Search-crit.: Storagegroup name=ALL                                            
    Storage-             Predict                                               
Cmd group name           storagespace ID                    Remark             
__  ABAG2000                                                                   
__  DSN8G71U             DSN8G71U                                              
__  DSN8G710             DSN8G710                                              
__  SYSDEFLT             SYSDEFLT                                              
__  NATQA                                                                      
__  NATURAL                                                                    
__  HEBDROP              HEB-SC-DROP                                           
__  HEBSCX                                                                     
__  SGDBZWEI                                                                   
__  LNDBSG01                          
__ ( '.'=Exist,'T'=Top )                                                       
Columns in the List
Storagegroup name Name of the storagegroup.
Predict storagespace ID ID of a Predict storagespace documenting the storagegroup.
Remark A type-independent remark (see Remarks which apply to all Object Types or blank.

Incorporation Functions for DB2 Storagegroups

Valid functions:

Corresponding DB2 storagegroups and Predict objects of type storagespace are identified by the DB2 storagegroup name.

Compare - Code T

Compares the storagegroup and the Predict storagespace and reports differences between attributes.

If no differences between the two objects are found and Connect automatic is set to Y, the dictionary object is connected to the storagegroup.

Connect - Code C

Connects the storagegroup to the existing Predict storagespace, and

  • updates the Predict storagespace;

  • writes to the generation log of the Predict object that a corresponding implemented storagegroup existed when the connection was established.

Incorporate - Code I

Scope of the Incorporation

  • Creates a Predict storagespace with attributes documenting the storagegroup.

  • Connects the storagegroup and the Predict storagespace.

Specify the following parameters in an additional input screen before executing the function. Storagespace ID is mandatory, List incorporated code is optional

Incorporation Options
Storagespace ID ID to be assigned to the new Predict storagespace.
List incorporated code
Y The values of all attributes incorporated for the table or view are to be listed.

Incorporate DB2 Storagegroups in Batch Mode


Enter parameters on next line using positional or keyword form.

Field Keyword Position
Storagegroup name STOGROUP 1
Creator name CREATOR 2
Connect automatic AUTO-CONNECT 3
Storagespace ID STOSPACE-ID 5
List incorporated code LIST 6
Update storagespace attributes UPD-ST 7

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:



To incorporate the DB2 storagegroup "SYSDEFLT" with storagespace ID "TEST-ST" and display the storage space attributes, code the command:




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