Missing BUFSIM option

book

Article ID: 6880

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

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

Environment

Release:
Component: CIDB

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