You must enable each database that contains columns of text to be searched. You can enable a database forDB2® Text Search by using the db2ts ENABLE DATABASE FOR TEXT command or the SYSPROC.SYSTS_ENABLE stored procedure.
The authorization ID of the statement must hold the SYSTS_ADM role and DBADM authority.
After you enable a database for text search, it remains enabled until you explicitly disable it.
db2ts "ENABLE DATABASE FOR TEXT CONNECT TO databaseName"
The enable operation attempts to populate the connection information for the text search server in the SYSIBMTS.TSSERVERS administrative view. However, the information might be incomplete or insufficient. After the command completes either successfully or with a warning for incomplete enablement, review the values in SYSIBMTS.TSSERVERS view and update as necessary.
You must do this step only once for each database. You do not have to enable a database each time that you stop and restart the instance services.
db2ts "ENABLE DATABASE FOR TEXT CONNECT TO SAMPLE"
CALL SYSPROC.SYSTS_ADMIN_CMD
('ENABLE DATABASE FOR TEXT','en_US', ?)
CALL SYSPROC.SYSTS_ENABLE('en_US', ?)