Incorporating DB2 Tablespaces and SQL/DS DBspaces

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 Tablespaces

Selection criteria

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

Parameters
Tablespace name Name of DB2 tablespace. Asterisk notation is allowed.
Creator name Name of tablespace creator. Asterisk notation is allowed.
DB2 database name Name of DB2 database. Protected when processing SQL/DS DBspaces. Asterisk notation is allowed.
Update dataspace 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 dataspace that differ from the DB2 tablespace are changed.
Information in the drop-down list box
DB2 database Name of the database containing the tablespace.
Tablespace name Name of the tablespace.
Predict dataspace ID ID of the Predict dataspace object documenting the DB2 tablespace.
Remark Any of the following type-specific remarks or blank. For type-independent remarks see Remarks which apply to all Object Types.
SC missing Default storagegroup is not documented. Incorporation is not possible.
DA missing The DB2 database or storagegroup is not documented in Predict. Incorporation is not possible.
ST missing

Incorporation Functions for Tablespaces

Valid functions:

Test

Compares DB2 tablespaces and corresponding Predict dataspace objects. Differences between file lists and tablespace/dataspaces attributes are reported.

Connect

Connects DB2 tablespaces to Predict dataspace object and

  • copies current information from the DB2/SQL/DS catalog to the dictionary object

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

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

Connect Options
Update dataspace attributes See the parameter table in Selecting Tablespaces for a description of this parameter.

Display Masters

The DB2 databases and storagegroups a tablespace is related to must be documented in Predict before the tablespace can be incorporated. The incorporation function M can be used to identify all objects that are missing. These can then be incorporated before the tablespace is incorporated.

Incorporate

Scope of the Incorporation

  • A Predict dataspace object is created for each tablespace and connected to the tablespace.

  • The dataspace object is linked to the corresponding database in Predict via association "Contains DC".

Specify the following parameters in an additional page of the schema incorporation wizard. Dataspace ID is mandatory, List incorporated code is optional.

Incorporation Options
Dataspace ID ID of the Predict dataspace object. The DB2 tablespace name is displayed and can be accepted or overwritten.
List incorporated code
Y Display what has been incorporated as attributes of the dataspace object.

Keywords

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

Field Keyword
Tablespace name TBSPACE
Creator name CREATOR
DB2 database name DB2NAME
Function SUB-FUNCTION
Dataspace ID DSSPACE-ID
List incorporated code LIST
Update dataspace attributes UPD-DS
SQL Server SQL-SERVER