DB2 - Problem description
Problem IC66965 | Status: Closed |
"DB2TS START FOR TEXT" FAILS IN A NON-ROOT SETUP WITH ERROR SQL20427N/CIE00707 | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
In a non-root setup of DB2 V9.5 and V9.7, if the instance is active and the text search component is installed during a work with existing install, text search may not be configured properly. The install log file would show the following error: ERROR:IQQG0026E The configuration file /home/jeevat/sqllib/db2tss/config/config.xml has an error. It is advised in the post install steps, to update the instance since some were active. Since text search is not properly configured, while trying to start text search you may get the following error: $ db2ts start for text SQL20427N An error occurred during a text search administration procedure or command. The error message is "CIE00395 No db2ts start command was issued. ". SQLSTATE=38H14 After applying the fix, you will see the following message in the Post Install Steps of the log: DB2 Text Search has not been configured. Run the db2isetup command to configure the DB2 Text Search server. Manual configuration steps can be found in the DB2 Text Search documentation "http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com. ibm.db2.luw.admin.ts.doc/doc/t0052690.html". | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * In a non-root setup of DB2 V9.5 and V9.7, if the instance is * * * * active and the text search component is installed during a * * work * * with existing install, text search may not be configured * * * * properly. The install log file would show the following * * error: * * * * * * ERROR:IQQG0026E The configuration file * * * * /home/jeevat/sqllib/db2tss/config/config.xml has an error. * * * * * * * * It is advised in the post install steps, to update the * * instance * * since some were active. * * * * * * * * Since text search is not properly configured, while trying * * to * * start text search you may get the following error: * * * * * * * * $ db2ts start for text * * * * SQL20427N An error occurred during a text search * * administration * * procedure or command. The error message is "CIE00395 No * * db2ts * * start command was issued. ". SQLSTATE=38H14 * **************************************************************** * RECOMMENDATION: * * Install DB2 V9.7 FixPack 2. * **************************************************************** | |
Local Fix: | |
1) Stop the instance using 'db2stop', then run 'db2isetup' to configure text search; or 2) Stop the instance using 'db2stop', then run 'db2nrupdt' to update the instance and manually configure text search. See the "Configuring DB2 Text Search using the Configuration Tool" in the Information Center for more details. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
Install DB2 V9.7 FixPack 2. After applying the fix, you will see the following message in the Post Install Steps of the log: DB2 Text Search has not been configured. Run the db2isetup command to configure the DB2 Text Search server. Manual configuration steps can be found in the DB2 Text Search documentation "http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com . ibm.db2.luw.admin.ts.doc/doc/t0052690.html". | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.03.2010 31.05.2010 31.05.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |