IBM(R) DB2(R) Performance Expert for Multiplatforms, V1 R1 IBM DB2 Performance Expert for Workgroups, V1 R1 DB2 Performance Monitor for z/OS - Workstation Online Monitor V7 and V6 DB2 Buffer Pool Analyzer for z/OS, V1 R2 Fix Pack 8, README CONTENTS 1.0 ABOUT THIS README FILE 1.1 Evaluation code 1.2 Corrected known problems 1.3 Known problems and workarounds 2.0 PREREQUISITES 2.1 Hardware requirements 2.2 Software requirements 3.0 INSTALLATION INSTRUCTIONS 3.1 General notes 3.2 UNIX(TM)-specific installation information 3.2.1 Fix pack installation for Performance Server 3.2.2 Using Extended Shared Memory on AIX 32-bit systems 3.2.3 Configuration of Performance Expert Server 3.3 Windows-specific installation information 3.3.1 Fix pack installation for Performance Server 3.3.2 Fix pack installation for Performance Server Agent 4.0 CUSTOMIZATION INSTRUCTIONS 4.1 Performance Expert Server on Red Hat Linux 5.0 RESTRICTIONS 5.1 Performance Expert 5.2 Workstation Online Monitor 5.3 Japanese version of Performance Expert 6.0 HOW TO GET HELP 7.0 NOTICES 7.1 Use of the evaluation program 7.2 Trademarks and service marks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 Performance Expert, Version 1 Release 1, Fix Pack 8, README file. This README file contains information about installing IBM DB2 Performance Expert. It is the most current README file as of 09/30/2003. In this README file, the following naming conventions apply: IBM DB2 Performance Expert for Multiplatforms and IBM DB2 Performance Expert for Workgroups are abbreviated to Performance Expert. When the name Performance Expert is used, DB2 Performance Monitor (DB2 PM) is included where applicable. 1.1 Evaluation code If you use evaluation code, the evaluation code enables you to try this product for a period of 60 days. After 60 days, you must purchase a license to continue to use the product. When you purchase the product, the license is enforced based upon the platform on which you run Performance Expert. Read NOTICES Section 7.1, Use of the evaluation program, and the License Agreement provided with your evaluation copy of the program. 1.2 Corrected known problems 1.2.1 Performance Expert for Multiplatforms - Fixed: If Performance Expert was installed on DB2 V7 Fix Pack 7 or DB2 V8 Fix Pack 2, sql0266n occurred if SQL Activity Trace, buffer pool analysis, or any process using the event monitor were started. - Fixed: Sometimes, the pestop command caused DB2 to hang, and you had to enter the DB2_kill command. - Fixed: The setup program of Performance Expert set several database manager level parameters, for example, MON_HEAP_SZ, JAVA_HEAP_SZ, without checking if existing settings were already of this size or higher. You are now asked if you want to change the settings. - Fixed: If DB2 returned 1000 after the jar file registration completed successfully, Performance Expert reported this as an error. - Fixed: If you installed Performance Expert on AIX 32-bit systems, the configuration script set the DB2 configuration parameter EXTSHM=ON. On highly loaded systems this might have caused paging I/Os. Performance Expert now provides the option to attach local databases like remote databases. This avoids the setting of EXTSHM=ON. For a detailed description of how to use Extended Shared Memory, refer to 3.2.2. Using Extended Shared Memory on AIX 32-bit systems. - Fixed: Because the length of 'SERVICELEVEL' was changed in DB2 V8 Fix Pack 1, the instance information within Statistic Details remained empty. - Fixed: Sometimes, an internal error occurred when SQL Activity was selected. 1.2.2 Performance Expert for z/OS - Fixed: A scheduled trace started 87 minutes ahead of the time set. - Fixed: Sorting within the Thread Summary window caused an internal error. - Fixed: If a member of a data sharing group did not respond, the message DGOK1407 was diplayed for the Thread Summary window. - Fixed: If a data sharing group was involved, and if you switched between different views by using one of the 'View data for' options, the contents of Statistic Details were unpredictable. - Fixed: If you used the processing event exception function of Performance Expert, the reports contained wrong timestamps. - Fixed: In the Dynamic Statement Cache Details window, the value for Elapsed Time was identical to the value of Elapsed Time per execution. 1.3 Known problems and workarounds -Hang situation in DB2 Performance Expert when using DB2 V8 Fix Pack 3. If DB2 Performance Expert for MP (PE) is used to monitor instances based on DB2 V8 FP3 and Deadlock Exception Processing is activated then this causes a hang situation in DB2 PE, which will be experienced in the GUI. The Deadlock Exception Processing feature starts a deadlock event monitor on the DB2 server, which has a problem in DB2 V8 FP3. The deadlock event monitor problem in DB2 V8 FP 3 causes the DB2 instance to hang. The instance cannot be stopped using db2stop. It must be stopped using e.g. db2_kill. The problem is addressed in DB2 APAR LI70239 and will be fixed in DB2 V8 FP4. Workaround: Do not use the Deadlock Exception Processing feature of PE when using DB2 V8 FP 3. -DB2 Performance Expert server configuration problems on zLinux. After the installation of the PE server the script db2pesrv-config must be called as root to configure the PE server. This script calls the script peregjar.sh which registers Java Stored Procedures in the DB2 instance. The peregjar.sh script might fail if the JDK_PATH variable in the database manager configuration is not set correctly yet. On screen you will see a warning that you have to restart the DB2 instance and call the peregjar.sh script again as DB2 instance owner. If this execution fails again then links to Java libraries might be missing in /usr/lib. Go to the /usr/lib directory and check whether the following libraries are available there. libjava.so libhpi.so libjvm.so If there are not there then please issue the following commands as root: # ln -s /usr/IBMJava2-131/jre/bin/libjava.so /usr/lib/ # ln -s /usr/IBMJava2-131/jre/bin/libhpi.so /usr/lib/ # ln -s /usr/IBMJava2-131/jre/bin/classic/libjvm.so /usr/lib/ # ldconfig You might also find in the db2diag.log file an entry like the following indicating that links to Java libraries are missing. 2003-09-18-12.14.22.945414 Instance:db2in81 Node:000 PID:15418(db2fmp) TID:1024 Appid:none oper system services sqloLoadModule Probe:190 error loading module: libdb2jext.so errno = 9 0x00418C90 : 6C69 626A 6176 612E 736F 3A20 6361 6E6E libjava.so: cann 0x00418CA0 : 6F74 206F 7065 6E20 7368 6172 6564 206F ot open shared o 0x00418CB0 : 626A 6563 7420 6669 6C65 3A20 4E6F 2073 bject file: No s 0x00418CC0 : 7563 6820 6669 6C65 206F 7220 6469 7265 uch file or dire 0x00418CD0 : 6374 6F72 79 ctory - If you issue the command DB2STOP FORCE or the command DB2 FORCE APPLICATIONS ALL on a system other than z/OS on which Performance Expert Server is installed, do the following: 1. Stop Performance Expert Server. 2. Do one of the following: - If you issued the command DB2STOP FORCE, restart DB2 by using the DB2START command. - If you issued the command DB2 FORCE APPLICATIONS ALL, wait until all applications are finished. 3. Restart Performance Expert Server. - Problem: On Windows, the following error message might appear during installation and configuration of a Performance Expert Server: "Error accessing the configuration file for database configuration (\bin\pe_temp.log). Without this configuration the Performance Expert Server may run inefficient. Error: -1." Workaround: To ensure that Performance Expert Server runs efficiently, do the following after the installation and configuration is complete: 1. Open a DB2 CLP window. 2. Enter the following commands: DB2 CONNECT TO DB2PM DB2 UPDATE DB2PM.VERSION SET V_VALUE='U030-V110' WHERE V_FIELD LIKE 'DB2PM CODE%' DB2 CONNECT RESET 3. Stop and start Performance Expert Server. This causes Performance Expert Server to perform a database migration and optimization. - Problem: On Windows, the configuration of Performance Expert Server, or Performance Expert Server after the first start, or Performance Warehouse might hang because of a hanging DB2 process "db2syscs". Workaround: Reboot and redo the abended action. - On zLinux, the following message appears: "Errors occurred during the installation. - jvm "jvm" is not defined." This implicates that no Uninstall directory is created. If you remove the program, you must remove the program files and the DB2PM database manually. - If you have Windows NT and DB2 V8 installed, Performance Expert Server does not run. - Problem: If Performance Expert Server runs on UNIX-based operating systems on which DB2 V7 Enterprise-Extended Edition (EEE) is installed, the 'Exception processing' function of Performance Expert might damage DB2 processes when you activate it. You must then stop DB2 by using the command db2_kill and restart it. Workaround: Do not activate the 'Exception processing' function in this environment. - In a DB2 EEE environment, functions based on event monitoring, such as SQL activity, exception processing, buffer pool analysis, and Performance Warehouse work only in a single partition environment for Fix Pack 8. - Problem: Rarely, Performance Expert Server abends after you start a Performance Warehouse process for the first time. A message is displayed that Performance Expert Server is not running. Workaround: Restart Performance Expert Server. - Problem: If a DB2 V7 client connects to a DB2 V8 server, the following error message might occur: FRAMEWORK : SQLError : [IBM][CLI Driver][DB2/6000] SQL0551N "" does not have the privilege to perform operation "EXECUTE" on object "NULLID.SQLLF000". SQLSTATE=42501 Workaround: Enter the following commands on the DB2 V8 server db2 connect to db2pm user using db2 bind @db2cli.lst blocking all grant public db2 grant execute on package nullid.sqllf000 to public db2 grant execute on package nullid.sqllf200 to public db2 grant execute on package nullid.sqllf400 to public For more information on this problem, refer to the DCF document (Technote) containing the following subject: "CLI Packages in DB2 V8.1". This document explains the changes in V8.1 regarding the CLI bind files and packages. - Problem: A Performance Expert Client installed on DB2 V7 cannot connect to a Performance Expert Server installed on a 64-bit DB2 V8. Workaround: Use a Performance Expert Client that is installed on DB2 V8. For more information, refer to the DB2 connectivity matrix, which is located on the following Web site: http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support /v8infocenter.d2w/report?target=mainFrame&fn=r0009731.htm - Problem: When running an SQL Activity Tracing report from the Application Details window on Windows 2000, the report might fail with the message 'SQL086N A default table space could not be found with a page size of at least 4096 that authorization ID DB2PESERVER is authorized to use.' Workaround: In DB2, manually grant the use of this table space to the user DB2PESERVER. - If a DB2 V8 client cannot connect to a Performance Expert Server, enter the following bind commands on the DB2 V8 client: db2 connect to db2 bind @db2ubind.lst blocking all grant public 2.0 PREREQUISITES Performance Expert has hardware and software requirements. 2.1 Hardware requirements Performance Expert for Multiplatforms has the following hardware requirements: - Memory and disk space sufficient to fulfill DB2 requirements. If you use Buffer Pool Analyzer for z/OS, you might need the maximum memory. - A minimum of 150 MB of free disk space. - Additional space for user data. This varies depending on the size of your databases and the amount of activity your system encounters. 2.2 Software requirements To use Performance Expert for Multiplatforms, you must have IBM DB2 V7 Fix Pack 8 or later. Do not use DB2 V7 Fix Pack 7 because it might cause a hang of Performance Expert Client while waiting for a response of Performance Expert Server. On UNIX-based systems, Fix Pack 7 also forced users to locally connect to a Performance Expert Server. 3.0 INSTALLATION INSTRUCTIONS 3.1 General notes 1. If you plan to install Performance Expert Server for a DB2 UDB EEE configuration, you have to install it only once. Select a partition of your choice and install it there. Note, however, that for Fix Pack 7 the functions based on event monitoring work only in a single partition environment. See also section 1.3 Known problems and workarounds. 2. Because you can install Performance Expert without installing DB2, consider the following: If DB2 is not installed, functions of Performance Expert regarding a multiplatform server or a Performance Warehouse cause an error. To enable these functions after installing the correct version of DB2, you must run the setup of Performance Expert Client again by using the Repair option. 3. Before you start installing the program, read "IBM DB2 Performance Expert for z/OS and Multiplatforms, Version 1 Release 1, Installation and Customization", SC27-1646. You can find this documentation also on the following Web site: http://www.ibm.com/software/data/db2imstools/library.html 4. Close all Performance Expert Agents and connections to Performance Expert Agent before installing Performance Expert Server. 5. Before you install Performance Expert Server, ensure that all DB2 instances to be monitored are started. 6. What to consider when you have DB2 Version 8 installed: - If Performance Expert Server is installed on a workstation that runs under DB2 Version 8, Performance Expert Client must be installed on a workstation that runs at least under DB2 Version 7 Fix Pack 8. - Clients running under DB2 Version 8 can connect only to servers running under DB2 Version 8. 7. To use Performance Expert Client with a Performance Expert Server for z/OS Version 1.1, APAR PQ68678 must be applied on the server to ensure correct results. 3.2 UNIX-specific installation information 3.2.1 Fix pack installation for Performance Server Before you can install a fix pack, the base package of Performance Expert Server must be installed. Do not remove the installed version of Performance Expert. Instead, install the fix pack in a new directory. To install the fix pack: 1. Ensure that the fix pack installation file db2pesrv.fpx.install-on-system is executable, where x denotes the version of the fix pack, and system denotes your operating system, for example, db2persrv.fp8.install-on-aix. 2. Invoke the fix pack installation file. 3. When you are asked for the installation path, select, for example, /opt/IBM/db2pesrv.fpx/V1.1, where x denotes the version of the fix pack. 4. After the installation of the fix pack completes successfully, you must copy the file nodelock from the directory /opt/IBM/db2persrv/V1.1/bin/nodelock to /opt/IBM/db2persrv.fpx/V1.1/bin/nodelock, where x denotes the version of the fix pack. 5. If InstallShield does not remove Performance Expert completely, you must drop the DB2PM database for each monitored instance by using the following command: db2 drop db db2pm In addition, you might have to remove old temporary files of Performance Expert Server by using the following command: rm -fr /var/db2pe/ where db2inst denotes the name of the DB2 instance. 6. Run the following configuration script for each DB2 instance that you want to monitor: /opt/IBM/db2persrv.fpx/V1.1/adm/db2pesrv-config -i db2inst1 where x denotes the version of your fix pack and db2inst1 denotes the name of the instance, where you want to run the Performance Expert Server. The output is logged in the file /tmp/db2pesrv-config.db2inst1.log 3.2.2 Using Extended Shared Memory on AIX 32-bit systems During the installation you can now choose, if Extended Shared Memory is to be used. If it is to be used, the environment variable EXTSHM is set to ON. The database is then started with this setting and can work with Extended Shared Memory. Important: Exception Processing requires that EXTSHM is set to ON to avoid the loss of data. On heavily loaded systems, however, this causes additional I/Os. Therefore, we provide the following way to have EXTSHM set to OFF but without any loss of data for Exception Processing. If Extended Shared Memory is not to be used, do the following for all databases for which you want to get Exception Processing data: 1. During the installation, set the EXTSHM parameter to NO. When the configuration script shows the parameters for the DB2 instance, check the setting for EXTSHM and change it if necessary: Set EXTSHM=ON? (yes or no): [yes] - enter NO. 2. Catalog the local node, like a remote one, in the following way: a. Logon as DB2 instance owner. b. Enter the following command: db2 "catalog tcpip node remote 127.0.0.1 server " where: Denotes the alias for the local node to be cataloged. Must be identical to the database manager parameter SVCENAME. 3. Catalog each database for which you want to get Exception Processing in the following way: a. Logon as DB2 instance owner. b. Enter the following commands: db2 "catalog db as at node authentication server" where: Denotes the name of the local node, as described in 2. Denotes the local name of the database to be monitored. Denotes the alias for the local database but must not be identical to the name of the database. 4. Start Performance Expert Server by using the additional parameter userid: ./pestart -n -u where: -n Denotes the name of the local node, as described in 2. -u Denotes the user ID that controls actions of Performance Expert Server regarding DB2. You should use the user ID of the instance owner. You are prompted for the password. 3.2.3 Configuration of Performance Expert Server To configure Performance Expert Server, perform these steps for each instance that you want to monitor: 1. Run the configuration script db2pesrv-config -i db2inst1 where 'db2inst1' is the DB2 instance user under which Performance Expert Server runs. You are asked to enter several parameters. These parameters determine: - Where the DB2PM database is stored. - The group that has access to this database. - Where trace and log files are stored. - Your Java Runtime environment for DB2. This Java Runtime environment is set in the DB2 environment variable JDK11_PATH on DB2 V7 or JDK_PATH on DB2 V8. 2. If DB2 environment variables are changed while you run this script, you are asked to invoke the following commands. These commands activate the DB2 environment variables and register the file fpesp.jar with your new Java Runtime environment setting: db2stop db2start /var/db2pe/db2inst1/peregjar.sh where '/var/db2pe' is your DB2PE working directory as defined during the configuration. The script /var/db2pe/db2inst1/peregjar.sh tries to register the file fpesp.jar with your new Java Runtime environment setting. 3.3 Windows-specific installation information While installing the base or a fix pack of Performance Expert on Windows, the message 'Cannot find file layout.bin. Please insert disk ...' might appear. If this message occurs, do one of the following: - Restart Windows in the following way: Before you log on to the system, press the Shift key and keep it pressed while you log on. The system then starts without the autostart options. Then retry installing the base or the fix pack. - Delete all files in the InstallShield directory. On Windows, for example, this directory is located in: C:\Program Files\Common Files\InstallShield 3.3.1 Fix pack installation for Performance Server Before you can install a fix pack, the base package of Performance Expert Server must be installed. If it is not installed, you get the error message 'Could not start the DB2 Performance Expert Server (DB2) service on local computer.' Usually, the installation program performs the update automatically. If not, use the Repair option. This option repairs only program files of the Performance Expert Server installation. To repair the DB2PM database, reinstall Performance Expert Server. 3.3.2 Fix pack installation for Performance Server Agent Usually, the installation program performs the update automatically. If not, use the Repair option. 4.0 CUSTOMIZATION INSTRUCTIONS For complete instructions on how to customize and use Performance Expert, refer to "IBM DB2 Performance Expert for z/OS and Multiplatforms, Version 1 Release 1, Installation and Customization". You can find this document on the following Web site: http://www.ibm.com/software/data/db2imstools/library.html If you install this image from CD-ROM, the documentation is located in the /doc directory. The User's Guide on the Web can contain updates to the publication on CD-ROM. 4.1 Performance Expert Server on Red Hat Linux Setting kernel parameters: To run DB2, you must set kernel parameters in the following way: 1. Display the kernel parameters by entering the following command: ipcs -l 2. Add the following lines to the file /etc/sysctl.conf: kernel.msgmni = 512 kernel.sem=250 128000 32 512 3. Activate the kernel parameters by entering the following command: sysctl -p 5.0 RESTRICTIONS 5.1 Performance Expert - Performance Expert Server needs the following Database Manager Configuration settings to deliver all required values to Performance Expert Client: JAVA_HEAP_SZ 2048 MON_HEAP_SZ 512 ASLHEAPSZ 30 QUERY_HEAP_SZ 2000 The configuration script checks how these parameters are set. If they are set to a value lower than the required value, the minimum values are set automatically. If you reset these parameters to a value lower than the required value, the results on Performance Expert Client might be incomplete or even missing. - If you install Performance Expert Client on DB2 V8 without any fix pack, you cannot connect to a Performance Expert Server that is installed on DB2 V7. - If you want to access a Performance Expert Server that is installed on a UNIX-based 64-bit instance, you must catalog the correspondent database alias as a DCS database. The following example shows how you can access the DB2PM database on Performance Expert Server by using the alias DB2PM64. db2 "catalog tcpip node PESRV64 remote 9.888.777.666 server 50064" db2 "catalog dcs database DCSDB2PM as DB2PM" db2 "catalog database DCSDB2PM as DB2PM64 at node PESRV64 authentication DCS" - If you install Performance Expert Server on a machine on which DB2 Version 8 for Intel Linux is installed, you must install Performance Expert Client also on a machine on which DB2 Version 8 is installed. Access with a Performance Expert Client from a machine on which DB2 Version 7 is installed causes Performance Expert Client to stop. - If you use Performance Expert for DB2 Version 8, and if there are connectivity problems between the DB2 client and server of this version, refer to "IBM DB2 Connectivity Supplement Version 8". - You might need to increase limits to handle too many database connections on Performance Expert. Event exception processing is, by default, activated by Performance Expert Server for all databases of the monitored DB2 instance. Thus, an additional connection is established for each database. It might be necessary to increase either or both of the following: - The maximum number of concurrent applications (maxappls) that can be connected to a database. - The maximum number of database manager agents (maxagents) available at any time to accept application requests. Alternatively, you can deactivate event exception processing at Performance Expert Server and thus reduce the number of connections by switching it off within the Properties of the DB2 instance of the Performance Expert Client. 5.2 Workstation Online Monitor - The following field contents might appear if a value is not available: N/C Not Calculated (If a division by zero would have happened) N/P Not Present (If DB2 did not deliver a value for the corresponding parameter) N/A Not Applicable (If this value does not make sense within the current context) - Launching Netscape as your HTML browser from the client can fail. In this case, start the browser separately. - Threshold sets cannot be imported or exported in periodic exception processing, threshold sets cannot be imported or exported. Therefore, you cannot use exception profiling on the host. - For Performance Expert Server for Multiplatforms, Periodic Exception Processing is not yet available. Therefore, ignore the corresponding menus, which are already enabled. - When you press the interval button in the Statistics Details window, an internal error might occur and the following message is displayed: "...This snapshot store was released before..." Ignore this message, click Close, and then click Refresh. Interval processing will work. - When the Data Collector or Performance Expert Server is restarted, the client might not reconnect. In this case, log off manually from the monitored DB2 subsystems or DB2 instances, then log on again. In some cases, you must restart the client. - When SQL activity traces are generated, several database connections are used. Note that these connections are not released after the SQL activity trace is generated so that they can be reused for further tracing. They are only released when you log off from the DB2 instance. 5.3 Japanese version of Performance Expert - You cannot use double-byte character set (DBCS) entries for Performance Warehouse functions and for the System Health window of the Workstation Online Monitor. - Performance Warehouse does not work with databases defined with CCSID 1390. It works, however, with databases defined with CCSID 500. 6.0 HOW TO GET HELP For complete and up-to-date source of Performance Expert information, including information on issues discovered after this README was published, go to the following Web site: Performance Expert Online Support: http://www.ibm.com/software/data/db2imstools/support.html If you are not able to find your answer searching the listed URL, call 1-800-IBM-SERV to speak to an IBM representative for assistance. For fix packs to be installed before using the program, refer to the following Web site: http://www.ibm.com/software/data/db2imstools/support/fixpaks.html 7.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 character set (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 at 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. COPYRIGHT LICENSE: This information contains 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. 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 IBM's application programming interfaces. 7.1 Use of the evaluation program If you are using an evaluation copy of the program, the following terms apply: This program contains a disabling device that will prevent it from being used upon expiration of this license. You will not tamper with this disabling device or program. You should take precautions to avoid any loss of data that might result when the program can no longer be used. See the License Agreement for a complete explanation of the terms that apply. 7.2 Trademarks and service marks The following terms are trademarks or service marks of the IBM Corporation in the United States, other countries, or both: DB2 DB2 Universal Database IBM OS/390 z/OS 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. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Other company, product and service names may be trademarks or service marks of others. (C) Copyright IBM Corporation 2003. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.