IBM Support

Cognos : Advance troubleshooting for report performance issue for database type 'Oracle'

Troubleshooting


Problem

Cognos : Advance troubleshooting for report performance issue for database type 'Oracle'

Symptom

When troubleshooting performance issues for cognos reports we refer to cogserver.log or crnserver.log along with the .ASH reports.

These reports/logs will show us only the report query.

Error Message

No error message

Resolving The Problem

As an extra step modify cogdmor.ini file in crn\bin or c8\bin to include

[TRACE]
Output=d:\filename.log

Execute the report, trace component helps us identify the queries executed against the database even before going though the db driver.
The trace file generated identifies if the report queries are being split or if queries other than the actual report query is sent to the database or are they any duplicate report queries. Helps us to eliminate the possiblities of nailing down the causes whether sterling application or cognos or database.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

NFX6647

Product Synonym

[<p><b>]Severity[</b><p>];Critical

Document Information

Modified date:
16 June 2018

UID

swg21555923

Page Feedback