IBM(R) DB2(R) Performance Expert for Multiplatforms, V1 R1, FixPak 6 DB2 Performance Monitor for z/OS - Workstation Online Monitor V7 and V6 DB2 Buffer Pool Analyzer for z/OS CONTENTS 1.0 ABOUT THIS README FILE 1.1 Evaluation code 1.2 Corrected problems 1.3 Enhancements 2.0 PREREQUISITES 2.1 Hardware requirements 2.2 Software requirements 3.0 INSTALLATION INSTRUCTIONS 3.1 Performance Expert for UNIX-based operating systems 4.0 CUSTOMIZATION INSTRUCTIONS 5.0 FIXPAK INSTALLATION 5.1 FixPak Install for Performance Server on Windows(TM) 5.2 FixPak Install for Performance Server on UNIX(TM)-based operating systems 5.3 FixPak Install for Performance Server Agent on Windows 6.0 RESTRICTIONS 6.1 Performance Expert 6.2 Workstation Online Monitor 6.3 Japanese version of Performance Expert 7.0 CORRECTIONS TO DOCUMENTATION 8.0 HOW TO GET HELP 9.0 NOTICES 9.1 Use of the evaluation program 9.2 Trademarks and service marks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 Performance Expert, Version 1 Release 1, README file. This README file contains information about installing IBM DB2 Performance Expert. It is the most current README file as of 01/30/2003. 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. 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 9.1, Use of the evaluation program, and the License Agreement provided with your evaluation copy of the program. 1.2 Corrected problems This FixPak contains the following corrections: - 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. - Workaround for: InstallShield error on AIX if there are more than 59 mount points. This problem will be fixed with FixPak 7 in which a later version of InstallShield will be used. Workaround: Unmount so that less than 59 mount points are available. (APAR PQ69734) - The script ./db2pesrv-config cannot handle NIS on AIX. This problem will be fixed with FixPak 7. In the meantime, a new ./db2pesrv-config script was sent to customers for testing. If necessary, the new script can be provided also to other customers. (APAR PQ69755) - Workaround for: While installing the base or a FixPak of Performance Expert on Windows, the message 'Cannot find file layoput.bin. Please insert disk ...' might appear. Workaround: 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 FixPak. - Workaround for: When running an SQL Activity Tracing report from the Application Details window on Windows 2000, the report fails 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 use of this table space to the user DB2PESERVER. - Fixed: Performance Expert for Multiplatforms produces an incorrect date and time in secondary windows, such as Thread Details.(APAR PQ67875, PQ68892, PQ68893, PQ68895, PQ68896) - Fixed: History Settings window: different or wrong intervals or time ranges are displayed. (APAR PQ68382) - Fixed: 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. (APAR PQ68713) - Fixed: 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. (APAR PQ68713) - Fixed: 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. In addition, this window should be sizeable. (APAR PQ68713) - Fixed: 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. (APARs PQ68949, PQ68950, PQ68951, PQ68952, PQ68953) - Fixed: 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. (APAR PQ68339) - Fixed: System Health charts are not updated properly. - Fixed: 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 - Fixed: Double-clicking an application entry in the Application Summary window produces no response. - Fixed: Double-clicking 'Applications in Lock Conflicts' in the System Overview window produces the following error: DG0K3503 Data is not available. - Fixed: Pressing 'Cancel' while SQL activity is running generates the DB2 error RC-438. - Fixed: Performance Expert on the Solaris Operating Environment gets an error when executing the PE start script ./PESTART: TEST: ARGUMENT EXPECT MESSAGE (APAR PQ68199) - Fixed: Performance Expert on AIX(R) receives an error when requesting delta or interval processing from the Statistics Details window. (APAR PQ66447) To obtain a list of fixes that were included in previous FixPaks, refer to APAR PQ68206, PQ68208, PQ68207, PQ68201, PQ68209, PQ66899, PQ66902, PQ66900, PQ66903, PQ66901, PQ65948, PQ65963. 1.3 Enhancements This FixPak contains the following enhancements: -Support of Linux for z/OS -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 instance - Data views in system health can be customized - Table columns can be customized - Event exception processing for event DEADLOCK -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. -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. 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 minimum requirements. -A minimum of 150 MB of free disk space. -Additional space for user data (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 FixPak 5 or later. 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. 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. 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 Version 7 FixPak 8. - Clients running under DB2 Version 8 can only connect to servers running under DB2 Version 8. 5. To use this 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. 6. 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. 3.1 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 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: /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 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. 5.0 FIXPAK INSTALLATION 5.1 FixPak Install for Performance Server on Windows 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. This option repairs only program files of the Performance Expert Server installation. To repair the DB2PM database, reinstall Performance Expert Server. 5.2 FixPak Install for Performance Server on UNIX-based operating systems Before you can install a FixPak, the base package of Performance Expert Server must be installed. 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, if InstallShield does not do a complete uninstall of Performance Expert, you will have to drop the DB2PM database by using the following command: db2 drop db db2pm In addition, you may 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: /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. 5.3 FixPak Install for Performance Server Agent on Windows Usually, the installation program performs the update automatically. If not, use the Repair option. 6.0 RESTRICTIONS 6.1 Performance Expert - 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". - 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. - If you install Performance Expert Server on a machine on which DB2 Version 7.2 FixPak 7 for UNIX is installed, you must run Performance Expert Client on the same machine. Remote access causes a DB2 problem. - 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 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' 6.2 Workstation Online Monitor - 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. - Restarting the client if the server is restarted might require special handling. 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 the DB2 instance to be monitored is restarted, the client might not reconnect. In this case, 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. 6.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. 7.0 CORRECTIONS TO 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. 8.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 FixPaks to be installed before using the program, refer to the following Web site: http://www.ibm.com/software/data/db2imstools/support/fixpaks.html 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. 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. 9.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. 9.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.