This document covers the following topics:
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.
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. |
Valid functions:
Note:
Corresponding DB2 storagegroups and Predict objects of type
storagespace are identified by the DB2 storagegroup name.
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.
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.
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 |
|
||
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=*
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==.