sqle_addn_options data structure

This structure is used to pass information to the sqleaddn API.

Table 1. Fields in the SQLE-ADDN-OPTIONS Structure
Field Name Data Type Description
SQLADDID CHAR An "eyecatcher" value which must be set to SQLE_ADDOPTID_V51.
TBLSPACE_TYPE sqluint32 Specifies the type of system temporary table space definitions to be used for the node being added. See following section for values. Note: This option is ignored for system temporary table spaces that are defined to use automatic storage (that is system temporary table spaces that were created with the MANAGED BY AUTOMATIC STORAGE clause of the CREATE TABLESPACE statement or where no MANAGED BY CLAUSE was specified at all). For these table spaces, there is no way to defer container creation or choose to create a set of containers like they are defined on another partition. Containers will automatically be assigned by the database manager based on the storage paths that are associated with the database.
TBLSPACE_NODE SQL_PDB_NODE_TYPE Specifies the node number from which the system temporary table space definitions should be obtained. The node number must exist in the db2nodes.cfg file, and is only used if the tblspace_type field is set to SQLE_TABLESPACES_LIKE_NODE.
Valid values for TBLSPACE_TYPE (defined in sqlenv) are:
SQLE_TABLESPACES_NONE
Do not create any system temporary table spaces.
SQLE_TABLESPACES_LIKE_NODE
The containers for the system temporary table spaces should be the same as those for the specified node.
SQLE_TABLESPACES_LIKE_CATALOG
The containers for the system temporary table spaces should be the same as those for the catalog node of each database.

API and data structure syntax

SQL_STRUCTURE sqle_addn_options
{
        char sqladdid[8];
        sqluint32 tblspace_type;
        SQL_PDB_NODE_TYPE tblspace_node;
};

COBOL Structure

* File: sqlenv.cbl
01 SQLE-ADDN-OPTIONS.
    05 SQLADDID               PIC X(8).
    05 SQL-TBLSPACE-TYPE      PIC 9(9) COMP-5.
    05 SQL-TBLSPACE-NODE      PIC S9(4) COMP-5.
    05 FILLER                 PIC X(2).
*