Administrative API Reference

SQLE-ADDN-OPTIONS

This structure is used to pass information to sqleaddn - Add Node.

Table 29. Fields in the SQLE-NODE-APPN 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 below for values.
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.

Language Syntax

C Structure 



/* File: sqlenv.h */
/* Structure: SQLE-ADDN-OPTIONS */
/* ... */
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).
*

[ Top of Page | Previous Page | Next Page ]