Switching between Live and Saved Data

Switch between live SQL trace data and saved SQL trace data for a period that you specify.

To view SQL trace data, you must turn on SQL tracing. On the Tracing Admin page, set the Trace State to On. See Turning on SQL tracing.

To switch to saved data:

  1. On the menu of the HCL OpenAdmin Tool (OAT) for Informix®, expand Performance Analysis and then click SQL Explorer.
  2. To display historical SQL tracing data, click Switch to Saved Data.
  3. To set the time period for the historical data, specify the date and time in the Start and End fields.
  4. To return to the current data, click Switch to Live Data.
Parent topic: Analyzing query performance with SQL Explorer
Copyright© 2018 HCL Technologies Limited