Incorporating DB2 Storagegroups

#### Search Results

Search

# Incorporating DB2 Storagegroups

This document covers the following topics:

- Prerequisites for DB2 Storagegroups

- Selecting DB2 Storagegroups

- Incorporation Functions for DB2 Storagegroups

- Incorporate DB2 Storagegroups in Batch Mode

## Prerequisites for DB2 Storagegroups

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

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

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

Parameters
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:

- Compare - Code T

- Connect - Code C

- Incorporate - Code I

Note
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

Command: `INCORPORATE STORAGEGROUP`

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
Function | SUB-FUNCTION | 4
Storagespace ID | STOSPACE-ID | 5
List incorporated code | LIST | 6
Update storagespace attributes | UPD-ST | 7
SQL Server | SQL-SERVER | 8

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 incorporate the DB2 storagegroup "SYSDEFLT" with storagespace ID "TEST-ST" and display the storage space attributes, code the command:

    INCORPORATE STORAGEGROUP
    STOGROUP=SYSDEFLT,SUB-FUNCTION=I,STOSPACE-ID=TEST-ST,LIST=Y

or

    INCORPORATE STORAGEGROUP
    SYSDEFLT,,,I,TEST-ST,Y

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

### On this page

- Prerequisites for DB2 Storagegroups
- Selecting DB2 Storagegroups
- Incorporation Functions for DB2 Storagegroups
- Incorporate DB2 Storagegroups in Batch Mode