Incorporating DB2 Storagegroups

This document covers the following topics:


Prerequisites

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

Selection criteria

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.
Update storagespace attributes (connect option) Provided on a later page of the schema incorporation wizard (after the physical object has been selected from the drop-down list box). Y - Attributes of the Predict storagespace that differ from the DB2 storagegroup are updated.
Information in the drop-down list box
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:

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

Test

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

Connect

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.

Specify the following parameters in an additional page of the schema incorporation wizard.

Connect Options
Update storagespace attributes See the parameter table in Selecting DB2 Storagegroups for a description of this parameter.

Incorporate

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 page of the schema incorporation wizard. 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.

Keywords

The schema incorporation wizard uses the following keywords when showing the command that is to be processed:

Field Keyword
Storagegroup name STOGROUP
Creator name CREATOR
Function SUB-FUNCTION
Storagespace ID STOSPACE-ID
List incorporated code LIST
Update storagespace attributes UPD-ST
SQL Server SQL-SERVER