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