IT31554: SQL TRACING IS NOT GETTING ENABLED IN INFORMIX HQ SCHEDULER

APAR status

• Closed as fixed if next.

Error description

• While evaluating Sqltracing in Informix HQ and configure the
  save by the job Save Sql Trace in HQ. The start of the trace is
  working. However, a configuration of the Save SQl Trace job in
  the scheduler does not work. If the button 'Edit' is activated,
  the fields, checkboxes ('Enabled ') can be edited, but user
  cannot save (Save button is saved with' Save SQL Trace '
  disabled). For other jobs, the Save Button is active.
  
  When the Save SQL Trace job is activated by SQL in the ph task,
  data is collected, but user cannot see this data in HQ. So far,
  we assume that in HQ the stored/historical data can be
  controlled by the date settings in the mask. that doesn't work.
  It does not find any data, even though it can be found in the
  tables (mon syssqltrace, mon syssqltrace iter)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * customer as they are not able to see statements under SQL    *
  * tracing in informix HQ UI.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Future Consideration: If we are able to identify user        *
  * tasks/sensors from system ones, we will allow the two        *
  * mentioned things to be editable and reflect the changes made *
  * in those to the back-end.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• Future Consideration: If we are able to identify user
  tasks/sensors from system ones, we will allow the two mentioned
  things to be editable and reflect the changes made in those to
  the back-end.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels