IBM DB2* Universal Database Text Extender Version Version 7.1 for Windows* Fixpak 4 FP4_TE_WR21083 This fixpak includes all previous Text Extender V7 FixPaks -------------------------------------------------------------------------------- Content 1. Prerequisites 2. Changes 2.1 Enhancements 2.2 Fixed problems 3. Hints 4. Current restrictions 5. Installation 5.1 Steps after installation ================================================================================ 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 1already. 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 -------------------------------------------------------------------------------- 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. 3. Various problems with the sample GUI 'txwizard'. 4. Invalid error message RC_SE_CCS_NOT_SUPPORTED if the thesaurus path name was too long. 5. Problem that the # character could not be searched. 6. Problem that the last word of a document could not be searched. 7. Missing XML support for SUN. 8. G_LADN_ABEND problem. 9 The fix for this problem requires to reindex the data. 10. Signal handling setting for SIGPIPE is preserved now. 11. 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. 12. Problem that Text Extender has overwritten DB2 signal handlers. 13. Search for national language characters (e.g. German Umlaut) in a UTF8 database. 14. RC 201 problem when enabling a UTF8 database with "db2tx enable database" if running in a DB2 V7.2 environment. 15. Fix for search crash using front and end masking ( e.g. %term% ) 16. Solaris only : Search crash when the search_result UDF is used and not all columns of the created temporary table have been selected. 17. Semaphore timeout problem when running index updates and searches in parallel. 18. Thesaurus search for accented characters did not return a result. 19. 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. To modify the supplied language specific stopword files you must edit the specific *.tsw files and not the *.stw files. The *.tsw files are encoded in Unicode and require for proper editing a Unicode editor. ================================================================================ 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 ================================================================================ In a DB2 EEE environment you have to install the FixPak on all physical nodes. Installation instructions 1. Download file FP4_TE_WR21083.zip in binary format. 2. Copy the file to a separate directory. 3. Unzip the file using your preferred unzip tool. 4. Terminate all Text Extender Command Line Processor sessions. 5. Make sure that the Text Extender server has been stopped by issuing : txstop 6. Make sure that all DB2 connections are terminated by issuing : db2 terminate 7. Check if applications are still active by issuing: db2 list applications show detail 8. If applications are still running, check that you can stop running DB2 applications and enter the following command: db2 force applications all 9. Open a new console window and change to the directory where you extracted the FixPak. 6. To install the FixPak, enter the following command: service -install A FixPak installation log is written to the current directory. 7. Start DB2 and the Text Extender server again by issuing the following commands: db2start txstart -------------------------------------------------------------------------------- 5.1 Steps after installation -------------------------------------------------------------------------------- If this FixPak is installed on top of the General Availability Version, the indexes that have been created with Text Extender have to be recreated before you can use them with he new FixPak level. If you have installed FixPak 1 already and recreated the indexes at that time, you do not have to recreate them again. 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. ** ********************************************************************************