CIE0000-0999
CIE Message ID | Message | Explanation | User Response |
---|---|---|---|
CIE0001I |
Operation completed successfully. |
No errors were encountered during the execution of this command. |
No action required. |
CIE0002I |
The DB2 Text Search catalog and text indexes are at the latest release level for the database. The system has not been upgraded. |
The database version value in the SYSIBMTS. TSDEFAULTS administrative view is set to the latest version. The database is up to date. |
No action required. |
CIE0003I |
Index update started. |
Update processing has started for a text search index, because either a UPDATE INDEX command was executed, or an automatic update was performed according to the update frequency specified for the index. Depending on the number of documents, processing may take some time, but the index is still available for searches. |
No response is required. |
CIE0004I |
Index update ended. |
Update processing has ended for a text search index. |
No response is required. |
CIE0005I |
DB2 Text Search Index update statistics: Total number of documents processed: number. Number of documents inserted: number. Number of documents updated: number. Number of documents deleted: number. Number of empty documents skipped successfully: number. Number of documents not indexed because of internal document errors: number. |
Update is complete. The statistics indicate the number of documents that were processed by DB2 Text Search. |
No action required. |
CIE0006I |
DB2 Text Search Index update statistics: Number of documents processed in this commit cycle: number. Number of documents inserted: number. Number of documents updated: number. Number of documents deleted: number. Number of empty documents skipped successfully: number. Number of documents not indexed because of internal document errors: number. Number of documents processed in total: number. |
One commit cycle is complete. The statistics indicate the number of documents processed in this commit cycle. |
No action required. |
CIE0007I |
DB2 Text Search Index update statistics: Number of documents processed in total is total-number-of-docs. Number of documents inserted is number-of-inserted-docs. Number of documents updated is number-of-updated-docs. Number of documents deleted is number-of-deleted-docs. Number empty documents skipped successfully is number-of-empty-docs. Number of documents resubmitted for indexing due to internal document errors is number-of-docs-resubmitted. Updated statistics for resubmitted documents: Number of documents inserted is number-of-resubmitted-docs-inserted. Number of documents updated is number-of-resubmitted-docs-updated. Number of documents not indexed because of document errors is number-of-resubmitted-docs-not-indexed. |
Update processing is complete. The statistics indicate the number of documents that were processed by DB2 Text Search. |
No action required. |
CIE0008I |
Index reorganization started. |
DB2 Text Search index reorganization has started. The phase of reading and parsing documents has ended and a Text Search index reorganization is necessary. |
No response is required. |
CIE0009I |
Index reorganization ended. |
The DB2 Text Search index reorganization has ended. |
No response is required. |
CIE0010I |
Text Search Index update statistics: Number of documents resubmitted for indexing due to internal document errors is number-of-docs-resubmitted. Updated statistics for resubmitted documents: Number of documents inserted is number-of-resubmitted-docs-inserted. Number of documents updated is number-of-resubmitted-docs-updated. Number of documents not indexed because of document errors is number-of-resubmitted-docs-not-indexed. |
Update processing is complete for the resubmitted documents. The statistics indicate the number of documents that were processed by DB2 Text Search. |
No action required. |
CIE0011I |
Index build started. |
The DB2 Text Search index update build has started. |
No response is required. |
CIE0012I |
Index build ended. |
The DB2 Text Search index build operation has ended. |
No response is required. |
CIE0013I |
No dependent text-maintained table was found in pending mode. |
The RESET PENDING command executes a SET INTEGRITY statement for any dependent tables that manage full-text search. No such table was found. |
No action required. |
CIE0016I |
The text search server for partition partition-number on host host-name and port port-number is in started state. |
You can determine the status of the text search server by using the db2ts START FOR TEXT command with the STATUS option. This message is returned when a connection to the text search server can be established successfully. You can perform text search queries and text index administration operations in the database. |
No action is required. |
CIE0017I |
The text search server for partition partition-number on host host-name and port port-number is in stopped state. |
You can determine the status of the text search server by using the db2ts START FOR TEXT command with the STATUS option. This message is returned when a connection to the text search server cannot be established successfully. You cannot perform text search queries or text index administration operations in the database. |
No action required. |
CIE0018I |
Search services are not active. |
DB2 Text Search services were found to be inactive when the db2ts START FOR TEXT command verified the status of the services. |
No action required. |
CIE0019I |
Search services are active. |
DB2 Text Search services were found to be active when the db2ts START FOR TEXT command verified the status of the services. |
No action required. |
CIE0020I |
DB2 Text Search index update statistics during a time-in-minutes minute interval: Total number of documents processed is total-number-of-docs. The percentage completed is percentage-processed%. |
The statistics indicate the number of documents that were processed in this time interval. |
No action required. |
CIE0021I |
DB2 Text Search services on host host-name and port port-number are running successfully. |
A stand-alone text search server has been detected. For a stand-alone text search server setup, the initialization of DB2 Text Search server is done on a separate host or environment. In this case, the db2ts START FOR TEXT command does not attempt to start a server but instead checks the status of the stand-alone text search server to report success. |
No user response is required. |
CIE0090W |
A directory named directory-name already exists. richtextTool will create a symbolic link named link-name to that directory in order to reuse existing Outside In Technology library files. |
richtextTool will attempt to create a directory with the specified name. If that directory already exists, richtextTool will then create a symbolic link to that directory instead so that it can reuse existing Outside In Technology library files. |
No response is required. |
CIE0091I |
The rich text feature has been successfully configured for use on DB2 Text Search Instance named instance-name. |
richtextTool has been run and has successfully enabled the rich text feature on the named DB2 Text Search instance. |
No response required. |
CIE0092I |
DB2 Text Search instance server instance-server has been set to the default. Rich text is not supported. |
richtextTool has been run and has successfully disabled rich text support on the named DB2 Text Search instance. DB2 Text Search is now running in default mode for the instance. |
No response is required. |
CIE0093I |
Rich text support configuration has started for DB2 Text Search instance named instance-name. |
richtextTool has been called. Configuration for rich text support has started on the named DB2 Text Search instance. |
No response is required. |
CIE0094I |
Default support configuration, no rich text, has started for DB2 Text Search instance instance-name. |
richtextTool has been called. Configuration for default support, no rich text, has started on the named DB2 Text Search instance. |
No response is required. |
CIE0095I |
The Outside In Technology product library files have been setup for DB2 Text Search. |
The installation of the Outside In Technology product library files needs to be done prior to running richtextTool. This only needs to be done once for each DB2 installation. |
For each instance that requires rich text support, login as the instance owner and run the 'richtextTool enable' command to enable rich text support for that instance. |
CIE0201E |
Text search index schema-name.index-name already exists. |
The text search index that you specified already exists in this database. |
Check the name specified and the database you are using. Use the SYSIBMTS.TSINDEXES view to see the existing text search indexes. |
CIE0202W |
Instance services already active. |
A db2ts start command was issued but the instance services are already running. |
No further action required. |
CIE0203W |
Some instance services already active. |
The services are already active, so you do not need to start them. |
No response is required. |
CIE0204E |
Instance services already started. |
An attempt was made to start the text search instance services, but the text search instance services are already running. |
If you are simply trying to start the text search instance services, no further action is necessary. If there were errors using DB2 Text Search that indicated that the text search services were not running, then attempt to stop and restart using the 'db2ts start for text' command. Check the current system status and configuration. If you continue to get errors while starting the text search services, the following steps might be necessary:
|
CIE0205E |
Instance services already stopped. |
An attempt was made to stop the text search instance services, but they are not running. |
If you are simply trying to stop the text search instance services, no further action is necessary. If there were errors using DB2 Text Search that indicated that the text search services should be stopped and restarted, the following steps might be necessary:
|
CIE0206E |
Environment variable variable-name not set. |
A required environment variable is not set. |
Check your environment, specify the required variable, and reissue the command. |
CIE0207E |
No help information available. |
No help information is available for the specified message identifier or command. |
Check that the message identifier was specified correctly. If the identifier was correct then there is no help information available using the 'db2ts help' or 'db2ts ?' commands. The DB2 Text Search documentation can be used for further help. |
CIE0208E |
DB2 Text Search Index update completed with number document errors. Event view: schema-name.event-name. |
Document specific errors occurred in a DB2 Text Search Index update operation. Only documents without specific errors were indexed successfully. All document errors are written to the event table. |
Check the event view for more information about the document errors. Correct the errors and update the affected documents. Retry the DB2 Text Search Index update operation. Clean up the event log after the problems have been fixed. In some cases, errors may be written to the db2diag.log. |
CIE0209I |
A DB2 Text Search index with identifier text-search-id does not exist. |
The CLEANUP FOR TEXT operation has detected and removed inconsistent DB2 Text Search Index information. The CREATE INDEX ... FOR TEXT command adds DB2 Text Search Index information to the database catalog and creates a text index properties file in the collection directory. DB2 Text Search Index information is removed from both the database catalog and the collection directory with the DROP INDEX ... FOR TEXT or DISABLE DATABASE FOR TEXT command. In some scenarios, like dropping and re-creating a database, without first dropping the text indexes, the catalog information is lost while the information in the collection directory persists. The CLEANUP command removes inconsistent DB2 Text Search Index information after such scenarios have occurred. |
No response is required. This message is for informational purposes. |
CIE0210E |
DB2 Text Search index cleanup completed with errors. |
Errors occurred in a DB2 Text Search index cleanup operation. Only indexes without specific errors were cleaned up successfully. All cleanup errors are written to the db2diag.log file. |
Check the db2diag.log for more information about the cleanup errors. Correct the errors and retry the DB2 Text Search cleanup operation. |
CIE0211W |
The CREATE INDEX FOR TEXT command with BACKUP option is not supported for DB2 Text Search indexes on tables in a partitioned database setup. |
The index without backup options was not created successfully. |
Errors generated while creating the index have been written to the db2diag.log file. Correct the errors and retry the CREATE INDEX FOR TEXT operation. |
CIE0212W |
Incomplete enablement of the Text Search server. Reason code: reason-code. |
The database is enabled for text search but some additional configuration steps need to be completed. The reason code indicates which configuration step needs to be completed:
|
Respond to this error according to the reason code:
|
CIE0302E |
Failed to set integrity for dependent tables. |
The RESET PENDING command executes a SET INTEGRITY statement for dependent tables used to manage full-text search. The command failed to complete successfully. |
Run the SET INTEGRITY command with the IMMEDIATE CHECKED option enabled for any the base table's dependent tables that are still in pending mode. |
CIE0304E |
System function failed. Errno: error-number. |
A system error occurred that does not allow further processing. |
Additional information can be found using the ERRNO information in the error message. On many operating systems, descriptions of ERRNO can be found in the C header file named errno.h. |
CIE0305E |
Feature not supported. |
This functionality is not supported by DB2 Text Search. |
Examine the operation to determine the unsupported operation. Check if the operation might have violated any documented restrictions with text search indexes. |
CIE0306E |
Table schema-name.table-name has no primary key. |
An attempt was made to create an index on a table that does not have a primary key. |
Call "db2 alter table" to ensure the existence of a primary key. Then try to create the index again. |
CIE0307E |
Directory directory-name does not exist. |
The directory which was specified does not exist on the file system. |
Create the directory. Ensure that the instance owner is able access it. Then attempt the operation again. |
CIE0308E |
The size of an object exceeds the maximum allowed size. Two-part object name: schema-name.object-name. Maximum allowed size: maximum-size. Size of object: key-column-size. |
The internal representation of the key columns exceeds the maximum size. |
Change the layout of the table before creating the index again. Try using smaller key columns, which will also improve performance. |
CIE0309E |
Object schema-name.object-name number key columns, exceeds max of maximum-number. |
The number of key columns you specified is greater than the maximum number of key columns supported. |
Change the layout of the table before creating the index again. |
CIE0310E |
File file-name is not readable. |
The file specified cannot be read. |
Check the access rights for the file. Take into account that the stored procedure runs as a fenced user ID, which may also require rights to work on this file. |
CIE0311E |
File file-name cannot be opened. |
The file specified cannot be opened. |
Check that the file exists. Also check the access rights for the file. Take into account that the administration procedure runs as a fenced user ID, which may also require rights to work on this file. |
CIE0312E |
The unsupported type type was returned by schema-name.object-name. |
In a CREATE INDEX command, a column type transformation was specified that returns an unsupported datatype. |
Choose a different column type transformation function. |
CIE0313E |
Column type type not supported. |
You have specified a column type that is not in the list of supported types. |
Ensure that the CREATE INDEX command uses only supported column types (for text column, attribute columns, user exit columns, and primary key columns). Make the appropriate changes to the command and try again. If the error persists, start a trace and also check db2diag.log. Report the error to your IBM service representative. |
CIE0314E |
UDF schema-name.function-name does not exist. |
The specified user-defined function does not exist in this database. |
Check the name specified for this user-defined function, or register the user-defined function in the database you are using. |
CIE0315E |
A NULL value has been passed to an internal user-defined function. |
DB2 has passed a NULL value to an internal user-defined function. |
First make sure the specified base table has a primary key. Change your select statement to avoid this problem. Switch on the trace function and pass the returned information to your IBM service representative. |
CIE0316E |
Text search index schema-name.index-name does not exist. |
The specified text search index does not exist in this database. |
Check the name specified and the database you are using. Use the SYSIBMTS.TSINDEXES view to see the existing text search indexes. |
CIE0317E |
The codepage conversion from source-codepage to target-codepage failed. |
The codepage conversion could not be performed because no adequate converter exists. |
Report the error to your IBM service representative. |
CIE0318E |
Object schema-name.object-name does not exist. |
The specified table does not exist in this database. |
Ensure the schema and table name exists in the database. |
CIE0319E |
Column column-name does not exist in schema-name.table-name. |
The specified column does not exist. |
Check the column name that you specified. Check the table, view, or database you are using. |
CIE0320E |
Table space table-space-name does not exist. |
The specified table space does not exist in this database. |
Ensure the table space exists within the database. |
CIE0321E |
Table space table-space-name is not of type regular or large. |
The specified table space is not of type regular or large. An operation attempting to create a table in a system temporary or user temporary table space will fail. |
Reissue this command, specifying a table space that is regular or large type. |
CIE0322W |
Specified or default database already enabled for text. |
The database you specified is already enabled for DB2 Text Search. |
Check the database name that you specified. Also check to see if the DB2DBDFT variable (which implies an implicit connection) has been set. |
CIE0323E |
Specified or default database not enabled for text. |
The database you specified is not enabled for DB2 Text Search. |
Check the database name you specified and the setting of the DB2DBDFT variable. If the database name is correct, use the command ENABLE DATABASE FOR TEXT. |
CIE0324E |
The command failed because the user does not have CONTROL privilege. Table name: schema-name.object-name. User: user-id. |
You do not have the authority to use this command because it requires CONTROL authority. Only the owner of this table can use this command or grant access to use this command. |
Have the owner of the table provide you with the required authorization. |
CIE0325E |
The operation failed because the user does not have DBADM authority. |
You do not have the required authority to use this command because it requires database administration (DBADM) authority. Only an administrator of this database can use this command. |
Obtain the required authorization from the security administrator. |
CIE0326E |
Disabling the database failed because text search indexes are active in the database. |
A database cannot be disabled until all text search indexes are dropped. At least one text search index exists in the specified or default database. |
See the SYSIBMTS.TSINDEXES view for the existing text search indexes. Drop the existing indexes using the DROP INDEX command, or specify the FORCE option with the DISABLE DATABASE command. |
CIE0327E |
The operation failed because the specified code page is not supported. Specified code page: code-page. |
The code page that you specified is not supported. |
Specify a valid code page. |
CIE0328E |
The operation failed because the specified language is not supported. Specified language: language. |
The specified language is not supported. |
Specify a valid language. |
CIE0329E |
The operation failed because the specified format is not supported. Specified format: format. |
The specified format is not supported. |
Specify a valid format. |
CIE0330E |
The invalid value value was specified for parameter parameter-name. |
The specified value for the parameter is invalid. |
Specify a valid value. |
CIE0331E |
The operation failed because the format of the specified update frequency is invalid. Too many terms beginning with character were specified in the value for the update frequency. |
The syntax for the update frequency is not correct because too many terms beginning with character are specified for the index update frequency. |
Ensure that the DAY, HOUR, and MINUTE parameters are only specified once. |
CIE0332E |
Incorrect command syntax. |
Unexpected end of command. |
Check the command syntax. Verify that you specified the required parameters. |
CIE0333E |
The command failed because of an unexpected token. Unexpected token: token-name. |
The command syntax is incorrect. |
Check the command syntax and issue your command again. |
CIE0334E |
The command failed because the following token is too long: token. |
The token is too long. |
Check the command syntax and verify that the token is reduced to the maximum size allowed. |
CIE0335E |
The command failed because the following token occurs twice in the update frequency: token. |
You specified an incorrect syntax for the update frequency. |
Ensure that the DAY, HOUR, and MINUTE parameters are only specified once. |
CIE0336E |
Invalid range range for parameter-name. Valid range: start - finish. |
The value should be in the allowed range. |
Update your command. Change the value to match those in the allowed range. |
CIE0337E |
Library library cannot be loaded. |
A library could not be found. |
Check that the library is located in the library path and available. Start and stop DB2 to ensure that the current settings are used. |
CIE0338E |
Cannot load function function-name from library library-name. |
A library entry point cannot be loaded. |
The library access appears to be invalid. Check that the library is only specified once. |
CIE0339E |
Cannot find executable program program-name. |
The program file cannot be located or accessed. |
Check if the program file is located in the bin or adm directory of the DB2 server. The installation is corrupt if the file cannot be found. |
CIE0340E |
Cannot start text search server. |
The text search server cannot be started due to any or all of the below reasons such as 1. A port mismatch between the TS configuration.xml and SYSIBMTS.TSSERVERS table or the currently configured port number in the configuration.xml file is unavailable. 2. The rich text filter feature is not supported for the current operating system. |
1. If the error is due to the port mismatch between configuration.xml file and SYSIBMTS.TSSERVERS table, then change the port in configuration.xml file, restart the text search server and crosscheck the port value in the SYSIBMTS.TSSERVERS table with the port value in the configuration.xml file. For further information, refer the documentation on Configuring Db2 Text Search. 2. If you are attempting to install rich text support, check for the operating system level. Refer to release notes for platform/operating system support and skip the rich text filter feature for them as it is not compatible. If the rich text filter is supported for the current operating system level then check the prerequisites of the installation for enabling rich text support. For further information, refer the documentation on Enabling Db2 Text Search for rich text document support. |
CIE0341E |
Update index errors. Event view: schema-name.event-name. |
Errors occurred in an update index operation. Any document errors are written to the event table. |
Check the event view for more information about the document errors. Clean up the event log after the problems have been fixed. In some cases, errors might be logged to db2diag.log. |
CIE0342E |
Text index creation failed because data type data-type of column column-name is not supported. |
To use text search functionality with data in a given column of a table, you must create a text index on that column. Generally, you can create a text index on a column directly using the CREATE INDEX FOR TEXT command. For some data types, such as user-defined types, it is not supported to create a text index directly against a column of one of those data types. You can still include data in columns of those unsupported data types in text searches, but some additional steps are required to create the text index. This message is returned when an attempt is made to create a text index directly against one of these unsupported data types. |
Respond to this error in one of the following ways:
|
CIE0343E |
The path path not an absolute path. |
An absolute path should be specified. |
Check the path and use an absolute path in the command. |
CIE0344E |
No corresponding text search index found. |
An attempt was made to search on a column without a text search index. |
Check the column you are searching on, or create a text search index on the column. |
CIE0345N |
No text search index on column column-name, table table-name. |
A text search query on a table column failed because it has no valid and active text search index. |
Check the column you are searching on, or create a text search index on the column. If the table column has an invalid text search index, drop the text index and create a new one. For example, a text search index gets invalidated if the underlying base table is dropped and recreated. |
CIE0346E |
The ALTER INDEX command failed because no command options were specified. |
The ALTER INDEX command changes the characteristics of an index, such as the update frequency option. None of the characteristics that can be changed was specified. |
Specify at least one command option. Refer to the command syntax for all possible options. |
CIE0347E |
Conflict with existing text search index on same column. |
A text search index defined on the same column already exists. Creating more than one text search index on a column is not supported. |
If it is no longer needed, drop the existing text search index on the specified column using the DROP INDEX command. Then try reissuing this command. |
CIE0348E |
Attribute name missing. |
Whenever a column expression is used in the attribute expression, an attribute name must be supplied. For example:
|
Add "AS <attribute-name<" to the attribute expression. |
CIE0349E |
The CREATE INDEX command failed because a user exit column does not exist. |
One or more of the user exit columns specified does not exist in the table the index is created on. |
Correct the CREATE INDEX command. |
CIE0350E |
Invalid ATTRIBUTE expressions. |
The column list in the attribute expression is not valid. |
Correct the attribute column list in the CREATE INDEX command. Make sure the columns exist in the specified table. If a function is applied on a column, verify that it is used correctly. |
CIE0351E |
Attribute attribute of column column-name is not supported. |
For attribute columns, the only supported data type is DOUBLE. |
Make sure the attribute columns of the table for the text column to be indexed are of type DOUBLE. It is possible to use cast operators in attribute column expressions. Refer to the SQL Reference for which data types can be cast to double. |
CIE0352E |
The invalid value value was specified for index configuration parameter parameter-name. A valid value is value. |
The specified value for the configuration parameter is incorrect. For valid values of the parameters, refer to the command syntax. |
Correct the index configuration parameter value in the CREATE INDEX command. |
CIE0353E |
The parameter parameter-name not a valid index configuration parameter. |
The index configuration option is not known. |
Check the CREATE INDEX command syntax. An example of a valid index configuration option is: COMMENT. For example:
|
CIE0354E |
Function function-name failed. Error error. |
A Windows function failed with the specified error code which does not allow further processing. |
Use the specified Windows system error code to get detailed error information. |
CIE0355E |
Incorrectly specified update frequency frequency. |
The syntax for the update frequency statement is not correct. |
Correct the update frequency statement according to the syntax specification. |
CIE0356E |
Table space table-space-name has more than one partition, which is not allowed for this text search index. |
For an index on a nickname, the table space of the administration tables must consist of only one partition. |
Specify a table space in a single-partition database partition group for the administration tables. |
CIE0357E |
Conflicting administration operation in progress. |
Another administration command is still running or terminated abnormally without releasing the command lock. |
If there is no other administration command running (for the text search index), clear the lock manually using CLEAR COMMAND LOCKS. Be aware that someone else may be running the administration command holding the lock. Retry this command later. |
CIE0358E |
Conflicting administration operation without FORCE option. |
Another administration command is still running or terminated abnormally without releasing the command lock. |
If there is no other administration command running, clear the lock manually using CLEAR COMMAND LOCKS. Be aware that someone else may be running the administration command holding the lock. Retry this command later. For a DISABLE DATABASE command, you may specify the FORCE option which stops all other commands on that database. |
CIE0359E |
Empty command text with procedure schema-name.procedure-name. |
The indicated administration procedure was called with an invalid command text parameter. |
Correct the command text parameter value of the administration procedure. For valid commands, refer to the DB2 Text Search documentation. |
CIE0360E |
Executable program progam-name terminated abnormally. |
When executing a DB2 Text Search command, the executable was called, but terminated abnormally. |
Verify that the executable was not terminated explicitly by user interaction (a signal). If it was not, start a trace, rerun the command and report the error to your IBM service representative. |
CIE0361E |
Parameter parameter-name missing. |
Internal error - when executing a DB2 Text Search command, an administration executable program was called with a missing parameter. |
Try to change DB2 Text Search command parameters to avoid the problem. If the error persists, switch on the trace function and report the error to your IBM service representative. |
CIE0362E |
Query failed. Use simpler attribute expressions. |
DB2 Text Search creates a query based on the expressions in your command to select data for indexing from the database. The query failed because it was too complex. |
Reduce the complexity of attribute expressions. |
CIE0363E |
Cannot specify UPDATE MINIMUM with schema-name.index-name text search index. |
The text search index was created with the RECREATE INDEX ON UPDATE option. In this context, the UPDATE MINIMUM may not be specified. Update minimum is only effective if the index is updated incrementally. |
If you want to recreate the index each time an update is performed, remove the UPDATE MINIMUM setting. If you want to use UPDATE MINIMUM, do not specify RECREATE INDEX ON UPDATE. |
CIE0364E |
Inconsistent objects in specified or default database. |
At least one DB2 Text Search object is missing or corrupted. This can occur when DB2 Text Search database objects under schema SYSIBMTS are changed manually. |
Issue a DISABLE DATABASE command using the FORCE option. You can then enable the database for text again by using the ENABLE DATABASE command. In this case, all text search indexes are lost. |
CIE0365E |
The user exit function (calltype=call-type) returned with code=error-code, reasoncode=reason-code. |
The user exit function indicated a problem. Depending on the returned code, the index update was either terminated (in case of SQL_ERROR) or continued. |
Check the document that was passed to the user exit function and the user exit function itself. |
CIE0366E |
Cannot load user exit library library-name. Reasoncode=reason-code. |
The user exit library could not be loaded. |
Make sure that the library can be dynamically loaded. |
CIE0367E |
User exit function function-name not found in library library-name. Reasoncode=reason-code. |
The user exit library could be loaded, but it does not contain the specified function. |
Make sure that the user exit library contains the specified function. For C++ implementations, check if the function is defined as extern "C". |
CIE0368E |
User exit function returned invalid data for name. Invalid value=value, context information:context-info-1, context-info-2. |
The user exit function was called for a document and returned invalid data in the output structure. |
Ensure that valid data is return, if the return code is SQL_SUCCESS. Check the user exit function implementation. |
CIE0369E |
User exit column column-name not in the table the index is created on. |
The user exit columns specified in the CREATE INDEX command must be columns of the table the index is created on. Expressions are not allowed. |
Rerun the corrected CREATE INDEX command. |
CIE0370E |
User exit function (calltype=call-type) threw an exception. |
The user exit function has thrown a C++ exception. The index update was stopped. |
Correct the implementation of the user exit function. |
CIE0371E |
No row found in name."IBMSNAP_REGISTER" for source table schema-name.table-name and capture change table schema-name.table-name. |
No valid entry was found in the IBMSNAP_REGISTER table for the replication capture table characteristics specified in the CREATE INDEX command. A valid entry must contain the specified source table for the index in columns SOURCE_OWNER and SOURCE_NAME, with SOURCE_VIEW_QUAL=0 and the specified replication capture table in columns PHYS_CHANGE_OWNER and PHYS_CHANGE_TABLE. Possible causes: The specified source table was not registered as a replication source for the replication capture table. |
Register the source table correctly for DB2 Replication, or specify a correct replication capture table for the source table. |
CIE0372E |
Invalid value value for replication-setting in name."IBMSNAP_REGISTER" for source table schema-name.table-name and capture change table schema-name.table-name. |
A replication setting found in the IBMSNAP_REGISTER table is not allowed. Possible causes:
|
When registering the source table for DB2 Replication, ensure that update operations are transformed into pairs of delete and insert operations. In addition, ensure that no condensed replication capture tables are used. |
CIE0373E |
Source table schema-name.table-name and capture change table schema-name.table-name are on different servers (source-table-server and capture-change-table-server). |
The specified source table and replication capture table must reside on the same server. |
This operation is not currently supported. |
CIE0374E |
Specified format not allowed for an XML column. |
For columns of type XML, only the 'XML' format is allowed. |
Specify format 'XML' or none. |
CIE0375E |
Alias schema-name.alias-name not allowed in replication clause. |
You are not allowed to specify an alias for a nickname in a replication clause. |
Specify the nickname instead of the alias, or create a new nickname for the remote table. |
CIE0376E |
Table in replication clause cannot be a view. |
A view cannot be specified in the replication clause. |
This operation is not currently supported. |
CIE0377E |
Only instance owner user-id can use that command. |
You do not have the required authority to use this command. On UNIX systems: The DB2 instance owner is the authorization name specified in the db2icrt command. On Windows: It is the authorization name running the DB2 instance service. It need not be the instance name. |
On UNIX, verify that the DB2 instance environment variable DB2INSTANCE is set correctly, or log in as the instance owner. On Windows, check that the DB2 instance service, DB2 - <install-copy> - <instance-name>, associated with the current instance is using your account and password. |
CIE0378E |
Option option not allowed for current connection. |
The usage of this option is allowed only when connecting to a DB2 z/OS system. |
Check that the connection options relate to a DB2 z/OS system, or reissue the current command without specifying the option. |
CIE0379E |
The ALTER INDEX SET ACTIVE operation failed because an active index already exists on the specified column. |
You can activate a text search index using the db2ts ALTER INDEX command or the SYSPROC.SYSTS_ALTER procedure with the SET ACTIVE clause. Multiple text search indexes can exist at the same time for a given column. However, only one text search index can be active on a column at any time. |
|
CIE0380E |
Invalid codepage codepage for non-binary text column. |
For text column data types that are not binary (that is, not BLOB and not strings-types FOR BIT DATA), DB2 always stores the data in the database codepage. |
Omit the codepage clause. |
CIE0381E |
Minimum update frequency minimum-frequency is less than allowed-frequency minute limit. |
The update frequency defines a minimum time interval between two automatic index updates that is lower than the allowed value. |
Change the update frequency specification to keep to the indicated limit. Note that the time interval between the latest entry on day 6 and the earliest entry on day 0 must also be considered. |
CIE0382E |
NumberOfMatches not supported. |
This function is not supported by DB2 Text Search. |
Use either DB2 Net Search Extender or change your SQL query so that it can run without the NumberOfMatches function. |
CIE0383E |
Operation took longer than limit of limit seconds. |
An administration operation did not succeed within the time limit. Possible reasons are workload problems while using text search instance services. |
Ensure that text search instance services are up and running. Check db2diag.log for further information. |
CIE0384E |
Text search index not created on schema-name.table-name because the table is not a base table. |
Text search indexes can be created only on a base table. Creating a text search index on non-base tables such as views or MQTs is not supported. |
Check whether the column belongs to a base table or not. Create the text search index on a base table column. |
CIE0385E |
The text search index could not be created on the specified table because the table is a partitioned table. Table: schema-name.table-name. |
Text search indexes cannot be created on a partitioned table. |
Check if the table is partitioned. Create the text search index only on a table that is not partitioned. |
CIE0386E |
Database already enabled for DB2 Net Search Extender. |
The specified or default database is already enabled for a different type of text search index. A database may be associated with only one text search component. |
If you do not want to use DB2 Net Search Extender, disable the database using the DB2TEXT DISABLE DATABASE command. After disabling the database for DB2 Net Search Extender, reissue the DB2 Text Search command. |
CIE0387E |
Cannot use NULL values for required parameters. |
A DB2 Text Search administration procedure argument that is not optional received NULL as the specified value. NULLS can only be used for optional arguments. |
Correct the arguments specified for the procedure call. |
CIE0388E |
Undefined client error. |
A processing error occurred when calling an internal function. No details are available for this error. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0389E |
Internal function processing error. |
The method could not complete because it is not implemented or because the parameters specified make it impossible to execute. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0390E |
Invalid object referenced. |
A processing error occurred when calling an internal function. An invalid or uninitialized object was used or referenced. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0391E |
Code page source-codepage to target-codepage convert error. |
A processing error occurred when calling an internal function. A passed data could not be converted from the source code page to the target codepage. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0392E |
The following string needs data type data-type. String: string. |
A processing error occurred when calling an internal function. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0393E |
Required property property absent. |
A processing error occurred when calling an internal function. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0394E |
Property=property value=value failed as type=type. |
A processing error occurred when calling an internal function. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0395E |
No db2ts start command was issued. |
A command was called which requires text search instance services. |
Start the text search instance services with the db2ts start command. |
CIE0396E |
DB2 Text Search Instance services not configured to support rich text. |
A command which requires rich text support for DB2 Text Search was called. Rich text has not yet been configured for the DB2 Text Search Instance. |
Use richtextTool to enable and configure DB2 Text Search for rich text support. |
CIE0397E |
Table column schema-name.table-name has no valid text search index. |
A text search query on a table column failed because it has no valid and active text search index. |
Ensure that the table column has a valid and active text search index before performing a text search query. If the table column has an invalid text search index, drop the text index and create a new one. For example, a text search index gets invalidated if the underlying base table is dropped and recreated. |
CIE0398N |
Text search index schema-name.index-name is not valid and cannot be used. |
Text index is invalid and cannot be updated or used. |
Drop and recreate the invalid text search index. |
CIE0399E |
Failed to set integrity for the following table: schema-name.table-name. |
The RESET PENDING command executes a SET INTEGRITY statement for dependent tables that are used to manage full text search. The command failed to complete successfully. |
Run the SET INTEGRITY command for the failed table, with the IMMEDIATE CHECKED option enabled. |
CIE0401E |
A search system operation failed. Message id: message-id. Exception es::exception-part1: exception-part2 was thrown by file file-name line line-number. | ||
CIE0402E |
Failed to set integrity for dependent tables. |
The RESET PENDING command executes a set integrity statement for dependent tables used to manage full-text search. The command failed to complete successfully. |
Issue the SET INTEGRITY command with the IMMEDIATE CHECKED enabled for all of the base table's dependent tables that are still in pending mode. |
CIE0403E |
The data type of column column-name is not supported for text search indexes in this database. |
To use text search functionality with data in a given column of a table, you must create a text index on that column. Generally, you can create a text index on a column using the CREATE INDEX FOR TEXT command. The behavior of the text search functionality is affected by the value of the DB2_COMPATIBILITY_VECTOR registry variable. Specifically, creating a text index on a column of type DATE or TIMESTAMP(0) is not supported when the DB2_COMPATIBILITY_VECTOR registry variable is set to 40, where it enables the use of the DATE data type as TIMESTAMP(0) as a combined date and time value. This message is returned when an attempt is made to create a text index for a column of type DATE or TIMESTAMP(0) while the DB2_COMPATIBILITY_VECTOR registry variable is set to 40. |
Respond to this error in one of the following ways:
|
CIE0404E |
Format format-type is not allowed for column type column-type. |
The specified index format type should be supported by the indicated column type. For example, INSO format is only supported by BLOB column and XML format is only supported by XML column. |
Check whether the specified index format type is supported by the indicated column type. |
CIE0405E |
CJKSegmentation for language language-name is not supported. |
CJKSEGMENTATION is supported only for Chinese, Japanese and Korean character sets. |
Remove CJKSEGMENTATION as part of the CREATE INDEX command |
CIE0406E |
Token CJKSEGMENTATION occurs twice in index configuration. |
You specified an incorrect syntax for the CJKSEGMENTATION. |
Ensure that the CJKSEGMENTATION parameter is only specified once. |
CIE0408E |
User user-name does not have DATAACCESS authority to perform the DB2 Text Search upgrade. |
The text search user needs to have DATAACCESS authority to perform the upgrade. |
Grant DATAACCESS privilege to the user. |
CIE0409E |
The DB2 Text Search catalog has not been upgraded to the current version. |
Before upgrading DB2 Text Search indexes, all catalog tables or views associated with text search should be upgraded to the latest version. |
|
CIE0410E |
Incorrect usage. Parameters are missing or incorrect parameters are given. | ||
CIE0411C |
Cannot find the db2level command to detect if the instance is 32-bit or 64-bit. |
DB2 Text Search was not able to locate the db2level command. DB2 Text Search uses this command to determine if the DB2 instance is 32-bit or 64-bit. |
The db2level command binary is missing from the DB2 installation or cannot be found via search path for executable files. Resolve any DB2 installation or search path for executable files issues before retrying this operation. |
CIE0412E |
DB2INSTANCE environment variable is not set. |
In order to configure rich text support, DB2 Text Search requires that the DB2INSTANCE environment variable is set. |
Set the DB2INSTANCE variable and retry richtextTool command. |
CIE0413E |
The DB2 Text Search directory named directory-name does not exist. |
DB2 Text Search has not been configured correctly. |
Ensure that DB2 Text Search has been configured correctly. |
CIE0414E |
The user named user-name does not have write permission to the directory named directory-name. |
richtextTool cannot create a directory to store unzipped files. |
Refer to documentation on user permissions needed to execute this tool. |
CIE0415C |
DB2 Text Search cannot locate the DB2 installation. |
richtextTool cannot locate the DB2 installation. |
Resolve DB2 installation issues before retrying this operation. |
CIE0416E |
Rich text support cannot be configured because DB2 Text Search is running. |
The rich text support cannot update configuration files while the DB2 Text Search server is running. |
Stop the DB2 Text Search server by issuing the command, db2ts stop for text. Then retry configuring rich text support. |
CIE0417E |
Cannot access directory named directory-name to locate Outside In Technology product zip files. |
richtextTool cannot access the directory given by the user. |
Check that the directory exists and you have read permission to that directory. |
CIE0418E |
richtextTool failed to extract files from the zipfile named compressed-file-name. |
richtextTool cannot extract files to complete configuring rich text support. |
Examine and correct the error messages returned from the file unzipping operation. Then retry running richtextTool. |
CIE0419E |
File extraction failed. Cannot locate the file named file-name in the Outside In Technology product directory. |
richtextTool cannot find a required file in the Outside In Technology product directory. |
Review the output of the file extraction operation to correct any issues that might have caused unzip failure. If rich text has not been configured for this copy of DB2, remove the directory named stellent under the directory named db2tss and retry running richtextTool. |
CIE0420E |
Files are missing from a directory named directory-name. |
Files are missing from the named directory. A failure may have occurred during the run of the configuration tool. System configuration may be in an inconsistent state. |
Manually remove the named directory. Then rerun richtextTool to configure rich text support. |
CIE0421E |
Cannot locate version version Outside In Technology product Html Export zip file named compressed-file-name. |
Cannot locate the proper version of the Outside In Technology product zip file. |
Refer to the error message to see which file is missing. Obtain the missing file then retry running richtextTool. |
CIE0422E |
Cannot locate version version Outside In Technology product Search Export zip file compressed-file-name. |
Cannot locate the proper version of the Outside In Technology product zip file. |
Refer to the error message to see which file is missing. Obtain the missing file then retry running richtextTool. |
CIE0423E |
richtextTool cannot access the file named file-name. |
richtextTool cannot access the file referenced in the error. |
Ensure the file exists and correct any access permission problems to that file. |
CIE0424E |
The DB2 Text Search configuration directory named directory-name for the DB2 instance named instance-name does not exist. |
DB2 Text Search has not been correctly configured or is damaged. |
Retry configuring rich text support by running richtextTool. |
CIE0425E |
DB2 Text Search cannot set the required access permission for files located in the directory named directory-name. |
Correct file permissions are needed so the rich text support program can launch properly. richtextTool cannot set the correct read and execute permissions to extracted files on its own. |
Examine the error messages returned from the chmod command and correct the problems. If rich text has not been configured before for this copy of DB2, remove the directory named stellent under the directory named db2tss before retrying richtextTool. |
CIE0426E |
DB2 Text Search cannot detect the DB2COPY name for the instance that is being configured. |
richtextTool cannot derive the DB2COPY name from DB2 instance name. DB2 may not have been setup correctly. |
Correct any DB2 setup problems before configuring rich text support. |
CIE0427E |
richtextTool cannot restore a configuration file named file-name from an existing copy. |
richtextTool tried to restore an existing copy of a DB2 Text Search configuration file and hit an error. |
System configuration maybe in an inconsistent state. Check if system is running out of disk space. Correct the problem, then rerun richtextTool. |
CIE0428E |
The DB2 command line environment is not set. |
richtextTool requires the DB2 command line environment to detect the DB2 environment and to execute DB2 utilities when configuring rich text support. richtextTool cannot configure DB2 Text Search rich text support without the DB2 command line environment setup. |
Run richtextTool in a DB2 command window. |
CIE0429E |
The home directory of the DB2 instance named instance-name does not exist. The home directory is named directory-name. |
DB2 instance setup is incorrect. |
Correct any DB2 instance setup issues before running richtextTool. |
CIE0430E |
richtextTool cannot be run because the contents of the file named file-name are incorrect. |
The contents of the referenced file are incorrect. System configuration might be in an inconsistent state. |
Check system resources. Check if the system is running out of disk space. Correct the problem and rerun richtextTool. |
CIE0431E |
A text search index can not be created because the sequence of primary key columns are not the same as base table. |
The sequence of primary key columns should be kept the same as base table, otherwise a text search index can not be created. |
Ensure that the column sequence in a compound primary key matches the column sequence in the base table. |
CIE0432E |
The database directory cannot be found on the local file system. |
The text search administration operation failed to find the local database directory. |
Issue the 'db2 list database directory' command to confirm that the local database directory exists. Then try the operation again. |
CIE0440E |
User user-id does not have the authority to create a text search index on the table schema-name.table-name. |
"CREATE INDEX ... FOR TEXT" requires one of the following:
For more information about DB2 Text Search create index, see the topic called "DB2 Text Search CREATE INDEX command" in the DB2 Information Center. |
Ensure that the user has the required authority to perform the create text index operation. |
CIE0441E |
User user-id does not have authority to enable the database database-name for DB2 Text Search. |
Enabling text search for a database requires DBADM authority. For more information about enabling DB2 Text Search, see the topic called "Enable Database for Text text search command" in the DB2 Information Center. |
Ensure that the user has the required authorization to perform the ENABLE operation. |
CIE0442E |
The instance owner does not have the authority to perform the text index command on database database-name. |
The user attempted to run a text index command without the instance owner holding the appropriate authority. Different DB2 Text Search index commands require varying levels of database authority. For a list of required authorities for DB2 Text Search index commands, see the topic called "DB2 Text Search index command authority requirements" in the DB2 Information Center. |
Ensure that the instance owner has DBADM with DATAACCESS authority in order for the user to perform text index operations. |
CIE0443E |
User user-id does not have authority to update the DB2 Text Search index named index-schema-name.index-name. |
Update text index requires one of the following:
For more information about DB2 Text Search update, see the topic called "DB2 Text Search UPDATE INDEX command" in the DB2 Information Center. |
Ensure that the user has the required authorization to perform the update text index operation. |
CIE0444E |
User user-id does not have DATAACCESS authority to perform the DB2 Text Search index command. |
You need to have DATAACCESS authority to perform the DB2 Text Search index command. Different DB2 Text Search index commands require varying levels of database authority. For a list of required authorities for DB2 Text Search index commands, see the topic called "DB2 Text Search index command authority requirements" in the DB2 Information Center. |
Ensure that the SECADM grants DATAACCESS authority to the user. |
CIE0445N |
The requested operation cannot be executed. Run the REBIND command for packages package-list. |
The list of packages are invalid. You must run the REBIND command. |
Run the REBIND command on the packages before running this text index command. |
CIE0446E |
The document exceeds the maximum size limit of max-size bytes. |
DB2 Text Search can index documents up to the maximum size limit. The current document exceeds this limit and is not indexed. |
|
CIE0447N |
Failed to retrieve the text-maintained dependent tables for schema-name.object-name. |
The command executes a query to retrieve information from the text index administration tables. Querying the text index information failed. |
Ensure that the text index administration tables are accessible. For more information see the db2diag.log. |
CIE0448N |
The backup configuration is inconsistent. |
The backup infrastructure was enabled for this text index, but the backup configuration is unavailable or inconsistent. |
Review and update the backup configuration according to the documentation for Text Search index backup options. |
CIE0449N |
Text search index schema-name.index-name not enabled for Backup. |
Text search indexes can only be backed up when a backup mode is specified. |
To enable backup for a text search index, use the ALTER INDEX FOR TEXT operation to set the backup mode for the text search index to IMMEDIATE or DEFERRED. |
CIE0450N |
The backup configuration for the text search index is invalid. |
The backup configuration refers to backup modes in the Text Search server. The configuration does not match with the supported backup modes. |
Update the backup configuration to match with a supported backup mode for the Text Search server. Review the Text Search server documentation for supported modes. |
CIE0451E |
Lock cannot be cleared for text search index schema-name.index-name. |
The text index is locked for an operation on the database level. |
Repeat the CLEAR COMMANDLOCKS operation without specifying a text search index name. |
CIE0452E |
User user-name does not have the authority to alter text search index schema-name.index-name. |
To alter a text search index, the authorization ID required one of the following:
|
Ensure that the SECADM assigns appropriate privileges. |
CIE0453E |
User user-name does not have the authority to drop the text search index schema-name.index-name. |
To drop a text search index, the authorization ID requires one of the following roles or privilege:
|
Ensure that the SECADM assigns appropriate privileges. |
CIE0454E |
User user-name needs role role-name for this operation. |
Operations on text search indexes require the appropriate SYSTS_ADM, SYSTS_MGR or SYSTS_USR roles. |
Ensure that the SECADM assigns the appropriate role. |
CIE0456E |
Start operation for a stand-alone text search server setup has to be executed separately. |
When using a stand-alone text search server setup, an operation like starting a server has to be executed in the stand-alone text search server environment using the startup script. The db2ts utility from the DB2 instance environment cannot be used to start the stand-alone text search server. You can use the db2ts utility to check the text search server status. Ensure that the text search server for the DB2 instance is registered by issuing SYSTS_CONFIGURE for a text search enabled database. |
Run the following script to successfully start the text search server:
|
CIE0457E |
Expected values for DB2 Text Search defaults are not found. |
Text search defaults are setup in the SYSIBMTS.TSDEFAULTS view. These values are typically added when enabling a database for text search and subsequent configuration steps such as during execution of the SYSTS_CONFIGURE procedure. |
Ensure that database level defaults for text search are setup correctly by successfully issuing the ENABLE operation and the SYSTS_CONFIGURE procedure for a text search enabled database. |
CIE0458E |
The specified administration option option cannot be used in this setup. |
Some options for administrative operations are supported only in certain product environments. |
Ensure that only the supported options for the instance type or database are specified in the command. Check the DB2 instance type and ensure that the used options apply to it. Retry the operation after removing or changing the option so that it applies to your setup. |
CIE0459E |
Data preparation constructor constructor-name is invalid |
There is no constructor configured with this name, or there is no value assigned. |
Ensure that the configuration for data preparation is valid in SYSIBMTS.TSDEFAULTS. Use the DATAPREP: prefix to define the constructor. |
CIE0460E |
Parallel index update errors across multiple database partitions. |
When updating text search indexes in a partitioned database environment, the index update operation runs on each relevant database partition in parallel. Errors occurred on one or more database partitions. |
|
CIE0462I |
The text search catalog has been upgraded to the current version. |
In order to make text search work, the text search index also needs to be updated. |
Update the text search index by calling "SYSPROC.SYSTS_UPGRADE_INDEX". |
CIE0463E |
The DB2 Text Search catalog has not been upgraded to the current version. |
The text search catalog must be upgraded to the current version. |
Update the text search catalog to the current version. |
CIE0701E |
Internal error. Location: location-1, location-2. |
An internal processing error that does not allow further processing occurred. |
Try starting and stopping the text search instance services, as well as DB2. If the error persists, start a trace and also check db2diag.log. |
CIE0702E |
Memory allocation error. |
The system has run out of memory. |
Increase the available memory size for the user or stop other processes that are running in parallel. |
CIE0703E |
Error using shared system resources. |
A request to share or access system resources, such as shared memory or semaphores, cannot be fulfilled. |
Check the current system status and configuration. On UNIX, use the ipcs command to check the resources. Stop all applications, such as DB2 and DB2 Text Search. If further resources are listed, clean them up using ipcrm. |
CIE0705E |
Instance services error. |
An instance services error occurred. |
Check db2diag.log for further information, or clean up your shared resources. Also see CIE00703. |
CIE0706E |
Instance services could not be stopped. |
The db2ts stop command has not stopped the instance services and there are still processes running. |
To recover from this error state, reissue the stop command after allowing any text search administration operations running in the background to complete. In the case of administration commands that have terminated abnormally (or that you want to stop), clear the lock manually using CLEAR COMMAND LOCKS. If there are no signs of other administration operations running, or if the stop command still does not work, try restarting the instance services and then issue a stop command. As a last resort, stop DB2 and all applications, and then clean up system resources. |
CIE0707E |
Contacting instance services timed out. |
A timeout occurred when contacting the text search services. Possible reasons are:
|
|
CIE0708E |
An error occurred while opening the following Windows service: service-name. Error that was returned: error. |
The specified service cannot be found on the Windows system. |
Check if the specified service is installed on the Windows system. Use the specified Windows system error code to get detailed error information. |
CIE0709E |
Cannot find DB2 instance profile path. |
A function to obtain the DB2 instance profile path failed. |
Check the DB2 instance configuration. On Windows, try to create a DB2 instance without specifying the instance profile path information and retry the command. |
CIE0710E |
Administration table space text-index-table-space is not defined in the same database partition group as the table space of schema-name.object-name. Database partition group: database-partition-group. |
The table space of the administration tables must be distributed over different partitions in exactly the same way as the table containing the text column to be indexed. The system checks whether the specified table space is defined in the same database partition group. |
Specify a table space that is defined in the same partition group as the table containing the text column to be indexed. |
CIE0711E |
Invalid operation on log table schema-name.table-name. Operation: operation. |
The log table keeps track of operations executed on the table containing the indexed text column. This table contains an invalid value due to manual changes made to this table. |
Check the log table, and delete or correct the invalid entry. |
CIE0712E |
The table named schema-name.table-name contains an incorrect syntax expression in the column named column-name. |
There is an error in the expression list in the specified text column. |
Check the delimiter Begin and End pairs. |
CIE0713E |
Length of index properties length exceeds max. maximum-allowed-length. |
The total length of index properties exceeds the maximum size. |
Report the error to your IBM service representative. |
CIE0714E |
Setting environment variable environment-variable failed. |
Setting the specified environment variable failed. |
Report the error to your IBM service representative. |
CIE0715E |
Call to function-name: rc=return-code, SQLCODE=sqlcode. |
An internal processing error occurred when calling an internal function. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0716E |
Error creating shared memory. |
The shared memory resource could not be created due to a previous error or a permission problem. |
Check db2diag.log for further information, or clean up your shared resources. Also see error CIE00703. |
CIE0717E |
Value for parameter parameter-name too long. |
The value exceeds the allowable maximum size. |
Check the maximum size. Correct the parameter to be within limits. |
CIE0718E |
Log table schema-name.table-name will be modified in next UPDATE. |
When starting an incremental index update, a time stamp is created. This serves as a threshold for processing change records. Changes occurring concurrently to the incremental update are processed during the next update. In certain situations, changes in transactions may be uncommitted at the time the update starts, but are committed while the index update is performed, which can lead to inconsistencies. To avoid inconsistent situations of this kind, the change records prior to the threshold time stamp are not deleted from the log table, even if they have been partially processed. During the next incremental update, the changes will be re-applied to the index. In case of delete operations, this can lead to warning messages in the log table indicating that the document was already deleted. |
If CIE00718 errors frequently occur, consider dropping and re-creating the index with a modified time stamp threshold for incremental index update. For example: This means that processing during an incremental update only changes records older than 30 seconds, and avoids interference with concurrent change transactions of less than 30 seconds. |
CIE0719E |
Target database system database-system-name not supported. |
You tried to execute a command with a connection to a database system that is not supported by DB2 Text Search. |
Check your environment and ensure that the DB2 Text Search is used against a supported database. |
CIE0720E |
Cannot find type or version info for server server-name. |
The type and version information for the server could not be found in the DB2 catalog view 'SERVERS'. |
Make sure that the DB2 federated environment is set up correctly. |
CIE0721E |
Signal signal caught. |
The program received a signal. |
If you did not interrupt the program, contact your IBM service representative. |
CIE0722E |
Corrupted instance services input file file-name. |
The file containing index information is corrupted. |
For obvious problems caused by manual editing of the file, use your system editor and try to correct the problem. You may have truncated an entry, or deleted the end-of-line character. If this does not restore the file content, try the following:
|
CIE0723E |
Windows Exception exception caught. |
The program received a Windows exception. |
If you did not interrupt the program, contact your IBM service representative. |
CIE0724E |
Exception exception, address=address, flags=flag. |
The program received a Windows exception. |
If you did not interrupt the program, contact your IBM service representative. |
CIE0725E |
DB2 Text Search is not supported in a multiple partition database environment. |
A text search index can be created only on DB2 configurations with a single partition. |
Ensure that the DB2 instance is not configured for with multiple database partitions. |
CIE0726E |
JDK_PATH setting is incorrect. |
DB2 Text Search requires use of the Java Runtime Environment (JRE) that is part of the DB2 installation. An error has occurred in finding the JRE due to a problem with the JDK_PATH value. |
Ensure that DB2 was installed successfully. Check the value of JDK_PATH, ensure it is pointing to the directory where the JRE was installed and that the JRE is accessible. The command 'db2 get dbm cfg' may be used to verify the JDK_PATH setting. |
CIE0727E |
Java classpath not found. |
A directory in the Java classpath for supporting DB2 Text Search was not found. |
Check the DB2 installation. Ensure that the DB2 Text Search option was selected and that the installation completed successfully. |
CIE0728E |
Cannot close file file-name. |
The file specified cannot be closed. |
Check if the file can be accessed. Also check if there is enough free space on the system. |
CIE0729E |
Cannot copy file file-name-1 to file-name-2. |
The first file cannot be copied to the second file. |
Check if the second file already exists and is writable. Also check if there is enough free space on the system. |
CIE0730E |
Cannot remove file file-name. |
The specified file cannot be removed from the system. |
Check if the file can be accessed. |
CIE0731E |
Failed to write on file file-name. |
The file specified is not writable. |
Check if the file can be accessed. Also check if there is enough free space on the system. |
CIE0732E |
Line line daemon index entry parsing error. |
The daemon file ciedem.dat is corrupted. The erroneous line is shown. |
|
CIE0733E |
Error in ciedem.dat: database-partition database-partition invalid. |
The daemon file ciedem.dat is corrupted. The value for a DB2 partition is not numeric. |
|
CIE0734E |
number index cleanup errors. |
The specified number of errors occurred during cleanup processing. |
|
CIE0735E |
number of number collections could not be deleted during this operation. |
During the DROP or DISABLE command, some collections of of the text search engine could not be dropped. |
Ensure that the text search instance services are up and running. If you working in a partitioned database, you need to check all servers. If they are running, try to stop and start those servers again. Check db2diag.log for details. |
CIE0736E |
Cannot delete collection collection-name from text search index schema-name.index-name. | ||
CIE0737E |
Cannot open file file-name. Reason code: reason-code. |
DB2 Text Search could not open the specified file. Reason codes:
|
Verify that the path of the specified file exists. Verify that the path and file permissions allow the file to be opened as required for the reason code specified. |
CIE0738E |
Cannot read nodes configuration file file-name. |
The specified file cannot be read. It is probably corrupted. |
Verify that the file contents comply with the format of the nodes configuration file. If this is not the case, correct the file accordingly. |
CIE0739E |
Error in nodes config file file-name. Reason code: reason-code. |
The content of the specified file is not consistent. Reason codes are interpreted as follows:
|
Check the file contents and correct the file according to the reason code. |
CIE0740E |
Nodes config file file-name needs entry for node database-partition. |
The file specified is not consistent. There is at least one node entry missing. |
Adapt the nodes configuration file and verify that it is in sync with the db2nodes.cfg file. |
CIE0741E |
Unsupported command command-name with schema-name.procedure-name procedure. |
The command specified is not supported in conjunction with the administration procedure. |
Use the db2ts executable to execute the command. |
CIE0742E |
No nodegroup information for table space table-space, table schema schema-name, table name table-name, node group name: database-partition-group-name. | ||
CIE0743E |
DB2 Installation copy for instance instance was not found. |
The DB2 installation copy to which the given instance belongs could not be found. |
Check the DB2 Installation. Please ensure that the following:
|
CIE0744E |
Unable to shut down text search instance services. |
You attempted to stop the text search instance services, but they could not be stopped. |
If there were errors using DB2 Text Search that indicated that the text search services should be stopped and restarted, the following steps might be necessary:
|
CIE0745E |
Cannot find file path path. |
A file in the DB2 Text Search installation path was not found. |
Check the DB2 installation. Ensure that the DB2 Text Search option was selected and that the installation completed successfully. |
CIE0746E |
Authentication error. Reason code: reason-code. |
Authentication failure occurred during a text search administration operation or a text search query. The reason code provides more information on the cause for the failure: Reason Code:
|
Check the DB2 installation. Ensure that the DB2 Text Search option was selected and that the installation completed successfully. A DB2 instance is associated with specific text search instance services that cannot be accessed from a different DB2 instance. Ensure that the correct text search instance services are being accessed. Stop and restart DB2 Text Search instance services. Consider running the tool for generating the authentication token as the authorized user. |
CIE0747E |
Timeout starting the text search server. |
The startup of text search instance services took much longer than normal. |
If there were errors using DB2 Text Search that indicated that the text search services should be stopped and restarted, the following steps might be necessary:
|
CIE0748E |
Shared memory not available. |
The shared memory resource could not be accessed due to a previous error or permission problem. |
Ensure that the text search instance services were started successfully. Check db2diag.log for further information, or clean up your shared resources. Stop and restart text search instance services. |
CIE0749E |
Could not delete collection directory. |
During the execution of the DISABLE command, the collection directory for text search indexes could not be removed. |
By default, the name of the subdirectory is system generated and is under the db2collections subdirectory in the database path, DBPATH, used by the database. The db2collections directory is is created during the ENABLE command and deleted when the database is disabled for text search. |
CIE0750E |
Command failed. Database concurrently associated with NSE. |
Only one type of text search index may be associated with a database at any given time. A database can use either DB2 Text Search or DB2 Net Search Extender for text search indexes, but not both concurrently. |
If you do not want to use DB2 Net Search Extender, disable the database using the DB2TEXT DISABLE DATABASE command. If you would rather use DB2 Net Search Extender, try this command again after disabling the database for DB2 Text Search. |
CIE0751E |
Unexpected condition detected. |
A processing error occurred when calling an internal function. An unexpected condition was detected. Operation could not complete. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0752E |
Mutex error. Details: details. |
An error occurred when a mutex function was called. |
If the error is persistent, turn on the trace for further error determination. |
CIE0753E |
Conditional variable error. Details: details. |
An error occurred when a conditional variable was called. |
If the error is persistent, turn on the trace for further error determination. |
CIE0754E |
Thread error. Details: details. |
An error occurred when a thread function was called. |
If the error is persistent, turn on the trace for further error determination. |
CIE0755E |
Communication failure. |
A processing error occurred when calling an internal function. The communication layer reported a failure without throwing an exception. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0756E |
Connect failed on host host-name and port port-number. |
The connection to the Text Search server can fail for various reasons, including the following:
|
Perform the following troubleshooting steps:
|
CIE0757E |
Receive failed on host named host-name and port port-number. |
DB2 Text Search instance services have detected one or more communication errors. A receive error on the named host and port occurred while responding to a request. |
Check the DB2 Text Search configuration. Ensure that the communication port specified is correct. If the error persists, start a DB2 trace and check the db2diag.log. Contact IBM software support for further assistance. |
CIE0758E |
Send failed on host named host-machine-name and port port-number. |
DB2 Text Search instance services have detected one or more communication errors. A send error occurred while sending a search request to the named host and port. |
Check the DB2 Text Search configuration. Ensure that the communication port specified is correct. If the error persists, start a DB2 trace and check the db2diag.log. Contact IBM software support for further assistance. |
CIE0759E |
Communications timeout on host named host-machine-name and port port-number. |
DB2 Text Search instance services have detected one or more communication errors. A request on the named host and port timed out. |
Check the DB2 Text Search configuration. Ensure that the communication port specified is correct. If the error persists, start a DB2 trace and check the db2diag.log. Contact IBM software support for further assistance. |
CIE0760E |
Protocol error. |
A processing error occurred when calling an internal function. A protocol error was encountered while processing a text search administration operation or a text search query. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0761E |
Authentication failure. |
Authentication failed during a text search administration operation or a text search query. |
Ensure correct configuration and that the operation is being requested using the text search instance services associated with the DB2. If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0762E |
Application error. |
A processing error occurred when calling an internal function. Server application error occurred while processing a text search administration operation or a text search query. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0763E |
Parse error at host host-name on port port-number. |
A processing error occurred when calling an internal function. A parse error occurred processing a response to a request on the named host and port. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0765E |
Unknown communication error. |
A processing error occurred when calling an internal function. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0766E |
Invalid search client state. |
A processing error occurred when calling an internal function. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0767E |
Invalid data data. |
A processing error occurred when calling an internal function. A Base64-encoded string contains invalid data. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0768E |
String string not aligned. |
The Base64-encoded string is either not aligned at a 4 character boundary, or not padded properly. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0769E |
Buffer size size too small. |
A processing error occurred when calling an internal function due to a small buffer size. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0770E |
method-name memory allocation failed. |
A processing error occurred when calling an internal function. Unable to allocate memory in the named method. |
If the error persists, start a trace and check the db2diag.log. Report the error to your IBM service representative. |
CIE0771E |
The DB2 Text Search services might not be active. |
The DB2 Text Search services are not accessible. The most probable reason is the services have not been started yet. |
To start the DB2 Text Search services, execute the following command:
|
CIE0772E |
The DB2 Text Search services are in an inconsistent state and need to be restarted. |
The DB2 Text Search services are in an inconsistent state, it is necessary to restart the services. |
To bring DB2 Text Search services into a consistent state, issue the following commands:
|
CIE0773E |
The text search authentication token is not valid. |
The DB2 Text Search authentication token is invalid and must be regenerated. |
To generate a valid authentication token, issue the following command:
|
CIE0774E |
The DB2 Text Search configuration could not be found. More diagnostic information is available in the db2diag log files. |
A failure occurred while attempting to access the DB2 Text Search configuration parameters. |
Respond to this error in one or more of the following ways:
|
CIE0775E |
The DB2 Text Search configuration parameters could not be read from the configuration file. More diagnostic information is available in the db2diag log files. |
A failure occurred while attempting to read the DB2 Text Search configuration parameters. |
Respond to this error in one or more of the following ways:
|
CIE0776E |
Restore failed for text search index schema-name.index-name. |
A failure occurred while attempting to restore the DB2 Text Search index. The most common reasons are:
|
See the db2diag.log for more details about the error.
|
CIE0777E |
Failed to schedule the text search task. Ensure the DB2 administrative task scheduler is properly setup. |
A failure occurred while attempting to add the Text Search task in the DB2 scheduler. |
Use the following instructions to verify the setup of the DB2 scheduler. Ensure:
Repeat the text search index operation to add the task in the scheduler. |
CIE0778E |
Schedule with taskname task-name already exists. |
A scheduler task with this taskname already exists. Schedule tasknames for text indexes are generated using the unique text index identifier, however, it is possible that an independently created manual schedule taskname causes a conflict. |
Repeat the operation, this results in a new index identifier and thus in a new schedule taskname. If the error persists, make sure that the TSSCHED_ prefix is reserved for the system-generated text index schedule tasknames. |
CIE0779E |
Error processing DB2 Text Search server configuration. |
A failure occurred while attempting to process the DB2 Text Search configuration parameters. |
Check the validity of the information added during or after the enablement of the database for text search in the SYSIBMTS.TSSERVERS administrative view like host, port or token. Update the parameters that appear invalid by issuing the SYSTS_CONFIGURE procedure. |
CIE0780E |
Cannot create collection collection-name for text search index schema-name.index-name. |
An error occurred while creating a collection for the text search index. Creating an index in a partitioned database environment might create multiple collections. It is essential that all collections be created successfully for the CREATE INDEX operation to be successful. |
Check read and write permissions for the directories where the collections are being created. Verify the following:
See the db2diag.log for more details about this error. |
CIE0781E |
DB2 Text Search is not supported in a DB2 pureScale environment. |
DB2 Text Search is not supported in a DB2 pureScale environment. |
Reconfigure DB2 Text Search. |
CIE0782E |
Incorrect number of active DB2 Text Search servers. |
You are receiving this error due to the following inconsistency in the SYSIBMTS.TSSERVERS view:
|
Ensure that there is only one entry for an active text search server in the SYSIBMTS.TSSERVERS view. |