Table buffering is an important feature of Open SQL. The Table Buffer Monitor can provide you with statistics about the status and the use of the table buffer instances within the AS Java cluster. On the Accessed Table Buffers screen, you choose the table buffer whose statistics you want to display. A separate table buffer instance is available for each Java instance. Basic information about the table buffer, including its unique identifier, its size, the number of buffered objects, the number of requests and hits, and the buffer efficiency percentage, is available on this screen.
You are in Problem Management → Database → Open SQL Monitors → Table Buffer Monitor.
...
To view detailed data about the buffer, select a buffer ID. The Table Buffer Details screen area displays detailed data about the selected buffer in three tabs, Administration, Displacement, and Buffered Objects.
To view administration details, choose the Administration tab. The Administration tab displays the following parameters:
General Administration
Parameter Name |
Description |
Startup Date |
Indicates when the buffer was started. |
Reset Date |
Indicates when the buffer has been last reset. |
Reinstall Date |
Indicates when the buffer has been last reinstalled |
Resets |
Total number of buffer resets |
Reinstalls |
Total number of buffer reinstalls |
Is Ready |
Indicates if the buffer is available and ready to be used. |
Storage Information
Parameter Name |
Description |
Max Buffer Size |
Total size of the buffer in bytes |
Free Bytes |
Free bytes in the buffer |
Max Lob Size |
Maximum size for large objects (LOBs) |
Reload Delay |
Indicates the delay for reloading a buffer object |
Number of Objects |
Number of currently buffered objects |
Number of Tables |
Number of currently buffered tables |
Max Record Size |
Maximum size of a record |
Access Statistics
Parameter Name |
Description |
Requests |
Total number of requests against the buffer. |
Hits |
Total number of requests satisfied using the buffer. |
Efficiency |
Access efficiency in percents. |
Number of modified Objects |
Number of active modifications in the buffer. |
Number of modifying Transactions |
Number of active transactions using the buffer. |
To view displacement details, choose the Displacement tab. The Displacement tab displays the following parameters:
General Statistics
Parameter Name |
Description |
Is Displacement On |
|
Number of Displacements |
Total number of displacements. |
Interval Statistics
Parameter Name |
Description |
Displaced Objects |
Displaced buffer objects in the last displacement. |
Displaced Tables |
Displaced tables in the last displacement. |
Size of Load Queue |
Size of the load priority queue, which is used for determining which objects are to be displaced. |
Displaced Data |
Displaced data objects in the last displacement. |
Displaced Bytes |
Displaced bytes in the last displacement. |
Summary Statistics
Parameter Name |
Description |
Displaced Objects |
Sum of all displaced buffer objects since buffer start up. |
Displaced Tables |
Sum of all displaced tables since buffer start up. |
Displaced Data |
Sum of all displaced data objects since buffer start up. |
Displaced Bytes |
Sum of all displaced bytes since start up. |
To view buffered objects in the selected table buffer, choose the Buffered Objects tab.