If the Accounting Facility is generated in this MUF and not disabled, an Accounting report follows the MRDF report.
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
This page of the report shows the following information:
Displays the number of new records added to the Accounting table.
Tuning Information:
To decrease this number, decrease the complexity of the key.
Displays the buffer parameter specified for this table.
Displays Database ID containing the Accounting table.
Displays Number of in-memory table entries reused after a spill, that is, 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.
Displays the number of user application requests that had to wait due to insufficient memory allocated by the buffer parameter.
Tuning Information:
To decrease this critical value, decrease the complexity of the key, increase the value of the buffer parameter, or both.
Displays the number of entries in the Accounting table that had exclusive control held by a user application when a spill was initiated.
Displays the number of execute channel programs (EXCPs) issued for this Accounting table.
Tuning Information:
This value is adversely affected by:
Displays the number of spills initiated to decrease the number of entries unavailable.
Tuning Information:
To decrease this value, increase the buffer parameter value, decrease the complexity of the key, or both.
Displays the number of entries retrieved into the accounting buffers including existing entries in the Accounting table with reclaimed internal space.
Tuning Information:
To minimize this number, decrease the complexity of the key, if the number of adds is high, or increase the size of the buffer parameter, if the number of updates is high (see UPDATES).
Displays the number of times that a group of locates were performed for the Accounting table. This parameter is not applicable to tuning and is for use by CA Support.
Displays the number of entries in the in-memory accounting buffer (always odd).
Displays the number of times this Accounting table was used. This value is determined by the conditional expression, if there is one.
Displays the number of entries that were not immediately processed due to exclusive control conflicts.
Displays the number of times that the threshold parameter value of the MUF 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.
Displays the name of the Accounting table.
Displays the 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 of these.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|