*********************************************************************** * * (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 1997. * ALL RIGHTS RESERVED. * *********************************************************************** Welcome to IBM* DB2 Universal Database* (DB2*) Text Extender FixPak WR20046 for AIX* Server Version 5.0.0 +-- Note: -----------------------------------------------------------+ | | This FixPak contains fixes for the following problems: | - New migration utility for Text Extender Version 1.1 or 1.2 | enabled databases and created text indexes. | - Performance enhancement | - New return code RC_SE_DICTIONARY_NOT_FOUND if either a | dictionary or a thesaurus that is requested has not been | installed. | - New retrun code RC_SE_LINGUISTIC_SERVICE_FAILED if the | linguistic service component detected a problem during | processing of a query. | User action: Check that the relationship name of a | Thesaurus query is valid. Check that the language and the CCSID | supplied are valid. | - Fix for SEARCH_RESULT UDF definition in descudf.ddl | +--------------------------------------------------------------------+ For installation instructions please see section 2.1 This README file contains information for the following products and components: AIX-Specific ------------- IBM DB2 UDB Text Extender for AIX Server IBM DB2 UDB Text Extender for AIX Client ---------------------------------------------------------------------- 1. Contents for FixPak 2. Installation Notes 2.1 Information for Installing this FixPak 2.1.1 Pre-Requisites 2.1.2 Installation Instructions 3. Fix Content 3.1 Migration from DB2 Text Extender Version 1.1 and 1.2 3.1.1 Pre-Requisites 3.1.2 Migrating indexes 3.1.3 Migrating databases 4. After Installation 4.1 Updating Database 5. Miscellaneous 5.1 DB2 Family Newsletter 5.2 Customer Support 5.3 Corrective Service ********************************************************************** 2. Installation Notes ______________________ 2.1 Information for Installing this FixPak ___________________________________________ You can use the 'service' command to install this FixPak. 2.1.1 Pre-Requisites _____________________ This FixPak requires one of the following to already be installed on the machine: - DB2 UDB Version 5.0 for AIX - DB2 UDB Text Extender Version 5.0 for AIX Use 'lslpp -l product_name' to list the level of DB2 for AIX on the machine; product_name should be the name of an installable option such as db2_05_00.db2.rte. 2.1.2 Installation Instructions ________________________________ For each instance: o Terminate all Text Extender Command Line Processor sessions. o Make sure that the Text Extender server has been stopped by issuing : txstop o Make sure that the DB2 server has been stopped by issuing : db2stop If the DB2 server cannot be stopped, you might have to terminate the database connections. Enter: db2 terminate If the database can still not be stopped, you must force all applications to terminate. Enter: db2 force applications all After each of your instances have stopped, run `/usr/sbin/slibclean` to remove the old versions of the libraries from memory. For more information about slibclean, please refer to the man pages. Install the selected updates using script file service. Which copies all files in the current directory to the correct postiton. service see also intall.txt. 3.1 Migration _____________ 3.1.1 Pre-Requisites ____________________ Pre-Requisite for applying the DB2 UDB Text Extender Migration utilities are DB2 Text Extender Version 1.1 or 1.2 created indexes. 3.1.2 Migrating instances _________________________ If you want to reuse your Text Extender Version 1.1 or 1.2 created text indexes you must migrate the index files and the corresponding master table file. To avoid a loss of the Text Extender created indexes due to problems that might result from the migration step, it might be reasonable to make a backup of the index directories and the corresponding desmastr.dat file in \"instance home\db2tx\desmastr.dat Use the following command for the migration: txmigr db2instance db2txinstance [port] Note: You have to use the root userid to execute the command! 3.1.3 Migrating databases _____________________________________ After migrating indexes you have to migrate your Text Extender Version 1.1 or 1.2. enabled database. Be sure to migrate your database to DB2 Version 5 first. Use the following command to migrate the database: txdbmigr database_name where database_name is the name of the database you want to migrate. Note: You have to use the db2 instance userid to execute the command! 4. After Installation ______________________ 4.1 Updating Instances _______________________ If you did not migrate the Text Extender enabled database for each instance you have to run the following command for each Text Extender Version 5.0 enabled database. /usr/lpp/db2tx_05_00/bin/txdbupdt is the name of Text Extender Version 5.0 enabled database. 5.1 DB2 Family Newsletter __________________________ For the latest information about the DB2 family of products, you may subscribe to the "DB2 Family Newsletter" (English only). Simply send your request in a FAX to 1-905-316-4733, and include the following information: Name Company name Full mailing address Telephone number DB2 products you currently use 5.2 Customer Support _____________________ To speak to an IBM representative regarding assistance with this product, please call 1-800-CALL-AIX (1-800-225-5249). Customer support is also provided via Electronic Question and Answer (Q&A) forums. These forums are accessible through CompuServe, IBMLink, and Usenet Newsgroup. (1) CompuServe - To access the forums on CompuServe, execute GO IBMDB2. - If you don't have access to CompuServe, call 1-800-848-8199 for membership information in Canada or the US. (2) Usenet Newsgroup: comp.databases.ibm-db2 - This Internet Newsgroup is a general forum for discussing questions and/or problems encountered using the DB2 family of products. (3) (IBMLink) Talklink OS/2 BBS - To access the forums on IBMLink, go to the OS2BBS section. - If you don't have access IBMLink, call 1-800-547-1283 for membership information in Canada or the US. 5.3 Corrective Service _______________________ They can be downloaded electronically from the following location: (1) Internet - FTP to anonymous server ftp.software.ibm.com (previously known as ps.boulder.ibm.com) at 198.17.57.66 - then go to ps/products/db2extenders/fixes// where is (eg. english-us, spanish, german, etc.) is the product name/version (eg. v12nt, v50aix, etc.) - Use a World Wide Web (WWW) browser to connect to the DB2 Service and Support Page. (http://www.software.ibm.com/data/db2/db2tech/index.html) If you do not have access to any of the above locations, please call 1-800-CALL-AIX (1-800-225-5249) to request these FixPaks be sent to you in the mail. For countries other than US and Canada, please look at your local IBM OS/2 BBS or call your local DB2 Customer Service number for assistance in obtaining them. ---------------------------------------------------------------------- * are trademarks or registered trademarks of IBM Corporation. * are trademarks or registered trademarks of their respective owners. ---------------------------------------------------------------------- ********************************************************************** * * (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 1997. * ALL RIGHTS RESERVED. * **********************************************************************