You can log all the SQL queries that are issued by the CICS® IA or CICS PA plug-in,
and view the query text, the time when the query was issued, and the
ID of the process thread that executed the query.
About this task
You use the Database Retrieval Debug pane in the Preferences
window to start or stop logging the SQL queries that are issued by
the plug-in, and to open the DB Retrieval Debug view. You use the
DB Retrieval Debug view to view details of the SQL queries that are
logged. You can also use this view to start or stop logging the SQL
queries, and to clear the table of entries in the view.
Procedure
- From the workbench menu bar, click . The Database
Retrieval Debug pane is displayed in the Preferences window:
- To start logging SQL queries, click Yes.
- To stop logging SQL queries, click No.
- To view details of the SQL queries in the DB Retrieval
Debug view, click Open Debug View, then click OK. This view shows the following information:
- Message
- The text of the SQL query
- Date
- The time and date when the SQL query was issued
- Thread ID
- The ID of the process thread that executed the SQL query
- To start or stop logging the SQL queries from the DB Retrieval
Debug view, click the SQL Logging: On or SQL
Logging: Off icon
, as appropriate, in the toolbar of the
view.
- To clear the table of SQL messages in the DB Retrieval
Debug view, click the Clear log table icon
in the toolbar of the view.