Produce a report containing buffer pool information using Subsystem Analyzer
Article ID: 197256
Updated On:
Products
Subsystem Analyzer for DB2 for z/OS
Issue/Introduction
Can a report containing buffer pool information be generated using Subsystem Analyzer for Db2 for z/OS (PSA)?
Resolution
Buffer Pool information captured by Subsystem Analyzer can be viewed in a Batch report. It can be generated using the PSABATCH member in the hlq.CDBAJCL library.
The necessary report parameters are:
//SYSIN DD *
VCAT=<High.Level>
DATASTORE=Datastore Name
SSID=ssid
REPORT=BP
FORMAT=DETAIL
Below is a sample snippet of the report generated in batch for one bufferpool on the subsystem.
PSA 20.0 Subsystem Analyzer Page 1
DB2-ssid Buffer Pool Detail Report yyyy/mm/dd
Interval Date => yyyy/mm/dd Time => hh:mm:ss Elapsed => 00:00
Buffer Pool ==> BP0
Buffer Pool Size Information
----------------------------
VP size defined 40000K
VP allocated 0K
VP inuse/updated 0K
Buffer Pool Thresholds Defined
------------------------------
VP seq threshold 80 IOP seq threshold 50
Deferred write threshold 30 Vertical DW threshold 5
Buffer Pool Read Access Activity
--------------------------------
Getpage total reqs 105 Seq pfetch reqs 0
Getpage seq access reqs 7 Seq pfetch read I/O reqs 0
Synch read reqs 7 Seq pfetch read ratio ....... .0
Synch read via seq access 0 Seq pfetch pages read 0
Getpage/sync read ratio 15.0 Seq pfetch pages per I/O ....... .0
List pfetch reqs 0 Dyn pfetch reqs 0
List pfetch read I/O reqs 0 Dyn pfetch read I/O reqs 0
List pfetch read ratio ....... .0 Dyn pfetch read ratio ....... .0
List pfetch page read 0 Dyn pfetch pages read 0
List pfetch pages per I/O ....... .0 Dyn pfetch pages per I/O ....... .0
Buffer Pool Write Access Activity
---------------------------------
Update buffer reqs 0 Immediate write reqs 0
Pages written ....... .0 Async write I/O reqs 0
Buffer Pool Paging and Threshold Activity
-----------------------------------------
Page in for read reqs 0 Page in for write reqs 0
DWTH threshold reached 0 Vertical DWTH reached 0
eqpf disable/no buffer 0 Seqpf disable/read engine 0
DMTH threshold reached 0 0
HSM recall reqs 0 Getpage failed/VP full 0
HSM recall req timeouts 0 Expansion failed/storage
Buffer Pool Alter Activity
--------------------------
Alter Virtual Pool size 0
Buffer Pool Sort/Merge Activity
-------------------------------
Pfetch resources exceeded 0 Merge passes requested 0
Pfetch failed/zero pf qty 0 Merge wfiles requested 0
PSA 20.0 Subsystem Analyzer Page 2
DB2-ssid Buffer Pool Detail Report yyyy/mm/dd
Interval Date => yyyy/mm/dd Time => hh:mm:ss Elapsed => 00:00
Buffer Pool ==> BP0
Destructive read reqs 0 Merge wfile req degraded 0
Removed from DW queue 0 Merge wfile req failed 0
Max concurrent work files 4
Buffer Pool Query Parallelism Activity
--------------------------------------
Parallel query requests 0 Queries reduced - buffers 0
Max prefetch I/O streams 0 Streams reduced - buffers 0
Pfetch qnty cut to 50% 0 Cond getpage failed 0
Pfetch qnty cut to 25% 0
If instead of FORMAT=DETAIL, FORMAT=SUMMARY is used this is a sample of that report:
PSA 20.0 Subsystem Analyzer Page 1
DB2-ssid Buffer Pool Summary Report yyyy/mm/dd
Interval Date => yyyy/mm/dd Time => hh:mm:ss Elapsed => 00:00
BPId VP_Alloc BufHit Getpage Getpage_SQ Sync_RIO SyncRIO_SQ
------ -------- ------ ---------- ---------- ---------- ----------
BP0 0K 93.3% 105 7 7 0
PSA 20.0 Subsystem Analyzer Page 2
DB2-ssid Buffer Pool Summary Report yyyy/mm/dd
Interval Date => yyyy/mm/dd Time => hh:mm:ss Elapsed => 00:00
BPId VP_Alloc BufHit Getpage Getpage_SQ Sync_RIO SyncRIO_SQ
------ -------- ------ ---------- ---------- ---------- ----------
BP0 0K 97.0% 23499010 7125727 712851 48762
BP1 0K 100.0% 257 256 0 0
BP16K0 0K 25.0% 4 0 3 0
BP2 0K 100.0% 2 0 0 0
BP3 0K 100.0% 96 0 0 0
BP32K 0K 95.6% 135 32 6 0
BP8K0 0K 83.8% 37 0 6 0
Additional Information
Feedback
Yes
No
Powered by
