Incorporating DB2 Databases

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 Databases

Selection criteria

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

Parameters
DB2 database name DB2 database name. Asterisk notation is allowed.
Creator name Creator name. Asterisk notation is allowed.
Update DB 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 database object are to be updated.

Databases which meet the selection criteria and are not already connected to a Predict database object are then provided in the drop-down list box on the next page of the schema incorporation wizard.

Information in the drop-down list box
Creator Creator of the database.
Database name Name of the database
Predict database ID ID of Predict database object for a DB2 database with this DB2 name.
Remark Either the following type-specific remark 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.

Incorporation Functions for DB2 Databases

Valid functions:

Test

Compares the database and the Predict database object and reports differences between attributes and file lists.

Connect

Connects the DB2 database to the corresponding Predict database object and

  • copies current information from the DB2 catalog into the dictionary object;

  • writes to the generation log of the Predict database 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 DB attributes See the parameter table in Selecting DB2 Databases for a description of this parameter.

Incorporate

Scope of the Incorporation

  • Creates a database object of type D with attributes documenting the database.

  • The new database object is linked to the Predict object documenting the current virtual machine via association "Contains DA".

  • Connects the database and the Predict database object.

Specify the following parameters in an additional page of the schema incorporation wizard. The parameter Database ID is mandatory, the other parameter is optional

Incorporation Options
Database ID ID of the new Predict database object. The creator and DB2 name of the database joined by a hyphen is displayed and can be accepted or overwritten.
List incorporated code
Y The values of all attributes incorporated for the database are to be listed.

Keywords

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

Field Keyword
DB2 database name DB2NAME
Creator name CREATOR
Function SUB-FUNCTION
Database ID DATABASE-ID
List incorporated code LIST
Update DB attributes UPD-DB
SQL Server SQL-SERVER