SYSIBMTS.SYSTEXTSERVERHISTORY administration table

The SYSIBMTS.SYSTEXTSERVERHISTORY administration table is an auxiliary table that records a history of used servers for the SYSPROC.SYSTS_DROP stored procedure.

The following table shows the contents of the SYSIBMTS.SYSTEXTSERVERHISTORY administration table. The foreign key is the INDEXID column.

Table 1. Contents of the SYSIBMTS.SYSTEXTSERVERHISTORY administration table
Column name	Data type	Nullable?	Description
INDEXID	INTEGER	No	The index ID for a created text search index.
SERVERID	INTEGER	No	The server ID where a text search index needs to be dropped on SYSPROC.SYSTS_DROP.