IBM (R) DB2 (R) Net Search Extender Release Notes Version 8.2.7 © Copyright International Business Machines Corporation 1999, 2006. All rights reserved. U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. ------------------------------------------------------------------------ Table of Contents DOCUMENTATION HINTS AND TIPS PROBLEMS ------------------------------------------------------------------------ Welcome to IBM DB2 Net Search Extender Version 8.2.7 This file contains information that was not available when the "IBM DB2 Net Search Extender Administration and User's Guide" was put on CD-ROM or printed. DOCUMENTATION ______________ 1.Use the AIX (R) pre-requisites: - xlC.aix43.rte 6.0.0.13 on AIX 4.3.3 - xlC.aix50.rte 6.0.0.13 on AIX 5.x 2. Appendix F Message CTE0360 is not described and not translated. It covers product messages after message translation was completed. HINTS AND TIPS ______________ 1. DB2TEXT START command on Windows (R) Ensure that the user running the command is a member of the Administrators group. Otherwise, the 'db2text start' command will fail with the following message: CTE0218 Function "OpenSCManager()" failed with error code "5". 2. DB2EXT- service on Windows Ensure that the Net Search Extender instance service "DB2EXT-" is running under a user account rather than the system account. Otherwise, you can not enable your database. 3. As the Net Search Extender event log messages are always in the DB2 server language, event log messages for commands issued from the DB2 Control Center might be displayed in a different language than the DB2 Control Center is running in. 4. If the following DB2 Control Center message displays: 'No license for Net Search Extender found', ensure the DB2 Administration Server is running, as this message is displayed even if the license is installed. Check DB2 documentation for information on how to setup and start the DB2 Administration Server. 5. If you have modified the db2cli.ini and have problems using Net Search Extender, restore the original version of db2cli.ini. 6. Client Server interoperability It is necessary to install the same Net Search Extender Fix Pack level on both the server and client side. Interoperability from client to server and vice versa is only possible for the list of supported platforms found in the documentation. 7. This version of Net Search Extender supports the syntax of DB2 Text Information Extender V7.2. However, if you incorrectly specify the syntax, the command is finally parsed according to the Net Search Extender V8.1 syntax. This may result in a misleading error message. 8. Log size If the indexing process is not completed, because the error and warning messages require more space than the available DB2 log size, DB2 will rollback the whole transaction and not commit the log table entries. This means that you will not be able to see the entries. Check the DB2 documentation for information on how to increase your transaction log to avoid this situation. 9. When using the Create Index Wizard within the DB2 Control Center, ensure that the Net Search Extender instance service is running before you click on the "Finish" button. If the instance service is not running, an error message is displayed and the text index is not created. 10.Partitioned database support (AIX only) a)Ensure the DB2 setup is completed as described in the DB2 documentation. If you use a shared file system between physical nodes under NFS, the NFS mount needs to be configured with root access and setuid. b)During search, the RESULT LIMIT is evaluated on every node. This means if you have specified RESULT LIMIT 3 and use 4 nodes, your total result set can have up to 12 elements. c)If a problem occurs during "db2text start" no detailed message is given as to which of the available nodes are affected. Issuing a second "db2text start" will try to start the service on each of the nodes. If the following message is displayed: CTE0185 The update and locking services are already active db2text start was successful. 11.Using DBCS object names If you use DBCS object names with db2text administration commands, it is necessary to enclose those names within double quotes to avoid uppercase transformation. 12.Index on nickname with incremental index update using DB2 Replication. If initial updates on two or more indexes are started at the same time, the update command may return a SQL0803N error. In this case, try the update command again. 13.Single masking and character normalization If you are using character normalization words like ’über’ are stored in the index in the normalized form (’ueber’). This means if you do single character masking like '_ber' you will not find ’über’. You need to use two single character masking characters to get the correct match. PROBLEMS ________ Windows, Linux (R) and UNIX (R) ---------------- 1. Do not use duplicate cache column names. You will not get an error during text index creation or index update, but the search will not work. In this case, you will get an SQL error message that duplicate columns were used. 2. If indexing DATALINK values produces warnings that are too large to display, you will get the following error message: "java.lang.Exception: Error in UDF setSQLmessage.". SQLSTATE=01H80 In this case, check the SQLSTATE. The numbers are described in Appendix K. Data Link messages. 3. Wrong shared memory size requested If you specify a too small maximum cache size during an "activate cache" command, you will get an incorrect figure for the required cache size in the resulting error message. Check the cache size using the DB2EXT.MAXIMUM_CACHE_SIZE and DB2EXT.PCTFREE functions. Correct the maximum cache size with the db2text alter index command and start the process again. 4. Old search syntax with thesaurus usage does not work. You need to reformulate your query using the new search syntax. 5. Unicode tables in a non unicode database It is not supported to create a text index on a table which has been created with the CCSID UNICODE option. Linux and UNIX -------------- 5. Using INSO file format On AIX, it is required to set the environment variables: - DB2ENVLIST='LIBPATH' and - DB2LIBPATH=/sqllib/lib:/usr/opt/db2_08_01/lib. If the variables are not set, an error message occurs during index update, stating that the INSO libraries are not found. It is not recommended to use format specification INSO for XML, HTML or plain text documents. When such a format can not be correctly determined, the document will be indexed as plain text. If special characters or the encoding of special characters are used within such a document, the search will not work correctly. If possible, those formats should be indexed with their own format specifier. 6. Linux search problem with the wrong LANG environment variable If you use a 7-bit ASCII code page as the LANG variable setting, the following error might occur: "SearchString parse: check LANG & locale charmap values." To avoid this, change your LANG variable to a 8-bit LANG value, restart DB2 and try again. 7. SunOS 5.8 and search using zh_TW.BIG5 or ko_KR.BIG5 Net Search Extender does not work with the locales zh_TW.BIG5 or ko_KR.BIG5 on SunOS 5.8. Instead use SunOS 5.9, where this problem is fixed. Windows ------- 8. File access problems If you encounter file access problems, for example, on a document model, text index, or thesaurus, ensure that the user has the correct password and authorizations for running the Net Search Extender instance services. This especially applies to shared resources on mapped network drives. 9. Cache not usable During search or activate cache the following error message may be displayed: "CTE0271 Cache not usable, DEACTIVATE and ACTIVATE RECREATE required." To solve this problem, check your system settings and try to increase the amount of paging space and free memory. 10.Service not dropped after uninstall If the service is not dropped after you uninstall Net Search Extender you could use following tool to drop it manually. ctereg unregister for example: ctereg db2-0 unregister DB2 Control Center ------------------ 11.Unexpected messages on Solaris When using DB2 Control Center on the Solaris Operating Environment, error messages might be displayed if several actions are taken within a short period of time. For example: CTE0151 Token "CONTROL" is unexpected. Check the command syntax. As this is a concurrency problem, ignore the messages and wait a short period of time before retrying the actions. Partitioned database support (AIX) ---------------------------------- 12.cteprcrx terminated abnormally (UNIX) Check that the used instance does not have a separate fenced user ID. To check this, list the file .fenced in /sqllib/adm, and make sure that the instance owner is the owner of .fenced. 13.Update index seems to loop Check that your file system has enough free space to store the index files. Running out of disk space during an index update can corrupt the index and will cause the need for a complete rebuild. ------------------------------------------------------------------------ Notices IBM may not offer the products, services, or features discussed in this document in all countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A. For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country/region or send inquiries, in writing, to: IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106, Japan The following paragraph does not apply to the United Kingdom or any other country/region where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY, OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions; therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice. Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product, and use of those Web sites is at your own risk. IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you. Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information that has been exchanged, should contact: IBM Canada Limited Office of the Lab Director 8200 Warden Avenue Markham, Ontario L6G 1C7 CANADA Such information may be available, subject to appropriate terms and conditions, including in some cases payment of a fee. The licensed program described in this document and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us. Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems, and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment. Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements, or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility, or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only. This information may contain examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious, and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental. COPYRIGHT LICENSE: This information may contain sample application programs, in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM for the purposes of developing, using, marketing, or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. Each copy or any portion of these sample programs or any derivative work must include a copyright notice as follows: (C) (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs. (C) Copyright IBM Corp. _enter the year or years_. All rights reserved. IBM, AIX, and DB2 are trademarks of International Business Machines Corporation in the United States, other countries, or both. Windows and Windows NT are registered trademarks of Microsoft Corporation in the United States, other countries, or both. Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. UNIX is a registered trademark of The Open Group in the United States and other countries. Other company, product, or service names may be trademarks or service marks of others.