Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Overview of automatic monitoring and corrective actionsYou can use the SQL administration API, the Scheduler, and drill-down queries to manage automatic maintenance, monitoring, and administrative tasks.
Query drill-downYou can use query drill-down, or SQL tracing, to gather statistical information about each SQL statement that was run and to analyze statement history.
Enable global SQL tracing for a sessionYou can enable global SQL tracing for the current session by running the SQL administration API task() or admin() function.

Enable global SQL tracing for a session

You can enable global SQL tracing for the current session by running the SQL administration API task() or admin() function.

You must be connected to the sysadmin database as user informix or another authorized user.

By default, global SQL tracing is not enabled. You can set the SQLTRACE configuration parameter to permanently enable global tracing.

To enable global user SQL history tracing for the current database server session, run the SQL administration API task() or admin() function with the set sql tracing on argument.

Example

The following example enables global low-level SQL tracing for all users:

EXECUTE FUNCTION task("set sql tracing on", 1000, 1,"low","global");

If a new user logs on to the system after your statement runs, you can enable tracing for the new user. See Enable SQL tracing.

For more information about the task() and admin() functions, see the HCL OneDB™ Guide to SQL: Syntax.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.