This is a measurable metric. Unlike Hit Ratios, it can be converted into CPU costs, and elapsed time savings for both online and batch functions. We look at their statement, and determine if the average installation will derive a benefit from this approach, and what side-effects may occur e. Using Averages for Performance Prediction K. Bernie Domanski. PDF by Dr. This paper clearly explains the problem, and points out where bias distorts performance results in other products.
DB2 and the Need for Speed. Productive capacity of a complex can be greatly increased because IO activity tuning will also improve processor, main storage and virtual storage utilization. This presentation will demonstrate all that is needed for an effective IO activity tuning project along with the benefits achieved by such activities.
DB2 System Performance Metrics Revisited — DB2 is a complex database management system, that has a major impact upon your overall processing environment. Quite directly, this is the only way you can get it right. Temporary pool isolation, and performance evaluation of an object in one pool might take you half a lifetime to complete for a large DB2 environment, and the fallacy of pool isolation is the lack of interaction between multiple or many objects.
This cannot be determined or evaluated using isolation techniques. The Statistical Analysis component provides a level of information for the overall System, each Pool, and every Object, that is simply not available from any other product. Additionally, a PC based graphics component makes it easy to determine which objects are performing the best, which are performing poorly, the impact each is having on its current pool, and which objects will obtain the greatest improvement from changes.
A PC based graphic analysis component processes summarized data from the mainframe facilities, and easily shows the best and poorest performing pools and objects. It also provides analysis of the current environment and makes tuning suggestions for your system. These suggestions may encompass anything from changing pool thresholds, increasing pool sizes, and moving objects into different pools.
The software is Y2K compliant. A Coupling Facility sizing component is available that provides initial sizing specifications for the CF structures in a Data Sharing Environment. Since the displays do not order the output by access rates, one or more highly accessed objects may be lost because the line output is limited. Usually cannot handle a long enough trace period to provide statistical relevance.
We were also able to identify and correct application performance problems.
0コメント