This table is for the Accounting Facility. It provides the startup information and the current information about each Accounting table. One row exists for each Accounting table defined as a startup option.
Before Version 12.0, you could perform certain kinds of maintenance (inserts and deletes) on this table, but beginning with Version 12.0, that functionality has been moved to the SQL_CONSOLE (SQX) Dynamic System Table.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
BUFFER_SIZE |
INTEGER |
No |
The size of the buffer as provided in the startup option. |
|
CONFLICTS
|
INTEGER |
No |
Number of entries in the Accounting table that had exclusive control held by a user application when a spill was initiated. |
|
DBID
|
SMALLINT |
No |
The database ID containing this Accounting table. |
|
ENTRIES
|
INTEGER |
No |
Number of entries in the in-memory Accounting buffer. |
|
LOCATES
|
INTEGER |
No |
Number of entries retrieved into the Accounting buffers including existing entries in the Accounting table with reclaimed internal space. |
|
LOCATES_STARTED
|
INTEGER |
No |
Number of times that a group of locates were performed for the Accounting table. |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the MUF job name. |
|
PHYSICAL_READWRITE
|
INTEGER |
No |
Physical I/O (EXCPs) issued on behalf of requests for this Accounting table. |
|
RECLAIMED
|
INTEGER |
No |
Number of in-memory table entries reused after a spill, that is, the number of entries for which a LOCATE was not required. |
|
SKIPPED
|
INTEGER |
No |
Number of entries that were not immediately processed due to exclusive control conflicts. |
|
SPILLING
|
CHAR(1) |
No |
Indicates whether this Accounting table is currently being spilled. |
|
SPILLS_INTERNAL
|
INTEGER |
No |
Number of spills initiated to decrease the number of entries unavailable. |
|
SPILLS_THRESHOLD
|
INTEGER |
No |
Number of times that the threshold parameter value was exceeded and a spill was done. |
|
TABLE_NAME |
CHAR(3) |
No |
Name of the Accounting table. |
|
TABLE_STATUS
|
CHAR(1) |
No |
Current Accounting table status. Contains O for open or C for closed. |
|
THRESHOLD
|
INTEGER |
No |
Current value (nnnnn) of the threshold counter. Defines how long changes to an Accounting table can be buffered in the Accounting buffer before being spilled to the normal buffers. |
|
TOTAL_ADDS
|
INTEGER |
No |
Number of adds which were done to this Accounting table. |
|
TOTAL_REQUESTS
|
DECIMAL(13,0) |
No |
Number of times this Accounting table was used. This value is determined by the conditional expression, if there is one. |
|
TOTAL_UPDATES
|
INTEGER |
No |
Number of times that records in the Accounting table were updated. |
|
UNAVAILABLE
|
INTEGER |
No |
Number of user application requests that had to wait due to insufficient memory allocated by the buffer parameter. |
|
Copyright © 2014 CA.
All rights reserved.
|
|