Wise-GUYTM Database Tuning Analysis for TLCS

HTML Prepared: Mon Oct 7 12:43:36 EDT 2002
Server: jaxssund1, Node: 0

Heap and Cache Analysis

Configuration
Parameter
Historical
Maximum
Historical
Minimum
Historical
Average
Historical
Sample Size
Today's
Results
Locklist 2 % 2 % 2 % 1 2 %
DBHEAP 0 % 0 % 0 % 1 0 %
Package Cache 100 % 100 % 100 % 1 100 %
Catalog Cache 89 % 89 % 89 % 1 89 %

Catalog Cache Hit Ratio

Catalog Cache Hit ratio (89 %) fell short of user configured tuning goal (95 %).
The current value for CATALOGCACHE_SZ is 256 4K pages.
The suggested new CATALOGCACHE_SZ value is 258 4K pages and

Bufferpool Index Hit Ratio Trends

Scale 100 %
4 Weeks Ago -
3 Weeks Ago -
2 Weeks Ago -
Last 7 Days -
Today 100

SORT HEAP Analysis

Performance
Variable
 
Overall
4 Weeks
Ago
3 Weeks
Ago
2 Weeks
Ago
Last 7
Days
Today's
Results
Sort Overflows xx % xx % xx % xx % 0 % 0 %
Average Sort Time xx ms xx ms xx ms xx ms 0 ms 0 ms
Average SORTHEAP in Use xx 4K xx 4K xx 4K xx 4K 0 4K 0 4K
Paging (PIs) xx xx xx xx 0 0
Hash Join Sm Overflows 0.00 % 0.00 % 0.00 % 0.00 % 0.00 % 0 %
Hash Join Loops 0.00 % 0.00 % 0.00 % 0.00 % 0.00 % 0 %
Avg Cfg SORTHEAP Size xx 4K xx 4K xx 4K xx 4K 1024 4K 1024 4K

FYI: Sort Overflow Goal was achieved.


Legend

Goal
Achieved
Needs
Work
Action Required/
Threshold Hit
 
Data


Key Links

Database-Guys  |  International DB2 Users Group  |  IBM DB2 Home


Copyright © 2002 Database-Guys. Spencerport, New York, 14559 USA. All Rights Reserved.