Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming


Messages from Text Extender

Each message has a message identifier that consists of a prefix (DES), the message number, and a suffix letter. The suffix letter indicates how serious the occurrence is that produced the message:

I
Information message

W
Warning message

N
Error (or "negative") message

C
Critical error message.

DES0001NIncorrect number of arguments for the db2txinstance command.

Explanation: The db2txinstance command needs two arguments.

What to do: Enter the command again with these arguments:

db2txinstance instanceName db2InstanceName

where instanceName is the login name of an existing UNIX user that is being assigned as the owner of this instance, and db2InstanceName is the login name of the owner of the corresponding DB2 instance.

DES0002NInvalid instanceName.

Explanation: The specified instance name must be the login name of an existing UNIX user.

What to do: Correct the instance name, or select an existing UNIX user, or create a UNIX user to be the instance owner.

Enter the db2txinstance command again as follows:

db2txinstance instanceName

where instanceName is the login name of the selected UNIX user.

DES0004NThe specified instance already exists. The command cannot be processed.

Explanation: The instanceName specifies the login name of a UNIX user that is the owner of the instance. This instance owner already has a db2tx directory in the home directory.

What to do: To create the instance, remove the existing instance and then try the command again.

DES0005NThe installation message catalog cannot be found.

Explanation: The message catalog required by the installation scripts is missing from the system; it may have been deleted or the database products may have been loaded incorrectly.

What to do: Verify that the db2tx_01_01_0000.client product option is installed correctly. If there are verification errors, reinstall the option.

DES0015WA linguistic search term specification does not match the index type.

Explanation: The linguistic specification of the search term of the query does not correspond to the type of index. For example, PRECISE FORM OF should not be used with a linguistic index. The default linguistic specification is used as shown in Table 5.

What to do: Adapt your application to prevent the specification of query options that conflict with the index type.

DES0016WA language specification is not supported for the current index type.

Explanation: The language you have specified is not supported for the specified index type.

What to do: See the documentation for a list of supported languages for the index type.

DES0017WFeature extraction has not been enabled.

Explanation: You used a feature search argument in your query but the index was not build with index option FEATURE_EXTRACTION.

What to do: Change the index option to FEATURE_EXTRACTION.

DES0018Woption is not supported for the current index type.

Explanation: You requested a search option that is not supported for the current index type and index option.

What to do: Check which index type or index option supports the requested search option. See Table 5.

DES0121NMemory could not be allocated (malloc failed).

Explanation: No storage could be reserved for the application.

What to do: Increase the paging space.

DES0333NA text index file I/O problem occurred.

Explanation: The Text Extender client cannot establish a session with the requested server.

What to do: Check that the Text Extender server has been started. If not, run TXSTART.

DES0709WThe dictionary for the specified language is not installed.

Explanation: Text Extender cannot find the dictionary files.

What to do: Install, or reinstall the dictionary for the specified language.

DES0377NA text index file I/O problem occurred.

Explanation: Text Extender cannot access the text index. This can happen if the DIRECTORY setting in the text configuration points to an invalid directory.

What to do: Check the text configuration settings.

DES0700NThe node number value '%s1' is not contained in the node group definition.

Explanation: The specified node number is invalid.

What to do: Check the DB2 node number.

DES0701NThe node number value '%s1' is out of range."

Explanation: The specified node number is invalid.

What to do: Check the DB2 node number.

DES0704NFormat '%s1' requires the specification of an index property.

Explanation: The document format is not compatible with the index type information.

What to do: Specify an index property that is compatible with the document format.

DES0705NThe specified document model name '%s1' was not found in the model definition file.

Explanation: The document model name was not found in the model definition file. Not that the model name is case-sensitive.

What to do: Use a model name that is specified in the model definition file.

DES0706NThe model definition file cannot be accessed on the DB2 Text Extender server.

Explanation: The model definition file was not found or cannot be opened.

What to do: Check that the model definition file exists.

DES0707NFormat '%s1' does not support the specified index property.

Explanation: The document format does not support the index property.

What to do: Specify an index property that is compatible with the document format.

DES0710NA null pointer is not allowed for parameter '%s1'.

Explanation: No value is specified for parameter %s1.

What to do: Specify a value for parameter %s1.

DES0711NAn internal Text Extender error occurred. Diagnosis information: '%s1'.

Explanation: An internal processing error occurred.

What to do: Check the diagnostic message to solve the problem. If the internal error was not caused by an installation problem, additional information may be in the desdiag.log file or in a created trace file. If this does not help, collect the available information and call your IBM service representative.

