If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Get COGNOS to add an API call to the start of a query

Started by BristolSmithy, 26 Oct 2010 10:20:31 AM

Previous topic - Next topic

BristolSmithy

Hi,  we're about to upgrade DB2 database versions to 9.7 and want to make use of the work load manager.  Basically we've identified two different types of query (expensive and hitting big base tables and cheap hitting MQT's) that will be run from one of our report packages and need an easy way for WLM to differentiate between them.

Having spoken to the DBA he's suggested we make an API call at the beginning of each query to utilise the WLM_SET_CLIENT_INFO function.

However, I'm really struggling to find a way of adding such a call the the SQL that COGNOS is generating.  Any ideas?

Cheers