Open SQL Monitors 

Use

When Open SQL for Java is used to access a database, it is important to trace how the communication with the persistence store is handled. With the Open SQL Monitors, you can monitor the execution of SQL statements, the status of the table and catalog buffers, as well as the availability and the use of Open SQL database connections.

Prerequisites

You are in the Problem Management → Database → Open SQL Monitors function.

Features

The Open SQL Monitors function comprises the following monitors:

·        SQL Trace Administration

·        SQL Trace Evaluation

·        Connection Monitor

·        Catalog Buffer Monitor

·        Table Buffer Monitor

·        Sync Log Monitor

·        Table Statistics Monitor

·        Open SQL Statistics

·        Native DB Monitors

Activities

In the Open SQL Monitors function, you can sort and filter data:

●      To sort tables by individual columns in ascending or descending order, click the column header.

●      To filter tables, choose . A blank line appears in the table. Enter the appropriate filter string in the line and choose Enter.

You can obtain additional information for table data from the column tooltips.