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.