DES0712NParameter '%s1' is too long.

Explanation: The specified parameter %s1 is out of range.

What to do: Specify the parameter %s1 using a valid length.

DES0713NThe length of parameter '%s1' is incorrect: %d1.

Explanation: The specified parameter %s1 is out of range.

What to do: Specify the parameter %s1 using a valid length.

DES0714NSpecify parameter parameter either directly or in the configuration table.

Explanation: CCSID, format, or language was not specified, and there is no text configuration setting for this value.

What to do: Either specify the missing parameter directly in the ENABLE TEXT COLUMN command, or set a value in the text configuration settings.

DES0715NData type schema.type is not supported for text data.

Explanation: schema.type is the schema name and type name of the text column or the result of an access function. The data type for a text column is not supported by Text Extender. It must be CHAR, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC, DBCLOB, VARCHAR, LONG VARCHAR, or CLOB. If this is not the case, you must provide an access function whose input is the data type of the text column and whose output is VARCHAR, LONG VARCHAR, or LOB.

What to do: If schema.type is a text column type, you must register an access function with a result of type VARCHAR, LONG VARCHAR, or LOB. If schema.type is the result of an access function, it cannot be used. Provide an access function with a result of the required type.

DES0716NFormat format is not supported.

Explanation: format is a format that is not supported by Text Extender.

What to do: Check the list of supported formats in Formats.

DES0717NLanguage language is not supported.

Explanation: language is a language that is not supported by Text Extender.

What to do: Check the list of supported languages in Languages.

DES0718NCCSID ccsid_value is not supported.

Explanation: You specified an invalid CCSID value.

What to do: See the documentation for a list of supported CCSIDs.

DES0719NA call to the Text Extender program program failed with return code rc.

Explanation: An error may have occurred during installation. The return codes are listed in file DES_EXT.H.

What to do: Check if the installation was successful. Check that the environment variables such as DB2TX_INSTOWNER and DB2TX_INSTOWNERHOMEDIR are set correctly.

DES0720NThe access function schema.function is not registered in the database.

Explanation: The name of the function is either incorrect or has not been registered with the database.

What to do: Check the name of the access function. If it is correct, check that the function is known to the database system. Use the CREATE FUNCTION to register the access function with the database.

DES0721NThe database is inconsistent; a Text Extender catalog view is missing.

Explanation: One of the Text Extender catalog views is not in the database.

What to do: Use the DISABLE DATABASE command to remove the remaining catalog views, then enter ENABLE DATABASE again. The index data is lost; reindex the text documents.

DES0722NTable schema.table is not a base table in the database.

Explanation: Either the table does not exist in the database or it is a result table or a view. A text column must be in a base table before it can be enabled for Text Extender.

What to do: Ensure that the table name is correct, and that it is a base table.

DES0723NThe creation of an index for the handle column handlecolumnname in table schema.table failed.

Explanation: A text index could not be created for the handle column.

What to do: Use txstatus to check the status of the server. If the services on the server are running correctly, use DISABLE TEXT COLUMN or DISABLE TEXT TABLE to get a consistent state again. Then enable the text column again using ENABLE TEXT COLUMN or ENABLE TEXT TABLE.

DES0724NAn entry in the TextIndices catalog view for the handle column handlecolumn in table schema.table is missing.

Explanation: The TextIndices catalog view is damaged.

What to do: Use DISABLE TEXT COLUMN or DISABLE TEXT TABLE to get a consistent state again. Then enable the text column using ENABLE TEXT COLUMN or ENABLE TEXT TABLE.

DES0727NColumn column in table schema.table is already enabled.

Explanation: This message can occur if the table has been dropped and then recreated using the same text column, without first disabling the column.

What to do: Disable the column, then try again.

DES0728NColumn column does not exist in table schema.table.

Explanation: You are trying to enable a text column that does not exist.

What to do: Change the table name or the column name, then try again.

DES0729NHandle column handlecolumn does not exist in table schema.table.

Explanation: You are trying to use a handle column that does not exist.

What to do: Use the GET STATUS command to check if the handle column exists, and that its name has been specified correctly.

DES0730NTable schema.table is already enabled as a common-index table.

Explanation: You are trying to enable a table that has already been enabled as a common-index table.

What to do: Either continue without enabling the table, or run the DISABLE TEXT TABLE command to disable the table before enabling it again.

DES0731NTable schema.table is not enabled for Text Extender; it cannot be disabled.

Explanation: You are trying to disable a table that has not been enabled.

What to do: Check the table name.

DES0732NThe update frequency is incorrect near location location; expected was parameter.

