Previous Topic: Memory Resident Data Facility Summary InformationNext Topic: XCF Summary Information


Accounting Facility Summary Information

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:

ADDS

Displays the number of new records added to the Accounting table.

Tuning Information:
To decrease this number, decrease the complexity of the key.

CORE SIZE

Displays the buffer parameter specified for this table.

DATABASE

Displays Database ID containing the Accounting table.

ENTRIES RECLAIMED

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.

ENTRY UNAVAILABLE

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.

EXCLUSIVE CONTROL CONFLICTS

Displays the number of entries in the Accounting table that had exclusive control held by a user application when a spill was initiated.

EXCPS

Displays the number of execute channel programs (EXCPs) issued for this Accounting table.

Tuning Information:
This value is adversely affected by:

INTERNALLY INITIATED SPILLS

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.

LOCATES

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).

LOCATES INITIATED

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.

NUMBER OF ENTRIES

Displays the number of entries in the in-memory accounting buffer (always odd).

REQUESTS PROCESSED

Displays the number of times this Accounting table was used. This value is determined by the conditional expression, if there is one.

SKIPPED DUE TO EXCLUSIVE

Displays the number of entries that were not immediately processed due to exclusive control conflicts.

SPILLS INITIATED TO AXXTHLD

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.

TABLE NAME

Displays the name of the Accounting table.

UPDATES

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.