This section describes the administration commands for displaying information about:
Summary |
---|
|
Enter:
db2tx "GET STATUS"
Here is an example of the output displayed by GET STATUS. It shows the enabled status of the database, and of any enabled tables, text columns, or text files that it contains.
Database is enabled for Text Extender Table DB2TX.MYTABLE is enabled as a common-index table Table DB2TX.SAMPLE is enabled as a common-index table TextColumnName HandleColumnName -------------- ---------------- COMMENT COMMENTHANDLE Table DB2TX.TEST is enabled as a multi-index table TextColumnName HandleColumnName -------------- ---------------- ABSTRACT1 ABSTRACT1HANDLE ABSTRACT2 ABSTRACT2HANDLE
Summary |
---|
|
Enter:
db2tx "GET ENVIRONMENT"
Here is an example of the output displayed by GET ENVIRONMENT. It shows the current settings of the Text Extender environment variables.
Current database manager instance (DB2INSTANCE) = db2 Default database name (DB2DBDFT) = my_database Instance name (DB2TX_INSTOWNER) = user1 Instance directory (DB2TX_INSTOWNERHOMEDIR) = /usr/instance1
Summary |
---|
|
These settings are described in Text configuration settings. To change them, see Changing the text configuration.
To display the text configuration, enter:
db2tx "GET TEXT CFG"
Here is an example of the output displayed by GET TEXT CONFIGURATION. It shows the current text configuration settings.
Coded character set ID (CCSID) = 850 Language (LANGUAGE) = US_ENGLISH Format (FORMAT) = TDS Index type (INDEXTYPE) = LINGUISTIC Update frequency (UPDATEFREQ) = NONE Index directory (DIRECTORY) = user1/db2tx/indexes Update index option (UPDATEINDEX) = UPDATE Commit count (COMMITCOUNT) = 10 000 Tablespace name (TABLESPACE) = TXLOG
Summary |
---|
|
Some situations can occur that prevent you from searching in an index, or from updating it. In such situations, messages are stored in the index's log table that can help you determine the cause. So it can be useful to check the status of an index, and whether there are any messages available.
This example displays the index status for the index of a common-index table:
db2tx "GET INDEX STATUS db2tx.sample"
The syntax lets you display the index status for a particular text column. This example gets the index status for the index of a multi-index table column:
db2tx "GET INDEX STATUS db2tx.sample HANDLE commenthandle"
Here is an example of the output displayed by GET INDEX STATUS.
Node 1 Search status = Search available Update status = Update available Reorg status = started 13.55 Scheduled documents = 0 Indexed documents = 187000 Primary index documents = 130000 Secondary index documents = 57000 Error events = No error events
If the index is split among several nodes, the node information is displayed per node.
When problems occur during indexing, such as a document scheduled for indexing could not be found, these so-called error events are written to the index's log table.
The event return codes are described in Chapter 16, Error event reason codes.
You can access the error events in a view of the log table called db2tx.LOGIXnnnnnn, where IXnnnnnn is the name of the index, obtainable from the catalog view.
To get the name of the index:
DB2 SELECT TABLENAME, HANDLENAME, INDEXNAME FROM DB2TX.TEXTCOLUMNS
The error event view has the following layout:
UPDATESTATUS SMALLINT EVENTREASON INTEGER EVENTMESSAGE VARCHAR(1024) UPDATETIME TIMESTAMP HANDLE DB2TEXTH or DB2TEXTFH NODENUMBER INTEGER
Here is an example showing how to access the information from the index log:
DB2 SELECT EVENTREASON, EVENTMESSAGE, UPDATETIME, HANDLE FROM DB2TX.LOGIXNNNNNN
Summary |
---|
|
This example gets the index settings for the index of a common-index table:
db2tx "GET INDEX SETTINGS db2tx.sample"
This example gets the index settings for the index of a multi-index table column:
db2tx "GET INDEX SETTINGS db2tx.sample HANDLE commenthandle"
If the table is enabled as a multi-index table, this command displays the index settings of all enabled text columns in the table.
Here is an example of the output displayed by GET INDEX SETTINGS for a common-index table. The output for a multi-index table shows similar information for each index. The syntax lets you request the index settings for a particular text column.
Current index settings: Index type (INDEXTYPE) = LINGUISTIC Update index option (UPDATEINDEX) = UPDATE Update frequency (UPDATEFREQ) = NONE Node 1 Index directory (DIRECTORY) = /home/user1/db2tx/indices
If the index is split among several nodes, the node information is displayed for the index directory.
Summary |
---|
|
This example gets the text information for the index of a common-index table:
db2tx "GET TEXT INFO db2tx.sample"
This example gets the text information for the index of a multi-index table column:
db2tx "GET TEXT INFO db2tx.sample HANDLE commenthandle"
The syntax lets you specify a table name and the name of a handle column.
If you specify only a table name in the command, the text information for each enabled column in this table is displayed. If you also specify a handle column name, only the text information for that column is displayed.
Here is an example of what is displayed by this command for a multi-index table:
Text information for column ABSTRACT1 with handle column ABSTRACT1HANDLE: Coded character set ID (CCSID) = 850 Language (LANGUAGE) = US_ENGLISH Format (FORMAT) = TDS Text information for column ABSTRACT2 with handle column ABSTRACT2HANDLE: Coded character set ID (CCSID) = 850 Language (LANGUAGE) = US_ENGLISH Format (FORMAT) = TDS