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:
DES0001N | Incorrect 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.
DES0002N | Invalid 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.
DES0004N | The 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.
DES0005N | The 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.
DES0015W | A 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.
DES0016W | A 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.
DES0017W | Feature 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.
DES0018W | option 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.
DES0121N | Memory could not be allocated (malloc failed). |
Explanation: No storage could be reserved for the application.
What to do: Increase the paging space.
DES0333N | A 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.
DES0709W | The 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.
DES0377N | A 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.
DES0700N | The 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.
DES0701N | The node number value '%s1' is out of range." |
Explanation: The specified node number is invalid.
What to do: Check the DB2 node number.
DES0704N | Format '%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.
DES0705N | The 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.
DES0706N | The 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.
DES0707N | Format '%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.
DES0710N | A 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.
DES0711N | An 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.
DES0712N | Parameter '%s1' is too long. |
Explanation: The specified parameter %s1 is out of range.
What to do: Specify the parameter %s1 using a valid length.
DES0713N | The 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.
DES0714N | Specify 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.
DES0715N | Data 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.
DES0716N | Format 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.
DES0717N | Language 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.
DES0718N | CCSID ccsid_value is not supported. |
Explanation: You specified an invalid CCSID value.
What to do: See the documentation for a list of supported CCSIDs.
DES0719N | A 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.
DES0720N | The 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.
DES0721N | The 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.
DES0722N | Table 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.
DES0723N | The 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.
DES0724N | An 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.
DES0727N | Column 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.
DES0728N | Column 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.
DES0729N | Handle 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.
DES0730N | Table 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.
DES0731N | Table 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.
DES0732N | The 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.
DES0733N | Table 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.
DES0734N | Handle 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.
DES0736N | handlecolumn 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.
DES0737N | Table 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.
DES0738N | Access function schema.function has incorrect parameters. |
Explanation: The input or output parameters of schema.function are incorrect.
DES0739W | The 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.
DES0740N | Handle 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.
DES0741N | The 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.
DES0742N | This 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.
DES0745N | The 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.
DES0747N | The 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.
DES0748N | The 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).
DES0749N | The 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).
DES0750N | The 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).
DES0751N | You 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.
DES0756N | The 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.
DES0763N | The 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).
DES0765N | The 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.
DES0766N | An 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.
DES0769W | Warning: 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
DES0770N | The 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.
DES0774N | The 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.
DES0775N | The 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.
DES0776N | The 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.
DES0777N | The 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.
DES0779I | Indexing 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.
DES0780I | Index 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.
DES0789W | Warning: 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.
DES0800I | The %s1 command completed successfully. |
Explanation: The specified command completed successfully.
What to do: No action required.
DES0810N | Closing 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.
DES0812N | Table 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.
DES0813N | Table 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.
DES0814N | Table %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.
DES0815N | Empty 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.
DES0816N | The 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.
DES0818N | Unexpected 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.
DES0819N | Unexpected 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.
DES0820N | Index 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.
DES0821N | The 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.
DES0822N | The 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.
DES0823N | A 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.
DES0824N | Unexpected 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.
DES0826N | Database 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.
DES0827N | The 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.
DES0829N | The 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.
DES0830N | Parameter "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.
DES0831N | Unexpected end of command. The table name is missing. |
Explanation: The administration command requires a table name.
What to do: Enter the appropriate table name.
DES0832N | Unexpected end of command. The database name is missing. |
Explanation: The administration command requires a database name.
What to do: Enter the appropriate database name.
DES0833N | Unexpected end of command. The column name is missing. |
Explanation: The administration command requires a column name.
What to do: Enter the appropriate column name.
DES0899N | Unknown 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.
DES0971N | Index 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.
DES0972N | The 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.
DES0973N | The 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.
DES0974N | The 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.
DES0975N | The 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.
DES0976N | The 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.
DES0977N | The 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.
DES0998N | The 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.
DES0999N | The 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.
DES9994N | A 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.
DES9995N | A 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.
DES9996N | An 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.
DES9997N | An 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.
DES9998N | An SQL error occurred. No further information is available. |
DES9999N | No 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.