Commit report
The Commit report supplies information about commit frequency for application tuning and system performance purposes.
Depending upon the report ordering, counts are maintained for each unit of recovery to indicate the activity volume between commit points. Log Master reports present only the data defined by your time frame and filter. The Commit report contains only committed transactions and cannot include aborted transactions.
Use the Commit report to determine whether
- batch jobs are not committing changes according to standards or performance recommendations
- online transactions are performing too many operations in a given unit of work
To request a Commit report, from any task dialog (any option from 0 through 7 under the Actions category on the Main Menu), select the Define Report and File Outputs option, and then, on the Output Options panel, select Commit.
Following figure shows an example of a Commit report (descending):
Time: 16.45.35 Copyright BMC Software, Inc. 1995-2020
Commit Report, By Activity (Descending)
----------------------------------------------------------------------------
From: Mark DB2DBA.COMMROLL.ONE(0) (x'C32EEACF7C2A')
To: Mark DB2DBA.COMMROLL.FOUR(0) (x'C32EEB3FC683')
----------------------------------------------------------------------------
Report Information:
Work ID : DB2DBA.$$WORKID0003 Run Number: 2 Subsystem: DXW
Description: DB2DBA GENERATE MONTHLY REPORTS
----------------------------------------------------------------------------
URID LRSN: x'C32EEAFD955E' End: x'C32EEAFE8AA8' Data Sharing Member: DXW2
URID : x'001126252A0E' Date: 2020-08-18 Time : 16.40.31.389
URID(End): x'00112627245E' Date: 2020-08-18 Time : 16.40.32.393
Status : Committed Conn Type: BATCH Conn ID : BATCH
Plan Name: DSNTEP2 Auth ID : DB2DBA2 Corr ID : DB2DBAUC
Ins : 0 Del : 0 Upd : 1,559
Exc : 0
Ins/Tr: 0 Del/Tr: 0 Upd/Tr: 0
Tot : 1,559 Del/RI: 0 Upd/RI: 0
URID LRSN: x'C32EEB2DBBC8' End: x'C32EEB2E106F' Data Sharing Member: DXW2
URID : x'00112645956A' Date: 2020-08-18 Time : 16.41.21.878
URID(End): x'001126465907' Date: 2020-08-18 Time : 16.41.22.224
Status : Committed Conn Type: BATCH Conn ID : BATCH
Plan Name: DSNTEP2 Auth ID : DB2DBA2 Corr ID : DB2DBAVC
Ins : 0 Del : 0 Upd : 584
Exc : 0
Ins/Tr: 0 Del/Tr: 0 Upd/Tr: 0
Tot : 584 Del/RI: 0 Upd/RI: 0
URID LRSN: x'C32EEAD8753C' End: x'C32EEAD8CDEB' Data Sharing Member: DXW2
URID : x'0011260B1A3C' Date: 2020-08-18 Time : 16.39.52.460
URID(End): x'0011260B38C7' Date: 2020-08-18 Time : 16.39.52.823
Status : Committed Conn Type: BATCH Conn ID : BATCH
Plan Name: DSNTEP2 Auth ID : DB2DBA2 Corr ID : DB2DBAUC
Ins : 0 Del : 0 Upd : 78
Exc : 0
Ins/Tr: 0 Del/Tr: 0 Upd/Tr: 0
Tot : 78 Del/RI: 0 Upd/RI: 0
URID LRSN: x'C32EEB011DBF' End: x'C32EEB01B22B' Data Sharing Member: DXW2
URID : x'001126272492' Date: 2020-08-18 Time : 16.40.35.093
URID(End): x'001126273D1C' Date: 2020-08-18 Time : 16.40.35.701
Status : Committed Conn Type: BATCH Conn ID : BATCH
Plan Name: DSNTEP2 Auth ID : DB2DBA2 Corr ID : DB2DBAUC
Ins : 0 Del : 0 Upd : 78
Exc : 0
Ins/Tr: 0 Del/Tr: 0 Upd/Tr: 0
Tot : 78 Del/RI: 0 Upd/RI: 0
This section contains the following topics:
Related topic