COMM (Communicate with Multi-User Facility) › COMM EOJ (End Multi-User Facility Processing) › Summary Reports Produced › Accounting Facility Summary Information

Accounting Facility Summary Information

If the Accounting Facility is generated in this Multi-User Facility and 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

The buffer parameter specified for this table.

DATABASE

Database ID containing the accounting table.

ENTRIES RECLAIMED

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

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

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 due to the threshold parameter of the Multi-User startup option ACCT being 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 entries unavailable.

Tuning Information:
To decrease this value, increase the buffer parameter value, decrease the complexity of the key, or both.

LOCATES

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

LOCATES INITIATED

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