Incorporating DB2 Tablespaces and SQL/DS DBspaces

#### Search Results

Search

# Incorporating DB2 Tablespaces and SQL/DS DBspaces

This document covers the following topics:

- Prerequisites for DB2 Tablespaces

- Selecting Tablespaces

- Incorporation Functions for Tablespaces

- Incorporate DB2 Tablespaces in Batch Mode

## Prerequisites for DB2 Tablespaces

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

The Incorporate DB2 Tablespaces screen is called with function code I and object code TS in a Predict main menu or with the command `INCORPORATE TABLESPACE`.

    17:54:04             *****  P R E D I C T  *****              2007-05-31
    Plan   0              - Incorporate DB2 Tablespaces -

    Tablespace name ..........
    SQL Server ..............*                                  <Default Server>

    Select options
      Creator name ...........
      DB2 database name ......

    Processing option
      Connect automatic ...... N (Y,N)

    Update when connecting
      Dataspace 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
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.
Connect automatic | Y - The DB2 tablespace and the Predict object will be connected by the Compare function (code T) if no differences are detected between the file lists of the two objects.
Dataspace attributes | Y - Attributes of the Predict dataspace that differ from the DB2 tablespace are changed.

    13:13:06             *****  P R E D I C T  *****             2007-05-31
                          - Incorporate DB2 Tablespaces -
    Search-crit.: Tablespace name=ALL
        DB2       Tablespace   Predict
    Cmd database  name         dataspace ID                     Remark

    __  ABAG      ABAGTS01                                      DA missing
    __  ABAG      ABAGTS02                                      DA missing
    __  ABAG      ABAGTS03                                      DA missing
    __  ABAG      ABAGTS04                                      DA missing
    __  ABAG      ABAGTS05                                      DA missing
    __  BGCDA     AAB$PACE                                      SC missing
    __  BGCDA     TABSPACE     PD-TABSPACE                      SC missing
    __  DB01      TS01                                          DA missing

Columns in the List
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:

- Compare - Code T

- Connect - Code C

- Display Masters - Code M

- Incorporate - Code I

### Compare - Code T

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

If no differences are found and Connect automatic is set to Y, the tablespace/DBspace and the Predict dataspace object are connected.

### Connect - Code C

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.

### Display Masters - Code M

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 - Code I

#### 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 input screen before executing the function. 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.

## Incorporate DB2 Tablespaces in Batch Mode

Command: `INCORPORATE TABLESPACE`

Enter parameters on next line using positional or keyword form.

Field | Keyword | Position
--- | --- | ---
Tablespace name | TBSPACE | 1
Creator name | CREATOR | 2
DB2 database name | DB2NAME | 3
Connect automatic | AUTO-CONNECT | 4
Function | SUB-FUNCTION | 5
Dataspace ID | DSSPACE-ID | 6
List incorporated code | LIST | 7
Update dataspace attributes | UPD-DS | 8
SQL Server | SQL-SERVER | 9

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 Tablespace with the DB2 tablespace name "SYSDBASE" with dataspace ID "TEST-TS" and display the dataspace attributes, code the command:

    INCORPORATE TABLESPACE
    TBSPACE=SYSDBASE,SUB-FUNCTION=I,DSSPACE-ID=TEST-TS,
    LIST=Y

or

    INCORPORATE TABLESPACE
    SYSDBASE,,,,I,TEST-TS,Y

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

### On this page

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