Additional Trace Settings
Two additional server traces that are often useful when debugging
Maintain applications are MNTDBMS and STMTRACE.
- SET TRACEON=MNTDBMS
provides information on DBMS database activity by displaying the
setup for calls to DB I/O services.
- SET TRACEON=STMTRACE/1
and STMTRACE/2 trace SQL syntax by displaying SQL syntax traces
(/1 statement, /2 substatement).
MTDBMS can be found under the Maintain Programmer Traces heading;
STMTRACE is available under the Command Processing heading.