Pool-GUYTM Bufferpool Analysis for GUYSDB1

HTML Prepared: Thu Nov 5 01:24:01 EST 1998
Server: wiseguy

Bufferpool Summary

Bufferpool NameSize MBPagesPage Size
IBMDEFAULTBP 3.9 1000 4096
HOTINDEXBP 19.5 5000 4096
SYSCATBP1 8.8 2250 4096
SUPERHOTDATABP 10.7 2750 4096
TEMPSPACEBP4K 5.9 1500 4096
TEMPSPACEBP8K 7.8 1000 8192
USERBP8K 15.6 2000 8192

Bufferpool Details

IBMDEFAULTBP

Trend Report

IBMDEFAULTBP Performance Trends
Performance
Variable
Four
Weeks Ago
Three
Weeks Ago
Two
Weeks Ago
Previous
Seven Days
Today's
Results
Index Hit Ratio 62 % 64 % 64 % 66 % 67 %
Overall Hit Ratio 57 % 58 % 61 % 63 % 64 %
Synchronous Reads 63 % 61 % 63 % 62 % 64 %
Pages Read/Minute 180 179 172 171 169

Comparative Tuning Analysis

IBMDEFAULTBP Tuning Analysis
 
Performance
Variable
 
 
Notes
Next
Lowest
Historical Size
 
Current
Size
Next
Highest
Historical Size
Number of 4K Pages   750 1000 N/A
Index Hit Ratio >   66 % 67 % 100 %
Overall Hit Ratio   63 % 64 % 100 %
Synchronous Reads   63 % 64 % 0 %
Pages Read/Minute   167 169 0

Analysis Notes

Recommendation

Recommended size for IBMDEFAULTBP is 1250 pages, alter generated.


HOTINDEXBP

Trend Report

HOTINDEXBP Performance Trends
Performance
Variable
Four
Weeks Ago
Three
Weeks Ago
Two
Weeks Ago
Previous
Seven Days
Today's
Results
Index Hit Ratio 95 % 98 % 96 % 98 % 99 %
Overall Hit Ratio 85 % 91 % 89 % 90 % 92 %
Synchronous Reads 96 % 98 % 97 % 99 % 98 %
Pages Read/Minute 586 585 582 578 558

Comparative Tuning Analysis

HOTINDEXBP Tuning Analysis
 
Performance
Variable
 
 
Notes
Next
Lowest
Historical Size
 
Current
Size
Next
Highest
Historical Size
Number of 4K Pages   4500 5000 5500
Index Hit Ratio   97 % 99 % 99 %
Overall Hit Ratio   89 % 92 % 91 %
Synchronous Reads   97 % 98 % 98 %
Pages Read/Minute   578 558 559

Analysis Notes

Recommendation

Bufferpool size is optimized, no changes required.


SYSCATBP1

Trend Report

SYSCATBP1 Performance Trends
Performance
Variable
Four
Weeks Ago
Three
Weeks Ago
Two
Weeks Ago
Previous
Seven Days
Today's
Results
Index Hit Ratio 94 % 96 % 97 % 98 % 98 %
Overall Hit Ratio 91 % 93 % 92 % 95 % 95 %
Synchronous Reads 84 % 91 % 89 % 82 % 85 %
Pages Read/Minute 189 187 185 181 182

Comparative Tuning Analysis

SYSCATBP1 Tuning Analysis
 
Performance
Variable
 
 
Notes
Next
Lowest
Historical Size
 
Current
Size
Next
Highest
Historical Size
Number of 4K Pages   2000 2250 2500
Index Hit Ratio <   98 % 98 % 98 %
Overall Hit Ratio   96 % 95 % 95 %
Synchronous Reads   85 % 85 % 87 %
Pages Read/Minute   181 182 180

Analysis Notes

Recommendation

Recommended size for SYSCATBP1 is 2000 pages, alter generated.


SUPERHOTDATABP

Trend Report

SUPERHOTDATABP Performance Trends
Performance
Variable
Four
Weeks Ago
Three
Weeks Ago
Two
Weeks Ago
Previous
Seven Days
Today's
Results
Index Hit Ratio 92 % 94 % 95 % 95 % 96 %
Overall Hit Ratio 91 % 92 % 94 % 95 % 96 %
Synchronous Reads 84 % 83 % 81 % 84 % 83 %
Pages Read/Minute 294 291 285 280 279

