IBM DB2 Buffer Pool Tool: Save $$$$, Optimize Memory Usage, Eliminate I/Os
September 16, 1997
Announcement Letter Number: 297-377
Table of Contents:
- At a Glance
- SUPPLEMENTAL INFORMATION
- TECHNICAL INFORMATION
- ORDERING INFORMATION
- TERMS AND CONDITIONS
- CALL NOW TO ORDER
At a Glance
Do you have questions like these?
- How can I improve my DB2 performance?
- What can I do to maximize CPU memory usage?
- How can I eliminate unnecessary I/O?
- Is there a way to predict the effects of DB2 tuning before I do
- What is the best number and size of buffer pools for my environment?
- Shorten problem analysis time
- Optimize memory usage
- Save CPU cycles
- Improve response times
- Reduce cost of DB2 workloads
----------------------------------------- For ordering, contact: Your IBM representative, an IBM Business Partner, or IBM North America Sales Centers at 800-IBM-CALL Reference: LE010
EXTRA! EXTRA! . . .
Subscribe to IBM iSource, your electronic source for customized IBM information! Go to our web site at %+%Start_URL%+% http://www.ibm.com/isource or send an e-mail to %+%Start_EML%+% email@example.com with the word SUBSCRIBE in the body.
While DB2 (R) online performance monitors can tell you when something is wrong, it may be a difficult and time-consuming effort to determine what is the right corrective action to take. Take the guesswork out of tuning and avoid making costly mistakes with DB2 Buffer Pool Tool.
DB2 Buffer Pool Tool helps performance analysts evaluate tuning alternatives and achieve optimal performance with minimal effort. Accurate tuning of buffer pools is one of the single most critical factors to improving DB2 performance and getting the most out of your system resources. By now, we all know the best I/O is no I/O; however, eliminating I/O can be a challenging task.
DB2 Buffer Pool Tool gives you comprehensive statistical data and easy-to-read reports and graphs for all pools and objects. The type of information provided by DB2 Buffer Pool Tool is not available from any other monitor or tool in the industry.
DB2 Buffer Pool Tool provides the ability to simulate the effects of changing pool sizes and thresholds. It can also help you predict the effects of moving DB2 objects into different pools or into new pools that do not currently exist. This "what if" analysis allows you to make expert decisions on maximizing resource utilization and reducing elapsed time of your DB2 transactions through effective buffer pool usage. DB2 Buffer Pool Tool is the ultimate tuning aid. If you need a better way of realizing performance improvements, then consider the advantages that DB2 Buffer Pool Tool can provide. DB2 Buffer Pool Tool makes it easier to maximize system resources and optimize DB2 performance. Eliminate I/O and realize better utilization of your existing expanded and real storage with DB2 Buffer Pool Tool. DB2 Buffer Pool Tool allows you to reduce CPU cycles, improve DB2 transaction and batch job elapsed times, and save money.
Every DB2 Customer can benefit from the use of DB2 Buffer Pool Tool. Product usage can help reduce transaction and batch processing elapsed times and CPU processing costs.
DB2 Buffer Pool Tool can be used on DB2 for MVS/ESA (TM), Version 3 and later releases. Buffer Pool Tool is installed by System Modification Program (SMP/E).
Planned Availability Date
October 24, 1997
This announcement is provided for your information only. For additional information, contact your IBM representative, call 800-IBM-4YOU, or visit the IBM home page at: %+%Start_URL%+% http://www.ibm.com
The DB2 Buffer Pool Tool provides the following advantages:
- Low Overhead
The last thing you want to have is a performance tool that causes a performance problem because it uses too much overhead in collecting statistical information. The advantage of DB2 Buffer Pool Tool is that it uses the IFI interface and its own data collection facility to avoid the costly overhead associated with other tools. Further, DB2 Buffer Pool Tool easily processes a statistically meaningful data collection interval (more than 30 minutes) that other trace facilities cannot handle efficiently.
- Unique Information
No other DB2 tool provides the level and type of statistical analysis available in DB2 Buffer Pool Tool. DB2 Buffer Pool Tool shows you exactly how the pool and objects are used. The extensive statistics include:
- System and Application Hit Ratios
- Getpage Activity and I/O Rates
- Random Access Activity
- Prefetch (including Dynamic and List) Access Activity
- Read and Write I/O Activity
- Average and Maximum I/O Elapsed Times
- Random Page HiperPool Retrieval
- Average Page Residency Times
- Average Pages/Write
- Expert Knowledge
Although this tool provides the most comprehensive set of data related to DB2 activity available today, DB2 Buffer Pool Tool synthesizes, summarizes, and analyzes this information so you won't suffer from "information overload" or have "analysis paralysis," which is common with other types of tuning aids. In addition, you can optionally adjust threshold to bypass reporting for objects having very low usage rates.
DB2 Buffer Pool Tool makes it easy to clearly see which objects are the poorest and best performing and the impact each is having on its current pool. Look no further than DB2 Buffer Pool Tool output to determine which objects will obtain the greatest benefit from changes.
Not only does DB2 Buffer Pool Tool provide easy to read reports and graphs, it even offers general tuning advice based on information gathered from your environment. For example, these recommendations can range from separating indexes from table spaces to moving Sort Work objects into their own pool or to lowering virtual write threshold.
Additionally, as you move to a data sharing environment, DB2 Buffer Pool Tool can be invaluable in providing initial sizing specifications for the Coupling Facility structures.
- Simulation Analysis
DB2 Buffer Pool Tool gives you powerful simulation capabilities to determine how to best optimize memory usage, eliminate I/O, and improve response times. DB2 Buffer Pool Tool turns tuning into a scientific process by allowing you to perform many "what if" analyses to evaluate various scenarios.
DB2 Buffer Pool Tool is a superior solution when compared to online monitors and other DB2 subsystem analysis aids since it can:
- Predict system performance levels at varying pool sizes
- Predict improved object performance within each pool
- Model VPSEQT or HPSEQT threshold adjustments
DB2 Buffer Pool Tool gives you the advantage to completely model the effects that proposed changes may have without impacting the operating DB2 system. Up to eight simulation sizes for a pool can be done with one pass of the data.
- Predict system performance levels at varying pool sizes
DB2 Buffer Pool Tool gives you the expert knowledge and reduces the time and effort necessary to effectively tune your environment. Make informed decisions with confidence regarding performance improvements.
This product is Year 2000 Ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and/or receiving date data within and between the twentieth and twenty-first centuries, provided all other products, (for example, software, hardware, and firmware) used with the product properly exchange date data with it.
MVS/ESA is a trademark of International Business Machines Corporation in the United States or other countries or both. DB2 is a registered trademark of International Business Machines Corporation in the United States or other countries or both. Other company, product, and service names may be trademarks or service marks of others.
Specified Operating Environment
Hardware Requirements: The DB2 (R) Buffer Pool Tool operates on any hardware supporting the following minimum software versions:
- DB2/ESA Version 3 (5685-DB2)
- Microsoft (R) Windows (R) 3.11 or Windows 95
Security, Auditability, and Control
The announced program uses the security and auditability features of the MVS (R) DB2 software.
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
Orders for new licenses will be accepted now.
Shipment will begin on October 24, 1997.
Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. For a graduated one-time charge (OTC) or graduated monthly license charge (MLC), specify the feature number below that corresponds to the group that contains the designated machine. Also, specify the feature number of the desired distribution medium.
Basic Basic Graduated Graduated Group OTC Feature MLC Feature Number Number Number
18 1928 1913 20 1929 1914 25 1930 1915 28 1931 1916 29 1932 1917 30 1933 1918 31 1934 1919 32 1935 1920 35 1936 1921 38 1937 1922 40 1938 1923 50 1939 1924 60 1940 1925 70 1941 1926 80 1942 1927
Multiple Operating System -- PR/SM (TM) (MOSP): For a graduated OTC or graduated MLC, specify the feature number below that corresponds to the group that contains the designated machine.
MOSP Basic MOSP Basic Graduated Graduated Group OTC Feature MLC Feature Number Number Number
18 2067 1943 20 2068 1944 25 2069 1945 28 2070 1946 29 2071 1947 30 2072 1948 31 2073 1949 32 2074 1950 35 2075 1951 38 2076 1952 40 2077 1953 50 2078 1954 60 2079 1955 70 2095 1956 80 2096 1957
Note: The group can be determined by referring to the Exhibit for IBM System/370 (TM) and System/390 (R) Machines (Z125-3901) or the Exhibit for Non-IBM Machines (Z125-3902) associated with the IBM Customer Agreement (Z125-4575).
Entry Support License (ESL): To order an ESL license, specify the program number, feature number 9001 for asset registration, and the applicable ESL OTC feature number. Also specify the feature number of the desired distribution medium.
ESL OTC Program Feature Description Number Number
DB2 Buffer Pool Tool for 5697-D16 1912 MVS/ESA (TM)
Note: ESL machines can be determined by referring to the IBM Entry End User/390 Attachment (Z125-4379).
Parallel Sysplex (TM) License Charge (PSLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the PSLC Base feature. If applicable, specify the PSLC Level A and PSLC Level B features and quantity.
If there is more than one program copy in a Parallel Sysplex, the charge for all copies is associated to one license by specifying the applicable PSLC feature numbers and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the PSLC No-Charge (NC) Identifier feature on the licenses. Also, specify the feature number of the desired distribution medium.
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description
1 2058 PSLC Base, 1 MSU 2 2059 PSLC Base, 2 MSUs 3 2060 PSLC Base, 3 MSUs 4 to 45 2061 PSLC Level A, 1 MSU 2062 PSLC Level A, 42 MSUs 46 or more 2063 PSLC Level B, 1 MSU 2064 PSLC Level B, 10 MSUs 2065 PSLC Level B, 50 MSUs Not Applicable 2066 PSLC NC Identifier
Example 1: A single machine, with 11 MSUs, PSLC program features are 1873, quantity 1 and 1874, quantity 8.
Example 2: Two machines, with 60 aggregate MSUs in a Parallel Sysplex, PSLC program features are:
- PSLC chargeable program #1 -- 1873 quantity 1, 1875 quantity 1,
1876 quantity 5 and 1877 quantity 1
- PSLC no-charge program #2 -- 1879 quantity 1
IMLC Basic License IMLC MLC Feature Feature Description Number
IMLC Base 80 MSUs 2054 IMLC 1 MSU 2055 IMLC 10 MSUs 2056 IMLC 50 MSUs 2057
Version-to-Version Upgrade Credit: To upgrade from a prior program acquired for an OTC to a replacement program using a version-to-version upgrade credit, the customer must notify and identify to IBM the applicable prior program and replacement program participating in the upgrade credit.
Basic Machine-Readable Material: To order, select the feature number of the desired distribution medium:
Feature Distribution Environment Number Medium
Buffer Pool Tool Basic 5831 9/6250 bpi tape Buffer Pool Tool Basic 5832 3480 cartridge Buffer Pool Tool Basic 5047 4-mm cartridge
Customization Options: Select the appropriate feature numbers to customize your order to specify the delivery options desired. These features can be specified on the initial or MES orders.
Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.
Feature Description Number
Serial Number Only 3444 (suppresses shipment of media and documentation)
Ship Media Only 3470 (suppresses initial shipment of documentation)
Ship Documentation Only 3471 (suppresses initial shipment of media)
Ship Media Updates Only 3480 (suppresses update shipment of documentation)
Ship Documentation Only 3481 (suppresses update shipment of media)
Suppress Updates 3482 (suppresses update shipment of media and documentation)
Local IBM Office Expedite 3445 (for IBM use only)
Customer Expedite Process Charge 3446 ($30 charge for each product)
Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Manufacturing Solutions (SMS) receives the order. SMS will then ship the order via overnight air transportation.
DSLO License: To order a DSLO license, specify the program number, feature number 9901 for asset registration, and the feature number below for a graduated OTC or graduated MLC that corresponds to the group containing the designated machine:
DSLO DSLO Graduated Graduated Group OTC Feature MLC Feature Number Number Number
18 1973 1958 20 1974 1959 25 1975 1960 28 1976 1961 29 1977 1962 30 1978 1963 31 1979 1964 32 2014 1965 35 2015 1966 38 2016 1967 40 2017 1968 50 2018 1969 60 2019 1970 70 2020 1971 80 2021 1972
Multiple Operating System -- PR/SM (MOSP): For a graduated OTC or graduated MLC, specify the following feature number below that corresponds to the group that contains the designated machine.
MOSP DSLO MOSP DSLO Graduated Graduated Group OTC Feature MLC Feature Number Number Number
18 2037 2022 20 2038 2023 25 2039 2024 28 2040 2025 29 2042 2026 30 2043 2027 31 2044 2028 32 2045 2029 35 2046 2030 38 2048 2031 40 2049 2032 50 2050 2033 60 2051 2034 70 2052 2035 80 2053 2036
Ordering a DSLO feature will result in IBM maintaining a record of this customer location as a DSLO user only. All material for the DSLO license will be provided through the basic license location. If a user selects DSLO, no other feature numbers are valid for this order and no program materials or updates will be shipped.
Unlicensed Documentation: A program directory and one copy of the following publications are supplied automatically with the basic machine-readable material:
Order Title Number
DB2 Buffer Pool Tool for MVS/ESA GC26-9189 User's Guide DB2 Buffer Pool Tool Licensed GC26-9188 Program Specification
Additional copies of unlicensed publications will be available for a fee after October 24, 1997. These copies may be ordered from your IBM representative, through the System Library Subscription Service (SLSS), or by direct order.
Subsequent updates (technical newsletters or revisions between releases) to the publications shipped with the product will be distributed to the user of record for as long as a license for this software remains in effect. A separate publication order or subscription is not needed.
Licensing: IBM Customer Agreement
Variable Charges Apply: Yes
Installation License or Location License Applies: No
Usage Restriction Applies: No
Educational Allowance: Yes, to qualified education customers
Volume Discount: Not applicable
Version-to-Version Upgrade Credits Apply: Yes
Single Version Replaced Replacement Charging Programs Programs Applies
DB2 Buffer Pool To all follow-on, No Tool (5697-D16) if any
Licensed Program Materials Availability
- Restricted Materials of IBM: None
- Non-Restricted Source Materials: None
- Object Code Only (OCO): All
Support Center applies: Yes, access available through the IBM Support Center
Available until 12 months' written notice discontinued:
APAR mailing address: IBM Corporation 555 Bailey Ave San Jose, CA 95141
Services for DSLO Provided through basic license licenses: location
The charges provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.
Graduated OTC Graduated MLC Group Basic DSLO Basic DSLO
Program Number 5697-D16
18 $ 4,595 $ 3,445 $ 96 $ 72 20 6,660 4,995 139 104 25 8,655 6,490 181 136 28 11,860 8,895 248 186 29 15,420 11,570 322 242 30 20,050 15,040 418 314 31 24,660 18,500 514 386 32 31,570 23,680 658 494 35 36,300 27,230 757 568 38 41,740 31,310 870 653 40 48,000 36,000 1,000 750 50 60,000 45,000 1,250 938 60 75,000 56,250 1,565 1,175 70 93,750 70,310 1,955 1,465 80 117,200 87,900 2,445 1,835
MOSP MOSP Graduated OTC Graduated MLC Group Basic DSLO Basic DSLO
18 $ 4,595 $ 3,445 $ 96 $ 72 20 5,630 4,225 118 89 25 7,660 5,745 160 120 28 10,260 7,695 215 161 29 13,640 10,230 285 214 30 17,740 13,310 370 278 31 22,360 16,770 466 350 32 28,120 21,090 586 440 35 33,940 25,460 708 531 38 39,020 29,270 814 611 40 44,870 33,650 935 701 50 54,000 40,500 1,125 844 60 67,500 50,630 1,410 1,060 70 84,380 63,290 1,760 1,320 80 105,500 79,130 2,200 1,650
Entry End User/390 ESL $1,530
MSU Capacity Description MLC
1 PSLC Base, 1 MSU $ 248 2 PSLC Base, 2 MSUs 418 3 PSLC Base, 3 MSUs 660 4 to 45 PSLC Level A, 1 MSU 30 PSLC Level A, 42 MSUs 1,260 46 or more PSLC Level B, 1 MSU 12 PSLC Level B, 10 MSUs 120 PSLC Level B, 50 MSUs 600
IMLC IMLC Description Charge
IMLC Base 80 MSUs $2,275 IMLC 1 MSU 12 IMLC 10 MSUs 120 IMLC 50 MSUs 600
OTC: Customers who pay an OTC for a licensed program receive enhancements and future releases, if any, at no additional charge. Significant new function may be offered as an optional feature and charged for separately. If a replacement program is announced and the customer elects to license the replacement program and replace the prior program, a time-based upgrade credit may apply.
Variable Charges: The applicable graduated OTC or graduated MLC will be based on the group of the designated machine on which the licensed program is licensed for use. If the program is designated to a processor in a group for which no charge is listed above, the charge of the next higher group listed applies.
For upgrades of OTC licenses to a machine in a higher group, the upgrade charge will be the difference in the then current charges between the two groups. For downgrades of OTC licenses to a machine in a lower group, there will be no adjustment or refund of OTCs paid.
For upgrades or downgrades of MLC licenses, the MLC applicable to the higher or lower group will apply.
Entry Support License OTC: OTC authorizes use only on IBM Entry End User/390 Machines.
To order, contact the IBM North America Sales Centers, your local IBM representative, or your IBM Business Partner (TM).
IBM North America Sales Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.
Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org Mail: IBM North America Sales Centers Dept. LE010 P.O. Box 16848 Atlanta, GA 30321-0848 Reference: LE010
To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU.
Note: Shipments will begin after the planned availability date.
PR/SM, System/370, MVS/ESA, Parallel Sysplex, and Business Partner are trademarks of International Business Machines Corporation in the United States or other countries or both. DB2, MVS, and System/390 are registered trademarks of International Business Machines Corporation in the United States or other countries or both. Microsoft and Windows are registered trademarks of Microsoft Corporation. Other company, product, and service names may be trademarks or service marks of others.