Explanation: The parameter specification for the Update Frequency was not correct.

What to do: Check the update frequency parameter and reenter the command.

DES0733NTable schema.table contains an enabled column; it cannot be enabled as a common-index table.

Explanation: This table contains a text column that already has its own index. You cannot create a common index for all the text columns while this individual index exists.

What to do: Use DISABLE TEXT COLUMN to disable the enabled columns, then enter the ENABLE TEXT TABLE command again.

DES0734NHandle column handlecolumn belongs to the partial-text table schema.table; it cannot be disabled separately.

Explanation: You cannot disable a single text column in a table that was enabled as a partial-text table.

What to do: Disable the complete partial-text table.

DES0736Nhandlecolumn is already a handle column in table schema.table.

Explanation: You are trying to use an existing handle column name.

What to do: Reenter the command, using a different name for the handle column.

DES0737NTable schema.tablename is enabled as a common-index table with STORAGE option storage_option.

Explanation: It is not possible to enable a common index table for external files.

What to do: If you want to enable a table for external files, use a multi-index table.

DES0738NAccess function schema.function has incorrect parameters.

Explanation: The input or output parameters of schema.function are incorrect.

DES0739WThe index update program for table schema.table, handle column name handlecolumn, could not be started.

Explanation: The program that updates indexes could not be started. An error may have occurred during installation.

What to do: Check if the installation was successful. Check that the environment variables such as DB2TX_INSTOWNER and DB2TX_INSTOWNERHOMEDIR are set correctly.

DES0740NHandle column '%s1' can be reused only for a text column of type '%s2.%s3'.

Explanation: The handle column has already been used for another handle column type.

What to do: Specify a new handle column name.

DES0741NThe program or file parameter was not found or could not be started.

Explanation: The ENABLE DATABASE or DISABLE DATABASE command could not open the file parameter. An error may have occurred during installation.

What to do: Check if the installation was successful.

DES0742NThis table uses column indexes. Specify a handle column in the command.

Explanation: The specified table is enabled as multi index table. To work with a specific column specify the related handle column.

What to do: Specify a handle column.

DES0745NThe DB2TX instance owner instance-owner is not a valid user ID.

Explanation: The environment variable DB2TX_INSTOWNER does not contain a valid user ID.

What to do: Correct the environment variable.

DES0747NThe current CCSID is not supported for index type index_type.

Explanation: You specified a CCSID that is not supported for the requested index type.

What to do: See the documentation for a list of supported CCSIDs.

DES0748NThe commit count value '%s1' is not supported by DB2 Text Extender.

Explanation: The specified commit count value is not supported.

What to do: Specify a valid commit count value (see Administration and Programming guide).

DES0749NThe update index value '%s1' is not known by DB2 Text Extender.

Explanation: The specified 'update index' value is invalid.

What to do: Specify a valid 'update index' value (see Administration and Programming guide).

DES0750NThe index type value '%s1' is not known by DB2 Text Extender.

Explanation: The specified 'index type' value is invalid.

What to do: Specify a valid 'index type' value (see Administration and Programming guide).

DES0751NYou do not have the authorization to perform the specified operation.

Explanation: You do not have the required database administrator authorization to do this operation.

What to do: Have this operation done by a database administrator.

DES0756NThe database is not enabled for Text Extender.

Explanation: The database must be enabled before this command can be run.

What to do: Run ENABLE DATABASE, then resubmit the command.

DES0763NThe update frequency is incorrect.

Explanation: The specified 'update frequency' value is invalid.

What to do: Specify a valid 'update frequency' (see Administration and Programming guide).

DES0765NThe database is already enabled for Text Extender.

Explanation: You are trying to enable a database that is already enabled.

What to do: Either continue without enabling the database, or use DISABLE DATABASE to disable the database before enabling it again.

DES0766NAn action has caused the maximum row size of the table or a temporary table to be exceeded.

Explanation: The ENABLE TEXT COLUMN command adds a handle column to the table. If the table is already large, this can cause the row size of the table to exceed the maximum value of 4005.

The ENABLE TEXT COLUMN command also creates a temporary table whose size is proportional to the number of text columns that are already enabled. If many text columns are already enabled, the size of the temporary table may exceed the maximum value.

What to do: Use the ENABLE TEXT COLUMN only on tables that do not cause this limit to be exceeded.

DES0769WWarning: Index characteristic have been specified but will be ignored. Table %s1.%s2 is a common-index table.

Explanation: The specified table is a common index table therefore no index characteristics can be specified.

What to do: No action required

DES0770NThe environment variable env-variable is not defined.

