This structure is used to provide the database manager stop options.
Table 38. Fields in the SQLEDBSTOPOPT Structure
| Field Name | Data Type | Description |
|---|---|---|
| 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 that was executed at startup to define the DB2 environment for those nodes that were started (MPP only). If a profile for sqlepstart - Start Database Manager was specified, the same profile must be specified here. |
| 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 | Option. |
| CALLERAC | UNSIGNED LONG | Caller action. This field is valid only for the SQLE_DROP value of the OPTION field. |
Valid values for OPTION (defind in sqlenv) are:
For more information about these options, see the Command Reference.
Valid values for CALLERAC (defind in sqlenv) are:
Language Syntax
C Structure
/* File: sqlenv.h */
/* Structure: SQLEDBSTOPOPT */
/* ... */
SQL_STRUCTURE sqledbstopopt
{
unsigned long isprofile;
char profile[SQL_PROFILE_SZ+1];
unsigned long isnodenum;
SQL_PDB_NODE_TYPE nodenum;
unsigned long option;
unsigned long callerac;
};
/* ... */
|
COBOL Structure
* File: sqlenv.cbl
01 SQLEDBSTOPOPT.
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-CALLERAC PIC 9(9) COMP-5.
*
|