SYSIBMTS.SYSTEXTSERVERS administration table
The SYSIBMTS.SYSTEXTSERVERS administration table stores information about where the text search servers are installed.
The following table shows the contents of the SYSIBMTS.SYSTEXTSERVERS administration table. The unique key for this table is the SERVERNAME column in conjunction with the SERVERPORT column. The primary key is the SERVERID column.
| Column name | Data type | Nullable? | Description |
|---|---|---|---|
| SERVERID | INTEGER | No | Uniquely generated ID for the text search server. |
| SERVERNAME | VARCHAR(128) | No | The hostname or IP address of the text search server. |
| SERVERADRINFO | VARBINARY(3000) | Yes | The internal representation of the SERVERNAME and SERVERPORT as determined by the SYSPROC.SYSTS_START stored procedure. |
| SERVERPORT | INTEGER | No | The port number for the text search server. |
| SERVERRESERVED | VARCHAR(128) | Yes | Reserved for future use. |
| SERVERAUTHTOKEN | VARCHAR(256) | No | The authentication token for the text search server. |
| DB2ENCRYPTEDPW | VARCHAR(256) | Yes | The encrypted Db2 password that is used by the user ID in the SYSIBMTS.SYSTEXTCONNECTINFO table to connect to the Db2 subsystem from the text search server. |
| SERVERMASTERKEY | VARCHAR(36) | No | The server key for the text search server. |
| STATUS | INTEGER | No | Indicates whether the server can be used as a text search server to create new text search indexes. The default value is 0 (zero), which means that the server can be used. |