Select PeopleTools, Utilities, Debug, Trace SQL to access the Trace SQL page.
You use this page to change the SQL tracing options while you're online. Your Configuration Manager settings are not affected:
- Trace SQL Statement
-
Select to show the SQL statement.
- Trace SQL Bind
-
Select to show bind values for SQL statements that have parameter markers.
- Trace SQL Cursor
-
Select to show connect, disconnect, commit and rollback calls.
- Trace SQL Fetch
-
Select to show fetch call for Select Statement.
- Trace SQL API
-
Select to show other API calls (Execute, Describe, and so on.)
- Trace SQL Set Select Buffer
-
Select to show Binds for Select columns.
- Trace SQL -- Database Level
-
Select to specify low-level tracing at the database API (ODBC, ct-lib, and so on.)
- Trace SQL -- Manager Level
-
Select to show calls for Cache calls.
The check boxes on the Trace SQL page correspond to options on the Trace tab in the Configuration Manager. However, the selections that appear on this page do not necessarily reflect those that are made in the Configuration Manager. The displayed page selections are not enabled until you save the page.
To enable or disable SQL tracing while online:
Select or deselect the desired trace options.
-
Save the page.
If you select any of the check boxes, the system starts writing to the trace file.