PM84490: DQM BASED NATIVE SQL/MDX STATEMENTS DON'T GET WRITTEN TO COGIPF_NATIVEQUERY ALTHOUGH LOGGING/LOGGING TO AUDIT HAS BEEN ACTIVATED

APAR status

• Closed as program error.

Error description

• Customer activated DQM related native SQL/MDX logging via
  xqe.diagnosticlogging.xml. As DQM execution is started via
  Report/Batch Report Processes "Audit the native query for report
  service" and Audit the native query for batch report service"
  have been activated.?Expectancy is that native SQL gets logged
  to the audit db / COGIPF_NATIVEQUERY. The native output gets
  cleanly written to the dqm logs, but not to the audit database.?
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1.1 Fix Pack  *
  * 3                                                            *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  COG ADMINISTRAT

• Fixed component ID

  5724W12AD

Applicable component levels

• RA11 PSN

     UP