ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Subsystem Analyzer for Db2 for Z/OS : Produce a report containing buffer pool information

book

Article ID: 197256

calendar_today

Updated On:

Products

Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Can a report containing buffer pool information be generated using CA Subsystem Analyzer?

Environment

Release : 20.0

Component : CA Subsystem Analyzer for Db2 for z/OS

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 <High.Level>.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

Generate Batch Reports

Report and Unload Parameters