Explanation: A parameter for a command was not specified and the system tried to read the default value from the environment variable env-variable, but this environment variable is not defined.

What to do: Define the required environment variable.

DES0774NThe value length %d1 for variable '%s1' is out of range.

Explanation: The value length of parameter %s1 is out of range.

What to do: Specify the parameter %s1 using a valid length.

DES0775NThe index directory value '%s1' is incorrect.

Explanation: The index directory value is incorrect, may be the directory length is incorrect.

What to do: Specify a valid index directory value.

DES0776NThe table space name '%s1' is incorrect.

Explanation: The specified table space name is incorrect, may be the table space value length is incorrect.

What to do: Specify a valid table space value.

DES0777NThe table space '%s1' is not known by the database management system.

Explanation: The specified table space is not known to the database system.

What to do: Check that the specified table space exists in the database.

DES0778N '%s1' is not a REGULAR table space. It was created with keyword" '%s2'.

Explanation: Data type for specified table space is not supported.

What to do: Specify a regular table space.

DES0779IIndexing has been started successfully. To check indexing status use 'GET INDEX STATUS'.

Explanation: The indexing program has started. You can use the 'GET INDEX STATUS' command to check the status of the indexing process.

What to do: Check output of "GET INDEX STATUS' command.

DES0780IIndex reorganization has been started successfully. To check the index status use 'GET INDEX STATUS'.

Explanation: The reorganization program has started. You can use the 'GET INDEX STATUS' command to check the status of the reorganization process.

What to do: Check output of "GET INDEX STATUS' command.

DES0789WWarning: The partitioning map of the current nodegroup has been updated, please call the TXNCHECK utility.

Explanation: The partitioning map of the current nodegroup has been updated.

What to do: Use "TXNCHECK' command.

DES0800IThe %s1 command completed successfully.

Explanation: The specified command completed successfully.

What to do: No action required.

DES0810NClosing quotation mark is missing.

Explanation: A quotation mark has been found, but the second quotation mark is missing.

What to do: Check the syntax of the command and try again.

DES0811N"token" is unexpected. Check the index characteristics or the text information.

Explanation: The index characteristics or the text information is incorrect.

What to do: Check the syntax and try again.

DES0812NTable schema.table does not exist or is not enabled for DB2 Text Extender.

Explanation: While running the GET command, either the name of a database table is incorrect, or the table does not exist, or it has not yet been enabled.

What to do: If the table name is correct, use GET STATUS to check that it has been enabled. Enable the table and try again.

DES0813NTable schema.table does not exist or is not enabled for DB2 Text Extender or does not contain a handle column column.

Explanation: While running the GET command, no entries for the handle column are found in the table. If the table exists, it is not enabled or it does not contain a handle column.

What to do: If the table name is correct, use GET STATUS to check that it has been enabled. Enable the table and try again.

DES0814NTable %s1.%s2 does not exist or is not enabled for DB2 Text Extender or no text column is enabled within this table.

Explanation: The specified table is not enabled for Text Extender.

What to do: Enable the table for Text Extender.

DES0815NEmpty quotes "" found. A name is expected inside the quotes.

Explanation: Two consecutive quotation marks were found with no text between them.

What to do: Check the syntax and try again.

DES0816NThe word "token" is unexpected. Use one of the keywords keyword or keyword.

Explanation: An unexpected token was found.

What to do: In the command, use one of the keywords given in the message.

DES0817N"token" is unexpected. Use the keyword keyword.

Explanation: An unexpected token was found.

What to do: In the command, use the keyword given in the message.

DES0818NUnexpected end of command. The keyword keyword is expected.

Explanation: A keyword is missing.

What to do: In the command, use the keyword given in the message.

DES0819NUnexpected end of command. One of the following keywords is expected: keyword or keyword.

Explanation: A keyword is missing.

What to do: In the command, use one of the keywords given in the message.

DES0820NIndex option index_option is not supported for index type index_type.

Explanation: You specified an index option that is not supported for the given index type.

What to do: See the documentation for supported index options for the given index type.

DES0821NThe name "token" is too long. Only nn characters are allowed for variable names.

Explanation: A name is too long.

What to do: Specify a name having an acceptable length.

DES0822NThe command contains an unrecognized token "token". End of command is expected.

Explanation: End of command found, but a keyword is expected.

What to do: Check the syntax of the command and try again.

DES0823NA table name is expected following "schema.".

Explanation: A table name or a function name is missing after the ".".

What to do: Check the syntax of the command and try again.

DES0824NUnexpected end of command; a keyword is required.

