Accounting Facility Summary Information

The
COMM EOJ
function in
Datacom
DBULTY ends with EOJ summary reports written to the SYSPRINT file, including an Accounting Summary report. Review a sample page and field descriptions.
If the Accounting Facility is generated in this Multi-User Facility and is not disabled, an Accounting report follows the MRDF report.
Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** ACCOUNTING SUMMARY INFORMATION TABLE NAME: A04 DATABASE: 5 REQUESTS PROCESSED: 7 EXCPS: 14 LOCATES: 6 ADDS: 0 UPDATES: 3 ENTRY UNAVAILABLE: 0 EXCLUSIVE CONTROL CONFLICTS: 0 SKIPPED DUE TO EXCLUSIVE: 0 CORE SIZE: 65,536 NUMBER OF ENTRIES: 613 ENTRIES RECLAIMED: 0 LOCATES INITIATED: 1 SPILLS INITIATED TO AXXTHLD: 0 INTERNALLY INITIATED SPILLS: 0
ADDS
Number of new records added to the accounting table
Tuning Information:
To decrease this number, decrease the complexity of the key.
CORE SIZE
Buffer parameter specified for this table
DATABASE
Database ID containing the accounting table
ENTRIES RECLAIMED
Number of in-memory table entries that are reused after a spill: the number of entries for which a LOCATE was not required
Tuning Information:
To increase this number, increase the buffer parameter, decrease the complexity of the key, or both.
ENTRY UNAVAILABLE
Number of user application requests that had to wait because the buffer parameter allocated insufficient memory
Tuning Information:
To decrease this critical value, decrease the complexity of the key, increase the value of the buffer parameter, or both.
EXCLUSIVE CONTROL CONFLICTS
Number of entries in the accounting table that had exclusive control held by a user application when a spill was initiated
EXCPS
Number of execute channel programs (EXCPs) issued for this accounting table
Tuning Information:
This value is adversely affected by:
  • The number of records processed
  • The number of spills initiated because the threshold parameter of the Multi-User startup option ACCT was exceeded
  • The value of the buffer parameter of the ACCT option being too small.
INTERNALLY INITIATED SPILLS
Number of spills initiated to decrease the number of unavailable entries
Tuning Information:
To decrease this value, increase the buffer parameter value, decrease the complexity of the key, or both.
LOCATES
Number of entries retrieved in the accounting buffers, including existing entries in the accounting table with reclaimed internal space.
Tuning Information:
To minimize this number:
  • If the number of adds is high, decrease the complexity of the key.
  • if the number of updates is high (see UPDATES), increase the size of the buffer parameter.
LOCATES INITIATED
Number of times that a group of locates were performed for the accounting table. This parameter is not applicable to tuning; it is for use by Technical Support.
NUMBER OF ENTRIES
Number of entries in the in-memory accounting buffer (always odd)
REQUESTS PROCESSED
Number of times this accounting table was used. This value is determined by the conditional expression, if there is one.
SKIPPED DUE TO EXCLUSIVE
Number of entries that were not immediately processed due to exclusive control conflicts.
SPILLS INITIATED TO AXXTHLD
Number of times that the threshold parameter value of the Multi-User startup option ACCT was exceeded. This value is reset after each internally initiated spill.
Tuning Information:
To decrease this value, increase the threshold parameter value.
TABLE NAME
Name of the accounting table
UPDATES
Number of times that records in the accounting table were updated
Tuning Information:
To decrease this value, increase the buffer and threshold parameters, decrease the complexity of the key, or perform all these.