Cognos sql and native sql….

Cognos sql and native sql….

Within my company I joined new account as a report developer. Its all together a new assignment I got from my company. This new assignment’s main motto is to optimize the query performance so that report generation will take less time to generate the reports.

Here, these guys are using DB2 mainframes for backend. And they are using Cognos to generate the reports. So whenever there is any call to generate the report from Cognos, a query is executed in the backend. Here just to inform u all that, a cost is associated to each query being executed on DB2 mainframe systems. So if report generation query takes 5 minutes to execute the report then some cost will be charged on that. So in order to minimize the cost I started using native sql feature of Cognos. This is truly amazing. I mean rather than using complex joins of the Cognos sql, we can tune the query performance in better way using native sql.

In my development of reports, I got the chance to use the native sql in few of the report. And that did work well. And it also improved the report execution time. So it was really a win win situation for all of us…

For me, I learned the new way of optimization of my queries and for my team, they got the logic to cut down the cost. It was great…