Trace Mode

The Trace Mode option is displayed for HCL Informix® 11.50.xC3 and later.

• Select Global to trace SQL statements for the entire server. SQL Explorer can display information for all databases and user sessions, except those specified in the Database Tracing and User Tracing lists.
• Select User to trace SQL statements for a list of databases or user sessions. SQL Explorer can display information for only the databases and user sessions specified in the Database Tracing and User Tracing lists, unless these lists are empty.
  • To show the Database Tracing or User Tracing lists, click Show. To hide the lists, click Hide.
  • To modify the Database Tracing lists:
    • Add a database: From the Untraced Databases list, select a database name, and click +. The database name is displayed in the Traced Databases list.
    • Delete a database: From the Traced Databases list, select a database name, and click -. The database name is displayed in the Untraced Databases list.
  • To modify the User Tracing lists:
    • Add a user: From the Untraced list, select a database name, and click +. The database name is displayed in the Traced Databases list.
    • Delete a user: From the Traced Databases list, select a database name, and click -. The database name is displayed in the Untraced Databases list.