IDB2 DDF TRANSACTION COUNT REPORT
Article ID: 236413
Updated On:
Products
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
Feedback
