This structure is used to provide the database manager start-up
options.
Table 42. Fields in the SQLE-START-OPTIONS Structure
| Field Name | Data Type | Description |
|---|---|---|
| SQLOPTID | CHAR | An "eyecatcher" value which must be set to SQLE_STARTOPTID_V51. |
| ISPROFILE | UNSIGNED LONG | Indicates whether a profile is specified. If this field indicates that a profile is not specified, the file db2profile is used. |
| PROFILE | CHAR(236) | The name of the profile file to be executed at each node to define the DB2 environment (MPP only). This file is executed before the nodes are started. The default value is db2profile. |
| ISNODENUM | UNSIGNED LONG | Indicates whether a node number is specified. If specified, the start command only affects the specified node. |
| NODENUM | SQL_PDB_NODE_TYPE | Node number. |
| OPTION | UNSIGNED LONG | Specifies an action. See below for values. |
| ISHOSTNAME | UNSIGNED LONG | Indicates whether a host name is specified. |
| HOSTNAMEa | CHAR(256) | System name. |
| ISPORT | UNSIGNED LONG | Indicates whether a port number is specified. |
| PORTa | SQL_PDB_PORT_TYPE | Port number. |
| ISNETNAME | UNSIGNED LONG | Indicates whether a net name is specified. |
| NETNAMEa | CHAR(256) | Net name. |
| TBLSPACE_TYPE | UNSIGNED LONG | Specifies the type of 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 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. |
| ISCOMPUTER | UNSIGNED LONG | Indicates whether a computer name is specified. Valid on OS/2 or the Windows operating system only. |
| COMPUTER | CHAR(16) | Computer name. Valid on OS/2 or the Windows operating system only. |
| PUSERNAME | CHAR | Logon account user name. Valid on OS/2 or the Windows operating system only. |
| PPASSWORD | CHAR | Logon account password. Valid on OS/2 or the Windows operating system only. |
|
a This field is valid only for the SQLE_ADDNODE or
the SQLE_RESTART value of the OPTION field.
| ||
Valid values for OPTION (defined in sqlenv) are:
For more information about these options, see the Command Reference.
Valid values for TBLSPACE_TYPE (defined in sqlenv) are:
Language Syntax
C Structure
/* File: sqlenv.h */
/* Structure: SQLE-START-OPTIONS */
/* ... */
SQL_STRUCTURE sqle_start_options
{
char sqloptid[8];
unsigned long isprofile;
char profile[SQL_PROFILE_SZ+1];
unsigned long isnodenum;
SQL_PDB_NODE_TYPE nodenum;
unsigned long option;
unsigned long ishostname;
char hostname[SQL_HOSTNAME_SZ+1];
unsigned long isport;
SQL_PDB_PORT_TYPE port;
unsigned long isnetname;
char netname[SQL_HOSTNAME_SZ+1];
unsigned long tblspace_type;
SQL_PDB_NODE_TYPE tblspace_node;
unsigned long iscomputer;
char computer[SQL_COMPUTERNAME_SZ+1];
char *pUserName;
char *pPassword;
};
/* ... */
|
COBOL Structure
* File: sqlenv.cbl
01 SQLE-START-OPTIONS.
05 SQLOPTID PIC X(8).
05 SQL-ISPROFILE PIC 9(9) COMP-5.
05 SQL-PROFILE PIC X(235).
05 FILLER PIC X.
05 SQL-ISNODENUM PIC 9(9) COMP-5.
05 SQL-NODENUM PIC S9(4) COMP-5.
05 FILLER PIC X(2).
05 SQL-OPTION PIC 9(9) COMP-5.
05 SQL-ISHOSTNAME PIC 9(9) COMP-5.
05 SQL-HOSTNAME PIC X(255).
05 FILLER PIC X.
05 SQL-ISPORT PIC 9(9) COMP-5.
05 SQL-PORT PIC S9(9) COMP-5.
05 SQL-ISNETNAME PIC 9(9) COMP-5.
05 SQL-NETNAME PIC X(255).
05 FILLER PIC X.
05 SQL-TBLSPACE-TYPE PIC 9(9) COMP-5.
05 SQL-TBLSPACE-NODE PIC S9(4) COMP-5.
05 FILLER PIC X(2).
05 SQL-ISCOMPUTER PIC 9(9) COMP-5.
05 SQL-COMPUTER PIC X(15).
05 FILLER PIC X.
05 SQL-P-USER-NAME USAGE IS POINTER.
05 SQL-P-PASSWORD USAGE IS POINTER.
*
|