home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList