IBM DB2* Universal Database Text Extender Version Version 7.1 for AIX* Fixpak 4 FP4_TE_U485543 This fixpak includes FixPak 1,FixPak 2 and FixPak 3. -------------------------------------------------------------------------------- Content 1. Prerequisites 2. Changes 2.1 Enhancements 2.2 Fixed problems 3. Hints 4. Current restrictions 5. Installation 5.1 Steps after installation 5.2 AIX 5.2.1 Installation instructions 5.2.2 Updating the instances 5.2.3 Recreating the Text Extender indexes -------------------------------------------------------------------------------- ================================================================================ 1. Prerequisites ================================================================================ DB2 Text Extender Version 7.1 must be installed on the machine before you install the FixPak. The FixPak runs on DB2 Version 7.1 or DB2 Version 7.2. ================================================================================ 2. Changes ================================================================================ -------------------------------------------------------------------------------- 2.1 Enhancements -------------------------------------------------------------------------------- The following enhancements have been shipped with fixpak 1 and 2 already. 1. New languages are supported. For a complete list see the DB2 UDB Text Extender Administration and Programming Guide V7.1.0.1 page 43f 2. New server administration command file txservice Use this command file only in case of Text Extender problems. The command file collects information about your environment and writes the information to a file. You can review the file and send it to IBM service. 3. Limit of 60 sections to be searched for has been removed. 4. Limit of 32KB for a paragraph in an XML document. 5. New option for the server ini file 'dessrv.ini' to specify that signal handling is switched off to force a core dump. 6. Support for precise and linguistic search on a UTF8 database. 7. Support to update the handle values with user defined formats using the UDF db2tx.format. 8. Increased limit of relationships supported by an NGRAM thesaurus. 9. Increased internal limits to avoid "QUERY_TOO_COMPLEX" problems. -------------------------------------------------------------------------------- 2.2 Fixed problems -------------------------------------------------------------------------------- New fixes 1. Indexing error if the search server has been started using txstart in a terminal services session. 2. Search terms containing national language characters in a UTF8 database did not return results. The following fixes have been shipped with fixpak 1, 2 and 3 already. 1. Various problems with the sample GUI 'txwizard'. 2. Invalid error message RC_SE_CCS_NOT_SUPPORTED if the thesaurus path name was too long. 3. Problem that the # character could not be searched. 4. Problem that the last word of a document could not be searched. 5. Missing XML support for SUN. 6. G_LADN_ABEND problem. The fix for this problem requires to reindex the data. 7. Signal handling setting for SIGPIPE is preserved now. 8. Various documentation updates. See new version of DB2 Text Extender Administration and Programming Guide V7.1.0.1 which is available for download from the FixPak directory. 9. Problem that Text Extender has overwritten DB2 signal handlers. 10. Search for national language characters (e.g. German Umlaut) in a UTF8 database. 11. RC 201 problem when enabling a UTF8 database with "db2tx enable database" if running in a DB2 V7.2 environment. 12. Fix for search crash using front and end masking ( e.g. %term% ) 13. Solaris only : Search crash when the search_result UDF is used and not all columns of the created temporary table have been selected. 14. Semaphore timeout problem when running index updates and searches in parallel. 15. Thesaurus search for accented characters did not return a result. 16. RC_NOT_ENOUGH_MEMORY for large result lists. ================================================================================ 3. Hints ================================================================================ 1. UNIX: For databases with CCSID's other than 850 the sample command file 'txsample' has to be adapted. Change the CCSID value in the ENABLE TEXT COLUMN commands for the NGRAM indextype from 850 to your database CCSID. 2. If the desdiag.log file shows an error ...Shared Memory Access Failed o UNIX Try to remove pending shared resources using the new command txipclean Refer to the Administration and Programming Guide for more information. o Windows Stop and start Text Extender. o If you encounter that only one node has been indexed correctly in a EEE environment, check the the system time is the same on all nodes. 3. If you use the utility db2look to generate ddl statements for a Text Extender enabled database, check if the statements to create the Text Extender distinct types are defined with the FOR BIT DATA option. e.g. create distinct type db2tx.DB2TextH as VARCHAR (60) FOR BIT DATA with comparisons; db2look generates the distinct types without this option. This causes all handle values that are generated by Text Extender to be corrupted. Either change all these statements manually or copy the statements stored in the Text Extender installation directory ddl, file descudt.ddl You can also run this file with : db2 -tvf descudt.ddl from the operating system command prompt. ================================================================================ 4. Current restrictions ================================================================================ o To run Text Extender administration commands from a Windows NT or Windows 2000, the setting for the DB2 service in the Services window of the Control Panel is set to a valid administrator userid. o For Windows NT, the environment variable DB2INSTANCE must be set as system environment variable. If it is not set, the utilities txstart, txstatus and txstop cannot be called. o STEMMED FORM OF for indextype normalized is only supported for US_ENGLISH. o The REFINE UDF does not support IS ABOUT or THESAURUS queries as a query refinement. o Masking is not allowed for SOUNDS LIKE. o The maximum number of model names in the model definition file is 50. o Stemming is not supported for thesaurus searches on a linguistic indextype. o Search on a UTF8 database is currently not supported for DBCS data. o The backslash cannot be used as escape character for CCSID 954 o The following formats are not supported for DBCS languages: AMI, FFT, MSWORD, RFT, RTF, WP5 o Values for attribute sections for search must be SBCS characters. o Running multiple enabling commands in a EEE environment on the same table in parallel may result in RC 507 shown with db2tx get index status. Workaround: Run the enable commands sequentially. o For Windows 2000 the system and user locale must match. o Linguistic search requires correct spelling with respect to the first character regarding upper/lowercase if the search term requires linguistic normalization. E.g. German "Edelmetalle" in the document is not found if the search term is "edelmetalle". The reason is that at indexing time the plural "Edelmetalle" is normalized to singular "Edelmetall" and then to "edelmetall" which is stored in the index. A search for "edelmetalle" is processed by a dictionary lookup. As the dictionary contains the correct German spelling for a noun "Edelmetalle" the search term is not found. In this case the search term is used for the index lookup. This results in a "not found" condition. o Word decomposition. Word decomposition is only possible if the parts of a compound word are available in the base form. E.g. German "Kindersprache" is stored in the index as "kindersprache" and "sprache". The index does not contain "kinder" or "kind" as "Kinder" in "Kindersprache" is the plural of "Kind". ================================================================================ 5. Installation ================================================================================ General steps for all platforms: Perform the following steps for each instance: (You can get a list of all Text Extender instances by issuing the txilist command as described in the Text Extender documentation): 1. Terminate all Text Extender Command Line Processor sessions. 2. Make sure that the Text Extender server has been stopped by issuing : txstop 3. Make sure that all DB2 connections are terminated by issuing : db2 terminate 4. Check if applications are still active by issuing: db2 list applications show detail 5. If applications are still running, check that you can stop running DB2 applications and enter the following command: db2 force applications all -------------------------------------------------------------------------------- 5.1 Steps after installation -------------------------------------------------------------------------------- Because the structure of the Text Extender indexes changed slightly with the current FixPak, you have to drop and recreate it before you can use it with the new fixpak version. See the description of the Text Extender commands DISABLE TEXT COLUMN/TABLE/FILES and ENABLE TEXT COLUMN/TABLE/FILES in the Text Extender documentation on how to drop and create Text Extender indexes. -------------------------------------------------------------------------------- 5.2 AIX -------------------------------------------------------------------------------- To install the FixPak on your machine, there are three major steps to perform: 1. Installing the Text Extender FixPak software (chapter 5.2.1) 2. Updating the Text Extender instances (chapter 5.2.2) 3. Recreating the Text Extender indexes (chapter 5.2.3) In a DB2 EEE environment you have to perform step 1 on all physical nodes. Steps 2 and 3 have to be performed for the master node only. The steps are described in the following chapters. 5.2.1 Installation instructions Perform the following steps to install the FixPak: 1. Download the fixpack file FP3_TE_U483956.tar.Z in binary format. 2. Uncompress the file using the following command: uncompress FP3_TE_U483956.tar.Z 3. Untar the uncompressed file by issuing tar -xvf FP3_TE_U483956.tar 4. Important: Perform the general steps at the beginning of chapter 5. 5. Use the System Management Interface Tool (SMIT) to run installp from a prompted interface, or enter the installp command. 6. Enter the smit install_latest command. The Software Installation and Maintenance Tool menu opens. 7. Type in the location of the package in the INPUT device / diretory for software field. 8. Click the DO button or press ENTER. This confirms the installation directory. 9. Identify in the SOFTWARE TO INSTALL field whether the client or server components are to be installed. Select all filesets to be updated that had been installed on your system before. 7. Click the DO button or press ENTER. You are prompted for confirmation of the installation parameters. To confirm, press ENTER. 5.2.2 Updating the instances Enter the following command for all Text Extender instances on your system (You can get a list of all Text Extender instances by issuing the command /usr/lpp/db2tx_07_01/instance/txilist with root authority): /usr/lpp/db2tx_07_01/instance/txiupdt my_TE_instance my_DB2_instance where my_TE_instance is the instance owning user-id of your Text Extender instance and my_DB2_instance is the instance owning user-id of the related DB2 instance, which is usually the same user-id as for the Text Extender. 5.2.3 Recreating the Text Extender indexes If this FixPak is installed and neither FixPak 1, 2 or 3 had been installed before, the Text Extender created indexes have to be dropped and recreated. See the description of the Text Extender commands DISABLE TEXT COLUMN/TABLE/FILES and ENABLE TEXT COLUMN/TABLE/FILES in the Text Extender documentation on how to drop and create Text Extender indexes. -------------------------------------------------------------------------------- For any problems related to that FixPak, please contact: 001-770-863-1234 ...International Helpdesk 001-800-237-5511 ...DB2 Software Support (24 Stunden) 001-888-426-4343 (Option 3) ...Support Family Information Center 001-800-426-4968 ...Marketing (001-800-IBM-4YOU) -------------------------------------------------------------------------------- * are trademarks or registered trademarks of IBM Corporation. ** are trademarks or registered trademarks of their respective owners. -------------------------------------------------------------------------------- ******************************************************************************** ** ** (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 2000. ** ALL RIGHTS RESERVED. ** ********************************************************************************