Using 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 Troubleshooting  Database   Open SQL Monitors function.

Procedure

You can use the following Open SQL monitors:

• SQL Trace Administration

  For more information, see Managing the SQL Trace .

• SQL Trace Evaluation

  For more information, see Evaluating SQL Traces .

• Connection Monitor

  For more information, see Connection Monitor .

• Catalog Buffer Monitor

  For more information, see Catalog Buffer Monitor .

• Table Buffer Monitor

  For more information, see Table Buffer Monitor .

• Sync Log Monitor

  For more information, see Sync Log Monitor .

• Table Statistics Monitor

  For more information, see Table Statistics Monitor .

• Open SQL Statistics

  For more information, see Open SQL Statistics .

• Native DB Monitors

  For more information, see Native DB Monitors .

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 .