Question & Answer
Question
Why does Cognos SQL runs multiple time on the Database for a single query ?
Answer
When you enable a SQL trace on the database there are so many events that gets triggered for a single SQL statement. So when you trace multiple events for SQL you will see multiple entries for same SQL in the trace output. For example below are samples events for a Microsoft SQL Server Profiler trace settings.
Now for each event that gets triggered by a SQL you will have entries, but that does not mean that the SQL runs multiple times on the DB side.
[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Administration and Configuration v11x","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.6;11.0.5;11.0.4;11.0.3;11.0.2;11.0.1;11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg22005819