QSYS2.SYSTEXTSERVERHISTORY administration table
You can see the history of servers used for the SYSPROC.SYSTS_DROP stored procedure by viewing the auxiliary table QSYS2.SYSTEXTSERVERHISTORY.
The following table shows the contents of the QSYS2.SYSTEXTSERVERHISTORY administration table. The unique key for this table is the INDEXID column with the SERVERID column. The foreign key is the INDEXID column.
| 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. |