Explanation: The keyword in the message is missing from the syntax.

What to do: Check the syntax of the command and try again.

DES0825N'%s1' is not a known database alias name. Only %d1 characters are allowed.

Explanation: The specified database alias name is unknown to the database system.

What to do: Check that the specified alias name is valid.

DES0826NDatabase alias alias must not be in quotation marks.

Explanation: The name in the message has been interpreted as a database alias. It must not be in quotation marks.

What to do: Check the syntax of the command and try again.

DES0827NThe CCSID "ccsid" is not supported.

Explanation: The CCSID is not one of those supported by Text Extender.

What to do: Refer to the documentation for a list of the supported CCSIDs.

DES0829NThe user name userid must not be in quotation marks.

Explanation: You entered a user name in quotation marks.

What to do: Remove the quotation marks.

DES0830NParameter "parameter" in the enable/disable DATABASE command not recognized. End of command expected.

Explanation: The commands ENABLE DATABASE and DISABLE DATABASE do not take parameters.

What to do: Enter the command again without parameters.

DES0831NUnexpected end of command. The table name is missing.

Explanation: The administration command requires a table name.

What to do: Enter the appropriate table name.

DES0832NUnexpected end of command. The database name is missing.

Explanation: The administration command requires a database name.

What to do: Enter the appropriate database name.

DES0833NUnexpected end of command. The column name is missing.

Explanation: The administration command requires a column name.

What to do: Enter the appropriate column name.

DES0899NUnknown DB2TX command: command.

Explanation: The specified command is not supported by Text Extender

What to do: Type db2tx ? to get a list of the commands.

DES0971NIndex directory can be specified once without node specification or multiple times with node specification.

Explanation: The specification of the index directory/ies is not correct.

What to do: Check the specification of the index directory. You can specify one index directory without a node specification or multiple index directories with node specification.

DES0972NThe node specification is not correct. An unsigned digit value is expected.

Explanation: A non digit value is specified for the node number.

What to do: Specify an unsigned digit value for the node number.

DES0973NThe node specification is not correct. One or more unexpected characters found before right parenthesis.

Explanation: The node specification is syntactical incorrect.

What to do: Check the syntax of the node specification and try again.

DES0974NThe sequence of the node numbers in a TO clause is not correct (second node smaller than first node).

Explanation: The node specification is syntactical incorrect.

What to do: Check the syntax of the node specification and try again.

DES0975NThe syntax for the specification of the node information is not correct.

Explanation: The node specification is syntactical incorrect.

What to do: Check the syntax of the node specification and try again.

DES0976NThe node information is incomplete.

Explanation: The node specification is incomplete - some information is missing.

What to do: Check the syntax of the node specification and try again.

DES0977NThe node information is incomplete. The left parenthesis is missing.

Explanation: The node specification is incomplete - left parenthesis is missing.

What to do: Correct the node specification and try again.

DES0998NThe document model name length is incorrect.

Explanation: The length of the 'document model name' value is incorrect.

What to do: Check the model name value and try again.

DES0999NThe syntax for the specification of the document model(s) is not correct.

Explanation: The specification of the model name(s) is syntactical incorrect.

What to do: Check the syntax of the model(s) specification and try again.

DES9994NA Text Search Engine error occurred. Reason code: reason-code

Explanation: The text search engine used by Text Extender raised an error.

What to do: Check the search engine reason code (use TSE documentation). If the reported reason does not help to solve the problem additional information may be in the desdiag.log file or in a created trace file. If this does not help collect the available information and call your IBM service representative.

DES9995NA Text Extender error occurred. Message text: message-text

Explanation: A Text Extender error occurred.

What to do: Use the message provided by Text Extender to solve the problem. If the reported message does not help to solve the problem additional information may be in the desdiag.log file or in a created trace file. If this does not help collect the available information and call your IBM service representative.

DES9996NAn internal Text Extender error occurred. Reason code: reason_code

Explanation: An internal processing error occurred.

What to do: Check that the Text Extender installation has been completed successfully. If yes, note the reason code and call your IBM service representative.

DES9997NAn SQL error occurred. SqlState: state QL Error code: rc; SqlErrorMessage: message

Explanation: An SQL error occurred.

What to do: Take action on the SQL error message that is displayed with the message.

DES9998NAn SQL error occurred. No further information is available.

DES9999NNo corresponding error message.

Explanation: An internal processing error occurred.

What to do: Check the diagnostic message to solve the problem. If no installation problem causes the internal error additional information may be in the desdiag.log file or in a created trace file. If this does not help collect the available information and call your IBM service representative.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]