IDB2 DDF TRANSACTION COUNT REPORT
search cancel

IDB2 DDF TRANSACTION COUNT REPORT

book

Article ID: 236413

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite

Issue/Introduction

Is there a batch report that give total number of DDF transactions in a daily basis? Something like the 

following thread history for specific period on a daily basis for the last several months.. 

---------------------------------------------------------------------------------------------------------------

 Menu  Print  Tools  Help    CA SYSVIEW for DB2  PROD EDJB     02/16/22 09:10:56     
                                 20.0            PROD                   DBA0132      
    1 Select by PF Key   2 All System Intervals  3 All Accounting Intervals          
                                                                                     
 Actions:  S=Select for more detail, T=Thread history for connection type            
 R/HSTLSTAA      Accounting by Connection History List                  Row 1/45     
 SORT N/A                                                                            
 From 02/15/22 10:30:00 To 02/16/22 09:00:00                                         
   End          Connection  Trans      Commits    App Elap   DB2 Elap  Tot DB2 CP   DB2 CP  
   Time         Type             Count    Aborts        HHHH:MM:SS HHHH:MM:SS HHHH:MM:SS HHHH:MM:SS
   --------       ----------        -------      ----------       ----------     ----------      ----------         ----------
 . 11:00:00   ALL           10906K     17335064  308:39:29   18:07:47    4:28:18        3:39:40
 . 11:30:00   ALL           10266K     16372856  304:33:03   16:17:09    4:25:25        3:40:21
 . 12:00:00  ALL          9857506     15789599  272:58:42   13:00:17    4:12:58        3:29:56
 . 12:30:00  ALL          8978681     14261899  244:40:02   10:46:11    3:42:25        3:04:18

-----------------------------------------------------------------------------------------------------------------------------------------

 

 

 

Environment

Release : 20.0

Component : SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

Searching using DDF count found the following six batch IQL. Please check to see if any give you DDF transaction count report. Remember none of these may give you what you want but can give you a start to customize your own.

Any of the following Batch IQL can be used as starting point to customize one that will meet the desired report: BTACTSML,BTACTTRL,BTRECTRC,BTSTASM1,BTSTATR1 and BTSYSPRM