Show TOC Start of Content Area

Component documentation Open SQL Monitoring  Locate the document in its SAP Library structure

Purpose

When Open SQL for Java is used to access a database, it is important to be able to trace how the communication with the persistence store is handled. The J2EE Engine provides a set of functions that enable you to 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.

Integration

Open SQL Monitors are available as a single Web-based application, which is deployed on the J2EE Engine at installation.

To access the start page of the application, you must enter the following URL in your browser: http://<host>:<HTTPport>/OpenSQLMonitors.

This graphic is explained in the accompanying text http://localhost:50000/OpenSQLMonitors

To be able to use the Open SQL monitors, you must log on as a J2EE Engine user from the administrator group.

This graphic is explained in the accompanying text

Only administrators can use Open SQL monitoring functions.

Features

The Open SQL Monitors application provides the following functions:

·        SQL Trace

·        Table Buffer Monitor

·        SyncLog Monitor

·        Connection Monitor

·        Catalog Buffer Monitor

 

End of Content Area