Comparative Tuning Analysis

SUPERHOTDATABP Tuning Analysis
 
Performance
Variable
 
 
Notes
Next
Lowest
Historical Size
 
Current
Size
Next
Highest
Historical Size
Number of 4K Pages   2250 2750 3250
Index Hit Ratio   95 % 96 % 96 %
Overall Hit Ratio   94 % 96 % 96 %
Synchronous Reads   84 % 83 % 85 %
Pages Read/Minute   285 279 282

Analysis Notes

Recommendation

Bufferpool size is optimized, no changes required.


TEMPSPACEBP4K

Trend Report

TEMPSPACEBP4K Performance Trends
Performance
Variable
Four
Weeks Ago
Three
Weeks Ago
Two
Weeks Ago
Previous
Seven Days
Today's
Results
Index Hit Ratio 0 % 0 % 0 % 0 % 0 %
Overall Hit Ratio 63 % 61 % 65 % 68 % 73 %
Synchronous Reads 21 % 11 % 15 % 19 % 17 %
Pages Read/Minute 445 439 434 423 424

Comparative Tuning Analysis

TEMPSPACEBP4K Tuning Analysis
 
Performance
Variable
 
 
Notes
Next
Lowest
Historical Size
 
Current
Size
Next
Highest
Historical Size
Number of 4K Pages   1000 1500 2000
Index Hit Ratio   0 % 0 % 0 %
Overall Hit Ratio   69 % 73 % 73 %
Synchronous Reads   15 % 17 % 18 %
Pages Read/Minute   439 424 423

Analysis Notes

Recommendation

Bufferpool size is optimized, no changes required.


TEMPSPACEBP8K

Trend Report

TEMPSPACEBP8K Performance Trends
Performance
Variable
Four
Weeks Ago
Three
Weeks Ago
Two
Weeks Ago
Previous
Seven Days
Today's
Results
Index Hit Ratio 0 % 0 % 0 % 0 % 0 %
Overall Hit Ratio 72 % 73 % 74 % 75 % 77 %
Synchronous Reads 17 % 13 % 16 % 19 % 18 %
Pages Read/Minute 415 409 402 400 394

Comparative Tuning Analysis

TEMPSPACEBP8K Tuning Analysis
 
Performance
Variable
 
 
Notes
Next
Lowest
Historical Size
 
Current
Size
Next
Highest
Historical Size
Number of 4K Pages   1750 2000 N/A
Index Hit Ratio   0 % 0 % 100 %
Overall Hit Ratio C   75 % 77 % 100 %
Synchronous Reads   19 % 18 % 0 %
Pages Read/Minute   400 394 0

Analysis Notes

Recommendation

Recommended size for TEMPSPACEBP8K is 2000 pages, alter generated.


USERBP8K

Trend Report

USERBP8K Performance Trends
Performance
Variable
Four
Weeks Ago
Three
Weeks Ago
Two
Weeks Ago
Previous
Seven Days
Today's
Results
Index Hit Ratio N/A % 79 % 83 % 83 % 84 %
Overall Hit Ratio N/A % 70 % 74 % 76 % 77 %
Synchronous Reads N/A % 79 % 83 % 84 % 81 %
Pages Read/Minute N/A 282 268 270 260

Comparative Tuning Analysis

USERBP8K Tuning Analysis
 
Performance
Variable
 
 
Notes
Next
Lowest
Historical Size
 
Current
Size
Next
Highest
Historical Size
Number of 8K Pages   1750 2000 N/A
Index Hit Ratio >   82 % 84 % 100 %
Overall Hit Ratio   75 % 77 % 100 %
Synchronous Reads   84 % 81 % 0 %
Pages Read/Minute   270 260 0

Analysis Notes

Recommendation

Recommended size for USERBP8K is 2250 pages, alter generated.



Notes

CodeExplanation
FWhile tuning downward, the Floor size was reached.
CWhile tuning upward, the Ceiling size was reached.
<Decrease Bufferpool Size
>Increase Bufferpool Size
!System is Paging, Increase Bufferpool Size Cancelled.
Paging will only be detected if Wise-GUYTM is installed and has been active during the last seven days.


Key Links

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


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