Each row contains configuration options at the server level.
Table 86. Columns in SYSCAT.SERVEROPTIONS Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
WRAPNAME | VARCHAR(128) | Yes | Wrapper name. |
SERVERNAME | VARCHAR(128) | Yes | Name of the server. |
SERVERTYPE | VARCHAR(30) | Yes | Server type. |
SERVERVERSION | VARCHAR(18) | Yes | Server version. |
CREATE_TIME | TIMESTAMP |
| Time when entry is created. |
OPTION | VARCHAR(128) |
| Name of the server option. |
SETTING | VARCHAR(2048) |
| Value of the server option. |
SERVEROPTIONKEY | VARCHAR(18) |
| Uniquely identifies a row. |
REMARKS | VARCHAR(254) | Yes | User supplied comments, or null. |