IBM(R) DB2(R) Performance Expert for Multiplatforms, V1 R1 IBM(R) DB2(R) Performance Expert for Multiplatforms, V1 R1, Try & Buy IBM(R) DB2(R) Performance Expert for Multiplatforms, V1 R1, fixpack 5 IBM(R) DB2(R) Performance Expert for z/OS(R) and OS/390(R), V1 R1 DB2 PM for OS/390 - Workstation Online Monitor V7 DB2 PM for OS/390 - Workstation Online Monitor V6 DB2 Buffer Pool Analyzer for z/OS CONTENTS 1.0 ABOUT THIS README FILE 2.0 INSTALLATION MEDIA 2.1 Installing from CD-ROM 2.2 Installing from the Web 2.3 Installing the latest fixpack 2.4 How to get software to unpack compressed files 3.0 INSTALLATION INSTRUCTIONS 3.1 Performance Expert for Multiplatforms 4.0 KNOWN PROBLEMS AND RESTRICTIONS, HINTS AND TIPS 4.1 Performance Expert 4.2 Workstation Online Monitor 5.0 CUSTOMIZATION INSTRUCTIONS 6.0 SERVICE UPDATES 6.1 Added features 7.0 CORRECTIONS TO DOCUMENTATION 8.0 OTHER SOURCES OF INFORMATION 9.0 NOTICES 9.1 Trademarks and service marks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 Performance Expert for Multiplatforms, Version 1 Release 1, README file that contains information about installing IBM DB2 Performance Expert for Windows(R) and UNIX-based platforms. It refers to the installation of the program from CD-ROM or from the Web, and to the download of fixpacks. It also contains the latest information that is not documented in books or helps. In this README file, the following naming conventions apply: IBM DB2 Performance Expert for Multiplatforms is abbreviated to Performance Expert. When the name Performance Expert is used, DB2 Performance Monitor (DB2 PM) is included where applicable. 2.0 INSTALLATION MEDIA 2.1 INSTALLING FROM CD-ROM The CD-ROM contains compressed packages that are identified by the platform on which you install the code. The CD-ROM structure and size of the decompressed images are: ./README.TXT (this file) ./win README.TXT db2pe.install-on-win.exe client installation db2pesrv.install-on-win.exe server installation db2peagent.install-on-win.exe agent installation (db2pesrv-tab.install-on-win for try and buy) setup.exe main installation selection routine ./aix README.TXT db2pe.install-on-aix client installation db2pesrv.install-on-aix server installation db2peage.install-on-aix agent installation (db2pesrv-tab.install-on-aix for try and buy) ./sun README.TXT db2pe.install-on-solaris client installation db2pesrv.install-on-solaris server installation db2peage.install-on-solaris agent installation (db2pesrv-tab.install-on-solaris for try and buy) ./lnx README.TXT db2pe.install-on-lnx client installation db2pesrv.install-on-lnx server installation db2peage.install-on-lnx agent installation (db2pesrv-tab.install-on-lnx for try and buy) ./hpux README.TXT db2pe.install-on-hpux client installation db2pesrv.install-on-hpux server installation db2peage.install-on-hpux agent installation (db2pesrv-tab.install-on-hpux for try and buy) ./doc fpeinaxx.pdf Installation and Customization fpempaxx.pdf Monitoring Performance from the Workstation where xx denotes the version of the pdf file 2.2 INSTALLING FROM THE WEB If you install the latest version of Performance Expert from the Web, the program files are as follows depending on your operating system: IBM/DB2PerformanceExpert-5724-B92/ /AIX/CD_MASTER_PART_NUMBER.tar.gz README.TXT db2pe.install-on-aix client installation db2pesrv.install-on-aix server installation db2peage.install-on-aix agent installation /hpux/CD_MASTER_PART_NUMBER.tar.gz README.TXT db2pe.install-on-hpux client installation db2pesrv.install-on-hpux server installation db2peage.install-on-hpux agent installation /linux/CD_MASTER_PART_NUMBER.tar.gz README.TXT db2pe.install-on-linux client installation db2pesrv.install-on-linux server installation db2peage.install-on-linux agent installation /solaris/CD_MASTER_PART_NUMBER.tar.gz README.TXT db2pe.install-on-solaris client installation db2pesrv.install-on-solaris server installation db2peage.install-on-solaris agent installation /win/CD_MASTER_PART_NUMBER.zip README.TXT db2pe.install-on-win.exe client installation db2pesrv.install-on-win.exe server installation db2peagent.install-on-win.exe agent installation 2.3 INSTALLING THE LATEST FIXPACK To install a fixpack, go to the following Web site: ftp://ftp.software.ibm.com/software/data/db2imstools/db2tools/ db2performanceexpert/fixpak5 Select the directory according to your operating system. /win README.TXT db2pe.fp5.win.zip /sun README.TXT db2pe.fp5.solaris.tar.gz /lnx README.TXT db2pe.fp5.linux.tar.gz /hpux README.TXT db2pe.fp5.hpux.tar.gz /aix README.TXT db2pe.fp5.aix.tar.gz See also Section 6.0 SERVICE UPDATES. 2.4 HOW TO GET SOFTWARE TO UNPACK THE COMPRESSED FILES Most Window-based packages are compressed with PKZIP. Most UNIX-based packages are compressed with GUNZIP. o You can download PKZIP from http://www.pkware/com/downloads/ o You can download GUNZIP from http://www.gzip.org/ 3.0 INSTALLATION INSTRUCTIONS NOTE CONCERNING THE TRY AND BUY VERSION: The evaluation code allows access to data on your DB2 subsystems on Windows and UNIX-based operating systems. After 60 days, you must purchase a license to continue to use the code. 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. 3.1 PERFORMANCE EXPERT FOR MULTIPLATFORMS To install Performance Expert for Windows and UNIX-based platforms: 1. Change your current directory to the CD-ROM directory for the platform of your choice. If you install from a program CD, continue with step 4. 2. Download the package into a temporary directory of your choice. Ensure that you have at least 150 MB of free space for the unzipped and decompressed program. 3. Decompress the package of files for the platform of your choice if necessary. 4. To install the program, refer to the README file in the package for the corresponding instructions. 5. Download the documentation for the product from the following Web site: http://www.ibm.com/software/data/db2imstools/library.html. 6. Check for fixpacks that are to be installed before you start the program. The Web site is: http://www.ibm.com/software/data/db2imstools/support/ fixpaks-mp.html See also Section 6.0 SERVICE UPDATES. 4.0 KNOWN PROBLEMS AND RESTRICTIONS, HINTS AND TIPS 4.1 Performance Expert 4.1.1 Connectivity problems between DB2 client and server of DB2 Version 8 In case of connectivity problems between the DB2 client and the server of DB2 Version 8, refer to "IBM DB2 Connectivity Supplement Version 8". 4.1.2 Performance Expert on Linux for z/OS Performance Expert does not yet run on Linux for z/OS. This problem will be solved with the next fixpack. 4.1.3 Performance Expert Server on Linux for Intel If you run the Performance Expert Server on Linux for Intel, you must not change the properties that are set for the DB2 instance on the Performance Expert Client. 4.1.4 DB2 Version 7.2 fixpack 7 for Unix If you install this fixpack, you must run Performance Expert Client on your local machine. Remote access causes a DB2 problem. 4.1.5 SQL activity report cannot be started If this problem occurs, you must update the corresponding configuration parameter directly in the DB2PM.PARAMETER table by using the following SQL UPDATE command: update db2pm.parameter set pa_flagvalue='Y' where pa_key='PERFORMANCEWAREHOUSE' The name of the parameter refers to the 'PA_KEY' column in the DB2 table. The data type is flag and refers to the 'PA_FLAGVALUE' column in the DB2 table. 4.2 Workstation Online Monitor 4.2.1 Launching Netscape as HTML browser Launching an HTML browser from the client can fail. In this case, start the browser separately. 4.2.2 Exception processing on the host not yet available Periodic exception processing: Importing threshold sets is currently not supported. Therefore, you cannot use exception profiling on the host. 4.2.3 Restarting the client if the server is restarted When the server component of the client is restarted, the client might not reconnect. In this case, log off manually from the monitored DB2 system, then log on again. In some cases, you must restart the client. 4.2.4 Restarting the client if the DB2 instance is restarted When the DB2 instance to be monitored is restarted, the client might not reconnect. In this case, you must restart the client. 4.2.5 Error when cancelling an SQL activity trace that has the status 'Waiting' If you start an SQL activity trace and press Cancel or close the window while the collection process has the status 'Waiting', the following error might occur: Error occurred: !!! DBE_Exception --- error : -438 sqlstate : PM003 sqlmsg : [IBM][CLI Driver][DB2/NT] SQL0438N Application raised error with diagnostic text: "P_UPD05: Process has running process executions". SQLSTATE=PM003 detail : update process database entity ... parameter[1]: 'P_FACADE_1032787943332' parameter[2]: NULL parameter[3]: NULL parameter[4]: 'IN DEFINITION' parameter[5]: NULL parameter[6]: 1412 parameter[7]: 1413 --- DBE_Exception !!! In this case, the collection of trace data was started but could not be stopped. Therefore, you must stop the process manually by using the following DB2 commands: 1. db2 connect to db2pm user ... 2. db2 "update db2pm.processlog set PL_STATUS='CANCEL' where PL_P_ID=" 3. db2 "select PL_STATUS from db2pm.processlog where PL_P_ID=" 4. if PL_STATUS is 'CANCELED': db2 "update db2pm.process set P_STATUS='IN DEFINITION' where P_ID=" 5. db2 "delete from db2pm.processgroup where PG_ID=" 4.2.6 Release of database connections for SQL activity traces 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 exit Performance Expert. 5.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. 6.0 SERVICE UPDATES For fixpacks to be installed before using the program, refer to the following Web site: http://www.ibm.com/software/data/db2imstools/support/fixpaks-mp.html 6.1 Added features o Performance Expert Agent Performance Expert Agent monitors DB2 Connect gateways or DB2 UDB gateways. It collects application-related and system-related data and stores the collected data in a database on a Performance Expert Server. For more information about Performance Expert Agent, 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 o DB2 Version 8 toleration 7.0 CORRECTIONS TO DOCUMENTATION To get the latest updates on documentation, refer to: http://www.ibm.com/software/data/db2imstools/support.html To get the latest Performance Expert publications, refer to: http://www.ibm.com/software/data/db2imstools/library.html 8.0 OTHER SOURCES OF INFORMATION For complete and up-to-date information about Performance Expert, including information on issues that are not contained in this README file, refer to the following Web sites: For Performance Expert: http://www.ibm.com/software/data/db2imstools/index.html For Publications regarding Performance Expert: http://www.ibm.com/software/data/db2imstools/library.html For online Support: http://www.ibm.com/software/data/db2imstools/support.html If you cannot find an answer by searching these Web sites, call 1-800-237-5511 to speak to an IBM representative for assistance. 9.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. 7.1 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: AS/400 DB2 DB2 Connect DB2 Universal Database IBM MVS/ESA OS/2 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 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.