BTSTASM1 SYSVIEW for DB2 Batch Reporting Query
Article ID: 274315
Updated On:
Products
Issue/Introduction
Running the DB2 Statistics Batch Report BTSTASM1 to find out the HWM for MAXDBAT Usage. The Output Report contains a section " DISTRIBUTED DATA FACILITY " which has a field for MAX DBAT for ACTIVE and INACTIVE.
This value seems to remain the same until DDF is restarted. For Example, if for Monday the Maximum DBAT had reached the limit say 500, the report shows 500. When the report is run say for the next Friday, even though the Maximum DBAT hasn't reach 500 on Friday, the report still shows 500.
It seems like this field is not getting reset unless DDF is restarted. Is it possible to find an exact value for the Maximum DBAT that was used for each day for some performance analysis?
Environment
Release : 20.0
Resolution
The only way to get Maximum DBAT values daily is via an online report. There is no batch version.
It is the HSUSVCS screen "Thread Counts History Summary "
Select
2 System History add a Time Range of a whole Day
PF6 for Summary select 6 More select 6 Thread and Command Counts to see HSUSVCS screen
HWM Maxdbat Threads Max Int
Max is the Maximun Int is the Maximum for the interval which is a whole day if that is what is selected.
Be aware you must have this parm set. HWM-SAMP-INT=nn must be set. see Tracing Parameters.
Note this is an online figure only. The HWM values are available online only for the current and past subsystem history intervals.
Feedback
