Previous Topic

Next Topic

Inhoudsopgave

Book Index

Trace Categories Overview

The following table presents an overview of the different types of activity that can be traced using Isah Monitor.

Trace Category

Displays

Prepared Query Statements

Prepared statements to be sent to the server.

Executed Query Statements

Statements to be executed by the server. Note that a single statement may be prepared once and executed several times with different parameter bindings.

Input Parameters

Parameter data sent to servers when running stored procedures according to these parameters.

Fetched Data

Data retrieved from servers.

Statement Operations

Each operation performed such as ALLOCATE, PREPARE, EXECUTE, and FETCH

Connect / Disconnect

Operations associated with connecting and disconnecting to databases, including allocation of connection handles, freeing connection handles, if required by server.

Transactions

Transaction operations such as BEGIN, COMMIT, and ROLLBACK (ABORT).

Blob I/O

Operations on Blob data types, including GET BLOB HANDLE, TORE BLOB, and so on.

Miscellaneous

Operations not covered by other categories.

Vendor Errors

Error messages returned by the server. The error message may include an error code, depending on the server.

Vendor Calls

Actual API function calls to the server.

By viewing the results of the Executed Query Statements, you can retrieve information about the time that is taken to carry out an activity. You can then compare it to the time that is taken to complete the data transport involved. This provides additional information about your network capacity.

Note: It is recommended that you only enable the Fetched Data option when it is actually required.