IBM(R) DB2 Web Query Tool, Version 1 Release 3, FixPak 1 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 CORRECTED KNOWN PROBLEMS 3.0 PREREQUISITES 3.1 Hardware Requirements 3.2 Software Requirements 4.0 INSTALLATION INSTRUCTIONS 4.1 To upgrade to DB2 Web Query Tool version 1.3 fixpak 1 when working with WebSphere Application Server Version 4.0.3 4.2 To upgrade to DB2 Web Query Tool version 1.3 fixpak 1 when working with WebSphere Application Server Version 3.5.5 5.0 CORRECTIONS TO DOCUMENTATION 6.0 SERVICE 7.0 FUNCTIONALITY NOT SUPPORTED 8.0 NOTICES 8.1 Notices of other companies 8.2 Trademarks and service marks _________________________________________________________________________________________________________ 1.0 ABOUT THIS README FILE Welcome to IBM DB2 Web Query Tool, Version 1 Release 3, FixPak 1 that contains the latest fixes for DB2 Web Query Tool V1.3. This FixPak is a complete replacement of the product without the License Use Management (LUM) key. Loading this FixPak onto a previous version and/or release of DB2 Web Query Tool will result in error message: No license for this product is available: ID020019 To migrate to the latest version or release of DB2 Web Query Tool, please contact your IBM provider to order the appropriate LUM key for the version/release that you want to install. 2.0 CORRECTED KNOWN PROBLEMS - You can now import from a URL, the to character encoding issues have been resolved. - You can now view the Query Log Using Netscape. - SVG Charting error when displaying in some browsers has been fixed. - DBCS issues for database and result set data have been resolved. - The issues on the XSL Workbench involved with setup options, saving, and downloading have been fixed. - The issues with previewing chart on the Chart Workbench have been fixed. - Preferences for the currently logged in user are now saved. - Messages have been added to the login screen for setup/configuration. - A blank screen no longer appears when deleting from tables. - SQL/PA options and processing have been fixed. - A recursive error when granting privileges to own ID no longer occurs. - Queries that do not produce results now return messages to the user. - Problem with FTP and HTTP retrieval of queries has been fixed. - Fixed issues on iSeries when comparing and Create Like for tables. - Query lookup variables no longer have the problem of retaining value and not populating all references to a variable. - Saving catalog objects will no longer cause objects tube removed from catalog.Fixed - Informix data type issues that were causing problems with create like operations have been fixed. - When you drop an Alias in DB2 Web Query, the associated Table is no longer dropped. - Missing context sensitive help has been added. - 500 type errors no longer occur when using the SQL Assist which cause 500 errors when used. - The SQL assistant GROUP BY feature now functions properly. - The error that occurred when renaming table objects has been fixed. - Fixed problem with filter specification which caused duplicate entries. - Invalid sqlids are no longer captured in filters. - CSV data is now imported correctly. 3.0 PREREQUISITES 3.1 HARDWARE REQUIREMENTS Hardware requirements are those needed to run the software that is described in 3.2 Software Requirements. DB2 Web Query has the following hardware requirements: - Approximately 64 MB of free disk space on any supported platform - Additional space for user data - A minimum of 64 MB memory - Memory to fulfill Websphere and DB2 minimum requirements 3.2 SOFTWARE REQUIREMENTS In order to work with IBM DB2 Web Query Tool, you need to have a Web server, a Web Application server (such as IBM WebSphere Application Server), JDBC and DB2 installed on your system. You also need to be able to connect to a DB2 database. When you are using DB2 Web Query Tool, you are working in a browser. Information that you send to DB2 Web Query Tool first goes through your Web Server. Your Web Server passes the information to your Web Application Server (IBM WebSphere Application Server). Your Web Application Server passes the information to DB2 through JDBC. The following table indicates the operating systems, DB2 Web Query Tool products, and the WebSphere products that you can choose for your business. Operating systems, DB2 Web Query Tool products, and the WebSphere products that are supported by DB2 Web Query v 1.3: Operating System | IBM DB2 Web Query Tool Product | IBM WebSphere Product ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- UNIX and Linux | IBM DB2 Web Query Tool for Multiplatform | IBM WebSphere Application Server V3.5.5, or V4.0.3 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Windows NT or | IBM DB2 Web Query Tool for Multiplatform | IBM WebSphere Application Server V3.5.5, or V4.0.3 Windows 2000 | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- OS/400 Version 4.4 or | IBM DB2 Web Query Tool for iSeries | IBM WebSphere Application Server V3.5.5, or V4.0.3 later | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- z/OS, OS/390 | IBM DB2 Web Query Tool for z/OS | IBM WebSphere Application Server V3.5, or V4.0.3 Operating System, | | Version 2 Release 5 or | | higher with UNIX | | System Services | | installed on MVS | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Note: IBM WebSphere Application Server is recommended (versions 3.5.5, and 4.0 are supported). However, DB2 Web Query Tool is compatible with any application server that supports JSDK 1.3 and above, J2EE and JDBC 1.0. Functional Dependency: If you use WebSphere Application Server on z/OS or OS/390, Version 4.0 is required to use the SOAP functions. Database: IBM DB2 Version 5.x and above with a JDBC Type-2 Driver, with the applicable updates to enable JDBC. DB2 Web Query will also work with Informix Dynamic Server 9.3. Note: JDBC Drivers other than those for DB2 can be used to view but not edit database data. Web Browser: To use DB2 Web Query, you must use a Web Browser that supports Java 1.1.x and has cookies and Java script enabled. Microsoft Internet Explorer version 5.5, with fixpack 2 is installed and higher is supported. Netscape Version 4.7 and higher is supported. Tip: Ensure that the current fix levels are applied for the JDBC driver, JDK, HTTPD, and IBM WebSphere. 4.0 INSTALLATION INSTRUCTIONS Install the selected updates using either PKZIP for zip file format or GUNZIP for tar file format. 4.1 To upgrade to DB2 Web Query Tool version 1.3 fixpak 1 when working with WebSphere Application Server Version 4.0.3: 1. Download the FixPak file from the FTP web site: ftp://ftp.software.ibm.com/software/dmtools/fixpaks/ 2. From the WebSphere Administrative Console, stop the DB2 Tools Server. Alternately you can stop the DB2 Tools Application server by running the following script: wqstop.bat on Windows platforms or wqstop.sh on UNIX platforms. 2. Delete the /servlet directory. 3. Decompress the source files that you downloaded for the latest version of DB2 Web Query Tool into your installRoot directory. (Either un-tar or unzip the files from within the installRoot directory.) Where duplicates exist, overwrite the existing files with the new files. Note: If you store .jar files in a location other than the installRoot directory, remember to copy the new .jar file to that location. 4. From the WebSphere Administrative Console, start the DB2 Tools Application Server. Alternately you can start the DB2 Tools Application server by running the following script: wqstart.bat on Windows platforms or wqstart.sh on UNIX platforms. 4.2 To upgrade to DB2 Web Query Tool version 1.3 fixpak 1 when working with WebSphere Application Server Version 3.5.5: 1. Download the FixPak file from the FTP web site: ftp://ftp.software.ibm.com/software/dmtools/fixpaks/ 2. Stop your Web server and your application server. 3. Delete the .jar file associated with the previous version of DB2 Web Query Tool. 4. Decompress the DB2 Web Query files into the installRoot directory on your machine. (Either un-tar or unzip the files from within the install root directory.) Where duplicates exist, overwrite the existing files with the new files. Note: If you store .jar files in a location other than the installRoot directory, remember to copy the new.jar file to that location. 5. Ensure that IBM WebSphere and DB2 fully installed, configured, and running. 6. Ensure that the Xerces, Xalan, and SOAP support jar files must be made available to the CWQ and the Application Server. These files have been included in the installRoot/servlet directory. 7. Stop the WebSphere Administrative Console and the Administration client service if they are started. 8. Navigate to the following file and open it: WebSphere\AppServer\bin\admin.config 9. Find com.ibm.ejs.sm.adminserver.classpath in admin.config. Append the following to the front of com.ibm.ejs.sm.adminserver.classpath: /servlet/xercesImpl.jar; /servlet/xml-apis.jar;/servlet/xalan.jar; Note: If you are working in Windows, the path to the install root must use the following syntax: \:/ For further illustration, see the example below. For example in Windows: e\:/ibm/CWQ/servlet/xercesImpl.jar;e\:/ibm/CWQ/servlet /xml-apis.jar;e\:/ibm/CWQ/servlet/xalan.jar; 10. Restart the administration client and Administrative Console. 11. Create a table called manager in any database with DB2 Web Query as the owner. Use the following syntax: CREATE TABLE WQ.manager ( cwqName VARCHAR (40) NOT NULL, catalog VARCHAR (40), PRIMARY KEY (cwqName) ) 12. Navigate to the installRoot on the machine that is running CWQ. For example: CWQ\conf\multiplatform\win\was35x 13. Edit the wqenvset.bat file. In wqenvset.bat, change the following variable values as appropriate for your environment: - wqt_wasRoot - The directory where WebSphere Application server has been installed. - wqt_installRoot - The directory where Web Query is installed. - wqt_nodeName - The name of the WebSphere node that needs to be configured. This variable is case sensitive. - wqt_rootURI - the prefix of the URL that will be used to access DB2 Web Query. 14. Run wqinstall.bat. 15. Run wqstart.bat. 16. Open the WebSphere Administrative Console. There will now be a "DB2 Tools Server" under Nodes Note: If the "DB2 Tools Server" is not visible, close the console and start it again. 17. Expand DB2 Tools Server under the Node Name. 18. Click ejbContainer on Administrative Console navigation tree. 19. Click the DataSource tab. 20. In the Userid box, type the User ID that is used to access the WQ.manager table that you created in the first step. 21. In the Password box, type the password that is used to access the WQ.manager table that you created in the first step. 22. Click Apply. 23. Click jdbc/cwqManagerDB on Administration Console navigation tree. Ensure the Driver that it is attached to is a valid DB2 Driver - if it is not, create a new driver and attach jdbc/cwqManagerDB to it (the steps to create a new driver are below). It should also be attached to the database that WQ.manager is under. To create a new jdbc driver: a. Choose Console --> Tasks --> Create Data Source b. Create and Install a new JDBC driver. c. Name your newly created JDBC driver. d. From the drop-down list, select a class name or type a class name in the Class Name field. typically COM.ibm.db2.jdbc.app.DB2Driver for DB2 on Windows - this one is not in the list) Note these are case sensetive. e. Select Node. f. Specify the loacation of the db2 driver's file (typically db2java.zip even though it may ask for a .jar file) g. Type a data source name in the Data Source Name field h. Type the name of the database where the WQ.manager table is located, in the Database name field. i. Click Finish. 24. Open the DB2 Web Query configuration Utility by accessing the following URL: http://server/DB2Tools/WebQuery/Configure The initial user id is: cwq. The initial password is: cwq 25. On the Configuration screen, change the initialContextfactory parameter to "com.ibm.ejs.ns.jndi.CNInitialContextFactory" 26. In the Configuration utility, specify the DB2 Web Query initial Parameters. (For more information on initial parameters, see the Parameter List in the DB2 Web Query User's Guide.) 27. Check for Service updates. See section 3.0. 28. Configure DB2 Web Query. See Section 4.0 29. You can now login to DB2 Web Query. 5 .0 CORRECTIONS TO DOCUMENTATION To obtain the latest documentation updates refer to the Support Flashes category: http://www.ibm.com/software/data/db2imstools/support.html To obtain the latest refresh of DB2 Web Query Tool publications refer to: http://www.ibm.com/software/data/db2imstools/library.html 6.0 SERVICE For a complete and up-to-date source of DB2 Web Query Tool information, including information on issues discovered after this readme was published, go the to following websites: DB2 Web Query Tool Product: http://www.ibm.com/software/data/db2imstools/index.html DB2 Web Query Tool Publications: http://www.ibm.com/software/data/db2imstools/library.html DB2 Web Query Tool Online Support: http://www.ibm.com/software/data/db2imstools/index.html If you are not able to find your answer searching the listed URLs, call 1-800-237-5511 to speak to an IBM representative for assistance. 7.0 FUNCTIONALITY NOT SUPPORTED - SOAP Services. Query method generates an NoClassDefFoundError when running the selected query. If permissions for the requested object do not include execute, then the query object is returned. - When specifying Query Options, result names that contain DBSC characters will generate an exception. Results will not be returned due to an invalid file name. - Informix tables can not be edited with DB2 Table Editor through DB2 Web Query. 8.0 NOTICES This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other 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 10594-1785 U.S.A. For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country 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 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 publication 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 as your own risk. Licensees of this program who want 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 which has been exchanged, should contact: IBM Corporation J74/G4 555 Bailey Avenue San Jose, CA 95141-1003 U.S.A. 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 information 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 measurement 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. All IBM prices shown are IBM's suggested retail prices, are current and are subject to change without notice. Dealer prices may vary. This information is for planning purposes only. The information herein is subject to change before the products described become available. This information contains 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 contains sample application programs in source language, which illustrates 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. 8.1 Notices of other companies XMLParser.Java, AELfred, Version 1.1: AElfred, Version 1.1 Microstar's Java-Based XML Parser Copyright (c) 1997, 1998 by Microstar Software Ltd. Home page: http://www.microstar.com/XML/ Licensing Terms: "AElfred is free for both commercial and noncommercial use and redistribution, provided that Microstar's copyright and disclaimer are retained intact. You are free to modify AElfred for your own use and to redistribute AElfred with your modifications, provided that the modifications are clearly documented." Disclaimer: "This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of merchantability or fitness for a particular purpose. Please use it AT YOUR OWN RISK." Apache Xerces The Apache Software License, Version 1.1 Copyright(c) 1999-2000 The Apache Software Foundation. All rights reserved Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notices, this list of conditions, and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions, and the following disclaimer in the documentation and/or other materials provided with the distribution. 3. The end-user documentation included with the redistribution, if any, must include the following acknowledgment: "This product includes software developed by the Apache Software Foundation (http:/www.apache.org/)." alternatively, this acknowledgment must appear in the software itself, if and wherever such third-party acknowledgments appear. 4. The names "Xerces" and "Apache Software Foundation" must not be used to endorse or promote products derived from this software without prior written permission. For written permission, please contact apache@apache.org. 5. Products derived from this software may not be called "Apache", nor may "Apache" appear in their name, without prior written permission of the Apache Software Foundation. THIS SOFTWARE IS PROVIDED 'AS IS' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. This software consists of voluntary contributions made by many individuals on behalf of the Apache Software Foundation and was originally based on software copyright (c) 1999, International Business Machines, Inc., http://www.ibm.com. For more information on the Apached Software Foundation, please see http://ww.apache.org. Apache Xalan The Apache Software License, Version 1.1 Copyright(c) 1999 The Apache Software Foundation. All rights reserved Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: 1. Redistributions of source code must retain the above copyright notices, this list of conditions, and the following disclaimer. 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions, and the following disclaimer in the documentation and/or other materials provided with the distribution. 3. The end-user documentation included with the redistribution, if any, must include the following acknowledgment: "This product includes software developed by the Apache Software Foundation (http:/www.apache.org/)." alternatively, this acknowledgment must appear in the software itself, if and wherever such third-party acknowledgments appear. 4. The names "Xalan" and "Apache Software Foundation" must not be used to endorse or promote products derived from this software without prior written permission. For written permission, please contact apache@apache.org. 5. Products derived from this software may not be called "Apache", nor may "Apache" appear in their name, without prior written permission of the Apache Software Foundation. THIS SOFTWARE IS PROVIDED 'AS IS' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. This software consists of voluntary contributions made by many individuals on behalf of the Apache Software Foundation and was originally based on software copyright (c) 1999, Lotus Development Corporation., http://www.ibm.com. For more information on the Apache Software Foundation, please see http://ww.apache.org. Copyright(c) 2002 by Jason Hunter, jhunter@servlets.com All rights reserved. The source code, object code, and documentation in the com.oreilly.servlet package is copyright and owned by Jason Hunter. Feel free to use the com.oreilly.servlet package in the development of any noncommercial project. For this use you are granted a non-inclusive, non-tranferable limited license at no cost. (Yep, free.) If you are are interested in using the package to benefit a commercial project, you are granted the same license, provided that ever person on the development team for that project owns a copy of the book Java Servlet Programming (O'Reilly) in its most recent edition. The most recent edition is currently the 2nd Edition, available in association with Amaxon.com at http://www.amazon.com/exec/obidos/ASIN/0596000405/jasonhunter. Redistribution of the com.oreilly.servlet package is permitted provided that the following conditions are met: 1. You redistribute the package in object code form only (as Java. class files or a .jar file containing the .class files) and only as part of a product that uses the classes as part of its primary functionality. 2. You reproduce the above copyright notice, this list of conditions, and the following disclaimer in the documentation and/or other materials provided with the distribution. To clarify, you may use the com.oreilly servlet package to build new software and may distribute the package in object code form as part of this software. You may NOT distribute t he package as part of a software development kit, or other library, or development tool without consent of the copyright holder. Any modified form of the com.oreilly.servlet package is bound by these same restrictions. (I don't want multiple versions making the rounds.) Other sometimes cheaper license terms are available upon request; please write to jhunter@servlets.com for more information. Note that the com.oreilly.servlet package is provided "as is" and the author will not be liable for any damages suffered as a result of your use. (You won't sue me.) Furthermore, you understand the package comes without any technical support. You can always find the latest version of the com.oreilly.servlet package at http://servlets.com THIS SOFTWARE IS PROVIDED BY THE AUTHOR "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF ANY DATA OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. Thanks, Jason Hunter, jhunter@servlets.com 8.2 Trademarks and service marks. The following terms are trademarks or service marks of the IBM Corporation in the United States or other countries or both: DB2 IBM iSeries z/OS zSeries Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. In the United States or other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation 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, and service names may be trademarks or service marks of others. (C) Copyright IBM Corporation 2001, 2002. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.