Table Buffer Monitor 

Use

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 J2EE Engine cluster.

Integration

You can configure table buffering when you create database tables in the Java Dictionary. For more information, see Creating Tables.

Prerequisites

You must have logged on to the Open SQL Monitors application as a J2EE Engine user from the administrator group.

Activities

To access the Table Buffer Monitor, follow the TableBufferMonitor link on the start page of the Open SQL Monitors application.

On the Accessed Table Buffers screen, you can 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.

To view detailed data about the buffer, select a buffer ID. The detailed data includes the following parameters:

Table Buffer Details

Parameter Name	Description
Ready	Indicates if the buffer is available and ready to be used
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
Size	Total size of the buffer in bytes
Free	Free bytes in the buffer
# Resets	Total number of buffer resets
# Reinstalls	Total number of buffer reinstalls
# Tables	Number of currently buffered tables
# Objects	Number of currently buffered objects
# Requests	Total number of requests against the buffer
# Hits	Total number of requests satisfied using the buffer
LoadQueueSize	Size of the load priority queue, which is used for determining which objects are to be displaced
maxRecordSize	Maximum size of a record
maxLobSize	Maximum size for large objects (LOBs)
ReloadDelay	Indicates the delay for reloading a buffer object
TxCount	Number of active transactions using the buffer
ModCount	Number of active modifications in the buffer
# Displacements	Total number of displacements
DisplBytes	Displaced bytes in the last displacement
DisplData	Displaced data objects in the last displacement
DisplObjects	Displaced buffer objects in the last displacement
DisplTables	Displaced tables in the last displacement
sumDisplBytes	Sum of all displaced bytes since start up
sumDisplData	Sum of all displaced data objects since buffer start up
sumDisplObjects	Sum of all displaced buffer objects since buffer start up
sumDisplTables	Sum of all displaced tables since buffer start up
TraceOn	Indicates if the local trace is activated. This option is used for technical purposes only.
TraceSeverity	Indicates the trace severity; by default, it is ERROR. This option is used for technical purposes only.
PathOn	Indicates if PATH level tracing is activated
DebugOn	Indicates if DEBUG level tracing is activated

 

On the detailed view screen you can use the following options:

·        Show Buffered Objects

Use this function to display all objects that are currently available in the selected table buffer instance.

·        Remove Single Object

Use this function to remove a buffered object. You are required to specify the object name.

·        Reset Buffer

Use this function to invalidate the buffered objects in the relevant table buffer instance.

·        Refresh

Use this function to refresh the display of the table buffer contents.

You can view and modify some of the table buffer parameters using the Offline Configuration Tool or the runtime screen of the Configuration Adapter Service in the Visual Administrator. You can find the property sheets for the table buffer of the relevant instance and DataSource under Configurations ® Open SQL.