SYSIBMTS.TSSERVERS view

Each row represents of the SYSIBMTS.TSSERVERS view displays information about a Db2® Text Search server configured for the database.

You can query the view to obtain information about the text search server that is marked as the one to be used: 
db2 "SELECT SERVERID, HOST from SYSIBMTS.TSSERVERS where SERVERSTATUS = 0"
Table 1. SYSIBMTS.TSSERVERS view
Column name Data type Nullable? Description
SERVERID INTEGER NO Unique ID generated for the text search server.
HOST VARCHAR(256) NO Host name or IP address of the text search server. For partitioned databases, stand-alone text search server deployments or when administrative operations are executed from remote clients, make sure to use the actual host name or IP address, not 'localhost'.
PORT INTEGER NO Port number for the text search server. (ADMIN/SEARCH)
TOKEN VARCHAR(256) NO Authentication token for the text search server.
KEY VARCHAR(128) NO The server key for the text search server.
LOCALE VARCHAR(33) NO The client locale that is assumed for messages sent from the text search server.
SERVERTYPE INTEGER NO The value indicates the type for each text search server.
  • 0 = the default (integrated) text search server
  • non-zero value = a stand-alone text search server
    • 1 = a local stand-alone text search server
    • 2 = a remote stand-alone text search server
SERVERSTATUS INTEGER NO Indicates whether the text search server can be used to create new text search indexes. The default value is 0, indicating that the server is active and usable.