Text Extender must already be started at the server before you can use the client administration commands. If you are in doubt, ask an administrator to check whether Text Extender has been started by entering txstatus at the server where the Text Extender instance is installed.
If you have just installed Text Extender, do the tasks in this chapter in sequence, up to and including Enabling a text column. The remainder of the sections concern index maintenance.
In this chapter you need a DB2 UDB database to work with. If you do not yet have a database, create one now. Ensure that the database CCSID is one supported by Text Extender listed in CCSIDs.
Each task includes a summary showing when to do it, the command to use, and the required authorization. Refer to Chapter 7, Administration commands for the client for a description of the command parameters.
You do the client administration tasks by entering commands at the operating system prompt. These are similar to DB2 commands, but instead of preceding them with db2, you precede them with db2tx.
Do these tasks before any of the other administration tasks:
Do these tasks in the sequence shown before you search:
Disable a text column from use by Text Extender
Disable external text files from use by Text Extender
Disable a text table from use by Text Extender
Disable a database from use by Text Extender
Update an index
Change the settings of an index
Reset the status of an index
Delete index events
Display enabled status information
Display the settings of the environment variables
Display the text configuration settings
Display the index status
Display error events
Display the index settings
Display the text settings for a column