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, FixPak 5a 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 FixPak 2.4 How to get software to unpack compressed files 3.0 INSTALLATION INSTRUCTIONS 3.1 Performance Expert for Multiplatforms 3.2 Performance Expert for UNIX-based operating systems 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 Fixed problems 6.2 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 FixPaks. 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 FixPak FixPaks contain latest product updates and enhancements. To install a FixPak, go to the following Web site: http://www.ibm.com/software/data/db2imstools/support/ fixpaks.html 2.3.1 Installing a FixPak for Performance Server on Windows Note: Before you can install a FixPak, 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. Note that this option repairs only program files of the Performance Expert Server installation. To repair the DB2PM database, reinstall Performance Expert Server. 2.3.2 Installing a FixPak for Performance Server on UNIX-based operating systems Notes: 1. Before you can install a FixPak, the base package of Performance Expert Server must be installed. 2. Do not remove the installed version of Performance Expert. Instead, install the FixPak in a new directory. To install the FixPak: 1. Ensure that the FixPak installation file db2pesrv.fpx.install-on-system is executable, where x denotes the version of the FixPak, and system denotes your operating system, for example, db2persrv.fp2.install-on-aix. 2. Invoke the FixPak 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 FixPak. 4. After the installation of the FixPak 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 FixPak. 5. For each monitored instance, you might drop the DB2PM database by using the following command: db2 drop db db2pm Then, you might 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: /opt/IBM/db2persrv.fpx/V1.1/adm/db2pesrv-config where x denotes the version of your FixPak. The output is logged in the file /tmp/db2pesrv-config.log. 2.3.3 Installing a FixPak for Performance Server Agent on Windows Usually, the installation program performs the update automatically. If not, use the Repair option. 2.4 HOW TO GET SOFTWARE TO UNPACK THE COMPRESSED FILES Most Windows-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 IMPORTANT NOTES: 1. Before you start installing the program, read "IBM DB2 Performance Expert for z/OS and Multiplatforms, Version 1 Release 1, Installation and Customization". 2. Ensure that all DB2 instances to be monitored are started. 3. The evaluation code of the try-and-buy version 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 operating systems: 1. Change your current directory to the CD-ROM directory for the operating system 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 operating system of your choice if necessary. 4. To install the program, refer to the corresponding installation instructions in 'IBM DB2 Performance Expert for z/OS and Multiplatforms, Version 1 Release 1, Installation and Customization'. You can download the documentation from the following Web site: http://www.ibm.com/software/data/db2imstools/library.html. 5. Check for FixPaks that are to be installed before you start the program. The Web site is: http://www.ibm.com/software/data/db2imstools/support/ fixpaks.html See also Section 6.0 SERVICE UPDATES. 3.2 INSTRUCTIONS FOR UNIX-BASED OPERATING SYSTEMS Performance Expert for Multiplatforms uses the InstallShield wizard, which is a GUI installation tool. If you want to use the GUI for the installation, you must run the InstallShield in an X Window System environment. Note: If your server for UNIX-based operating systems does not have a directly attached high-function terminal (HFT) that can display X Window System screens, you can use a remote terminal or system. To use this terminal or system, connect to the server via Telnet. Then set the DISPLAY environment variable on the server to use the display of the remote terminal. If you cannot install in an X Window System environment, or if you do not want to install in an X Window System environment, you can install Performance Expert also by using the console. The following instructions apply to both methods unless otherwise indicated. To install Performance Expert for Multiplatforms on UNIX-based operating systems: 1. Log on to the UNIX-based operating system on which Performance Expert is to be installed as a user with root authority. 2. Ensure that the umask is set to 022. The command 'umask' displays the current umask setting. The command 'umask 022' sets umask for current session. 3. This step depends on your installation mode. In an X Window System environment, perform step 3.a. If you use the console, perform step 3.b. 3.a In an X Window System environment, do the following: Ensure that applications of the X Window System can access the display of your choice by using the following commands: echo $DISPLAY This command shows the current DISPLAY variable setting. export DISPLAY=hostname:0 This command sets the DISPLAY if it is incorrect. 'hostname' denotes the name of the host of which the the screen is to be used. xclock& This command verifies that applications of the X Window System can be displayed correctly. You can close the clock display after it appears. If you get a message that contains the line 'Xlib: Client is not authorized to connect to Server', grant this authorization on the host of which the screen is to be used by entering the following command: xhost hostname where hostname denotes the host on which Performance Expert Server is to be installed. Then try it again. If steps 1, 2, and 3.1 are correct, you get the first InstallShield window. 3.b If you use the console, enter one of the following commands depending on your operating system: For AIX: /db2pesrv-install-on-aix \ -is:javaconsole -console For HP-UX: /db2pesrv-install-on-hpux \ -is:javaconsole -console For Linux: mount-point>/db2pesrv-install-on-linux \ -is:javaconsole -console For Solaris Operating Environment: /db2pesrv-install-on-solaris \ -is:javaconsole -console If steps 1, 2, and 3.2 are correct, several dots are displayed at the terminal at which you entered this parameter. The dots indicate that the installation program is initializing and running, and you get the first prompt. 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 FixPak. 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 FixPak 7 for Unix If you install this FixPak, 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 FixPaks to be installed before using the program, refer to the following Web site: http://www.ibm.com/software/data/db2imstools/support/fixpaks.html 6.1 Fixed problems o Installation - general problems - If you want to install Performance Expert Server for monitoring more than one DB2 instance on one machine, you do not have to remove Performance Expert Server before you reinstall it. To monitor more than one DB2 instance on one machine: 1. Ensure that all DB2 instances to be monitored are started. 2. Reinstall Performance Expert Server. Select all instances to be monitored during the installation procedure. - The installation procedure now recognizes more error situations. - Errors that occurred after logon are explained in an error message. o Installation on UNIX-based operating systems - The FixPak levels are checked so that you do not overwrite the latest FixPak version with a previous one. - The search for DB2 PM has been improved. - Start and stop scripts have been improved. o Monitoring on UNIX-based operating systems - Monitoring more than one instance has been improved. o Exception processing - Edit threshold set: If you close the window by clicking the x in the right corner of the title bar, you are asked if you want to save the changes. - Define threshold set: If you save a threshold set by using a name that already exists, you can choose between 'Yes' and 'No'. If you select 'No', you can change the name. - Wrong key behavior and window appearance: Wrong key behavior or key behavior that did not conform to the standard behavior has been corrected. The window appearance has also been corrected so that it conforms to the standards. - If you are not connected to a subsystem at the time you activate exception processing, the client can continue with exception processing. - You can now open a Threshold Configuration window only once for a threshold set. - When you start exception processing for the first time, the split panes are no longer minimized. - Miscellaneous problems with the GUI that occurred after you worked with exception processing are fixed. - You can now use the Threshold editor on UNIX-based operating systems. o Thread summary - You can now exit Performance Expert from the Thread Summary window. o SQL activity - The error of the value in the field 'Failed SQL Stmt.' has been corrected. - You can now select SQL activity tracing from the Selected menu. - You can now start SQL activity from the Application Details window. o Buffer Pool Analyzer - Path names for Reporting samples have been corrected. o Performance Warehouse - You can exit Performance Warehouse from the Performance Warehouse menu. - The Public folder now contains standard ROTs. - The tree structure in the main window has been improved. 6.2 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 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. 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. 9.1 Trademarks and service marks The following terms are trademarks or service marks of the IBM Corporation in the United States, 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.