SQLDI

Records SQL statements, RDBMS return codes, COMMIT and ROLLBACK commands, and SQL cursor operations such as PREPARE, OPEN, FETCH, and CLOSE. You can use this trace component with all FOCUS report requests, MODIFY requests, and with native SQL commands.

Has levels 1, 2, and 3.

SQLAGGR

Displays adapter-to-RDBMS aggregation and join analysis. Indicates whether the adapter successfully transferred aggregation and join operations to the RDBMS. You can use it only for FOCUS reporting operations such as TABLE, GRAPH, and MATCH FILE.

When the adapter is able to pass all join, sort, and aggregation operations to the RDBMS, it does not populate the SQLAGGR trace. In this case, the message "AGGREGATION DONE..." appears either at the terminal or in the job output, whichever is appropriate.

Has level 1 only.

STMTRACE

Records SQL SELECT statements generated by the adapter for FOCUS report requests, MODIFY procedures, or Direct SQL Passthru SELECT requests. It also records the SQL Data Definition Language (DDL) statements generated by the CREATE FILE command. You can display the trace information online or store it in a file or sequential data set. This technique can save you time and effort when you create tables and indexes.

The adapter terminates its generated SQL SELECT statements with a semicolon. Therefore, you can submit them to the RDBMS for processing, interactively or in batch, without any modifications. Thus, you can use STMTRACE for debugging, performance tuning, and for capturing SQL Data Definition and Data Manipulation statements to reuse.

Has levels 1 and 2.

SQLCALL

Traces commands and data exchange between the physical and the logical layers of the adapter.