Missing BUFSIM option

Document ID:  TEC1107817
Last Modified Date:  07/11/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA SYSVIEW Performance Monitor for DB2 for z/OS

Components

  • CA Insight Database Performance Monitor for DB for z/OS:IDB2
  • Common Insight Services:CIDB
Problem:

Do you know why /BUFSIM Simulated Buffer Pool Statistics displays on some R19 DB2s Datacollector  but not others as shown below? 

Menu Print Tools Help CA SYSVIEW for DB2 DB51 D381 05/23/17 20:28:00 19.0 D381 XBTPPF8 

1 Exceptions 2 Thresholds 3 Read/Write 4 Workfiles 5 Files 

 

 

Menu Print Tools Help CA SYSVIEW for DB2 DB22 SYSD 05/23/17 20:26:08 19.0 SYSD XBTPPF8 

1 Exceptions 2 Thresholds 3 Read/Write 4 Workfiles 5 Files 6 Simulate 

 

R/BUFSIM Simulated Buffer Pool Statistics - Accum 

Accum 

BUFFER POOL BP1 Real Simulated % Pct PAGES IN USE Current Maximum 

Allocated size (bufs) 500000 500000 0.00 All 0 0 

Seq Steal Threshold 10 0 Sequential 0 0 

SPSIZE: Sim Increase 0 *OFF* 

Getpages/Sync Reads 99.2 99.2 0.00 

 AVOIDABLE READ I/O Avoided Real Simulated % Saved 

Random pages Synch I/O 0 224455K 224455K 0.00 

Sequential pages Synch I/O 0 14985531 14985531 0.00 

Prefetch pages Asynch I/O 0 3437563K 3437563K 0.00 

Random pages Synch GBP read 0 

Seq pages Synch GBP read 0 

Pref pages Asynch GBP read 0 

Synch Read I/O Wait time 0.00 

 Pages moved into Sim BP 0

Resolution:

BUFSIM option is available only when DB2VER is set to 11.1 or higher. For the above example where BUFSIM was missing, user was running DB2V10 as displayed in the output of the data collector: 

DBG37001I DB51 03:47:58 DATA COLLECTOR CONNECTED TO DB2 SUBSYSTEM DB51. DB2 RELEASE 10.1 L

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >