SQLDBC Trace

SQL Database Connectivity (SQLDBC) is a runtime environment for the development of database applications and database interfaces for MaxDB. Through SQLDBC, applications can access MaxDB database instances, execute SQL statements and edit data. It comprises the runtime library libSQLDBC, the software development kit SQLDBC SDK and the tool sqldbc_cons.

SQLDBC provides, among other things, a comprehensive range of trace options which can be called up using the Database Assistant. The tools user menu (OLTP/ liveCache) contains, among other things, the SQLDBC trace tool.

See also:

SQLDBC Maunal, sqldbc_cons, SQLDBC Traces

Traces compromise performance. Use traces only for troubleshooting and problem analysis.

Procedure

...

       1.      Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10).

       2.      Choose Tools ® SQLDBC Trace.

...

Switch Trace on/off

To switch on the trace, proceed as follows:

       1.      Select the required process.

       2.      Choose one of the following options:

Trace

Contents

SQL (Switch on SQL trace)

SQL statements

(simplest trace, adequate for most analyses)

Short (Switch on short trace)

Method calls

Long (Switch on long trace)

Method calls with call parameters

(most comprehensive trace)

Packet (Switch on packet trace)

Communication packages

       3.      Enter the size of the trace file.

The trace files contain a file name of the form sqldbctrace-<pid>.prt, where <pid> is the process ID. The trace files are overwritten cyclically.

To switch off the trace, select the process for writing to the trace and then select Switch off.

Other Functions

You can choose the name of the trace file. To do this, choose Goto ® Trace Directory.

You can choose the size of the trace file. To do this, choose Goto ® Maximum File Size.

Analyzing and Displaying a Trace

Select the required trace file to analyze the trace. Choose Display file.