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 6 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 4.3 Japanese version of Performance Expert 4.4 Documentation 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", SC27-1646-03. You can find this documentation also on the following Web site: http://www.ibm.com/software/data/db2imstools/library.html 2. Close all Performance Expert Agents and Performance Expert Agent connections before installing Performance Expert Server. 3. Ensure that all DB2 instances to be monitored are started. 4. 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. 5. What to consider when you have DB2 Version 8 installed: - Do not use blanks in the installation path names when installing Performance Expert on a Windows workstation or server. - 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 Versoin 7 FixPak 8. - Clients running under DB2 Version 8 can only connect to servers running under DB2 Version 8. 6. To use this Performance Expert Client with a Performance Expert Server for z/OS Version 1.1, APAR 68678 must be applied on the server to ensure correct results. 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. Notes: 1. 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. 2. When you run the script db2pesrv-config on AIX or Linux, the Product Registration Tool (PRT) is invoked with a GUI that runs only in an X Window system environment. If you do not have an X Window system environment, edit the file db2pesrv-config.ksh and mark the lines in the PRT section as comments. 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 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.3 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.4 Handling too many database connections on Multiplatforms 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 updating a flag in the DB2PM.PARAMETER table. Issue the following command from a DB2 command line: update db2pm.parameter set pa_flagvalue='N' where pa_key='EVENTEXCEPTION' 4.1.5 Installing Performance Expert Server with FixPak 5 on DB2 V8 If you have set up only multinode instances, you cannot install Performance Expert Server with FixPak 5 on your DB2 V8 system. To solve this problem, you must set up a single node instance. Then, you can upgrade to Performance Expert Server with FixPak 6 and enable your multinode instances. 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 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. 4.2.3 Restarting the client if the server is restarted 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. 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 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 log off from the DB2 instance. 4.3 Japanese version of Performance Expert 4.3.1 Double-byte character set (DBCS) entries You cannot DBCS entries for Performance Warehouse functions and for the System Health window of the Workstation Online Monitor. 4.3.2 Databases defined with CCSID 1390 Performance Warehouse does not work with databases defined with CSSDID 1390. It works, however, with databases defined with CCSID 500. 4.4 Documentation "IBM DB2 Performance Expert for z/OS and Multiplatforms, Version 1 Release 1, Monitoring Performance from the Workstation" states that Performance Warehouse and Buffer Pool Analyzer are currently available only for z/OS. This statement is incorrect because both are now available for Multiplatforms. The book will contain the correct description in the next version. 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 The following list shows the problems resolved for FixPak 6. It includes neither the problems fixed for FixPak 5 nor any minor problems found and fixed. o Installation - general problems - It is now possible to install Performance Expert without DB2 being installed. You only get a warning. Remember that some functions produce an error if the installation has not been performed correctly. - The InstallShield has been enhanced and includes more queries. o APARs - Performance Expert cannot be installed if DB2 is not installed. - APAR PQ67875 PQ68892 PQ68893 PQ68895 PQ68896 DB2 Performance Expert for Multiplatforms produces an incorrect date and time in secondary windows, such as Thread Details. - APAR PQ68382 History Settings window: different or wrong intervals or time ranges are displayed. - APAR PQ68713 - Display of legend or report is not persistent: If you open the legend and report for a data view and then close this data view, the legend and report are no longer visible when you open the data view the next time. - The selected data view colors do not take immediate effect: If you change the color of a data-view bar chart, the color in the legend does not change until you close (CTRL-W) the data view and open it again. - Refine Open Predefined Data View window: - When you open this window, a long name in the 'Name of data view' field is not completely visible. The cursor should be placed in the front of the text. - This window should be sizable. - APARs PQ68949, PQ68950, PQ68951, PQ68952, PQ68953 - The diagnostics information directly sent from Performance Expert by using e-mail contains the password that is used to log on to Performance Expert. The password is then no longer protected. - APAR PQ68339 - DB2 locking conflicts - 'Data transfer in progress' always appears if no application locking conflict exists. This message persists even after the data is refreshed. - The windows do not refresh properly. The locks appear even after they were resolved. - Clicking View --> Customize Columns in the Applications in Lock Conflicts window causes an internal error. - System Health charts are not updated properly. - The SQL activity tracing report started from the Application Details window fails with an SQL0286N message: SQL0286N A default table space could not be found with a page size of at least 4096 that authorization ID DB2PESERVER is authorized to use. RC 201 Reason -286 - Double-clicking an application entry in the Application Summary window produces no response. - Double-clicking 'Applications in Lock Conflicts" in the System Overview window produces the following error: DG0K3503 Data is not available. - Pressing 'Cancel' while SQL activity is running generates the DB2 error RC-438. - APAR PQ68199 DB2 Performance Expert on the Solaris Operating Environment gets an error when executing the PE start script ./PESTART: TEST: ARGUMENT EXPECT MESSAGE - APAR PQ66447 DB2 Performance Expert on AIX receives an error when requesting delta or interval processing from the Statistics Details window. 6.2 Added features o Support of Linux for z/OS o Performance Expert for Multiplatforms now includes: - Automatic update of a previously installed Performance Expert Agent - Configuration of Performance Expert Server is saved on the server - Multiple logon, where you can log on to several DB2 instances at once - Multiple launch, where you can start several monitoring functions in one or more DB2 instances - Data views in system health can be customized - Table columns can be customized - Event exception processing for event DEADLOCK o Performance Warehouse is now available on Multiplatforms: - The processes collect event trace data, load trace data into warehouse tables, and generate reports. Sample processes are shipped with the product. Before you can run them, you must copy them to a process group that you created, and adapt them to the monitored databases. - SQL activity reports, buffer pool trace reports, database summary reports, and trace reports can be created in HTML format. - SQL queries evaluate event trace data that is collected in warehouse processes. Sample queries are shipped with the product. o Buffer pool analysis is now available on Multiplatforms: - Buffer pool analysis can be started from the System Overview window. - You can create buffer pool trace reports and display them in HTML format or as graphical charts. 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.