Years ago, I remember monitoring a long running report that had multiple SQL queries and multiple Cognos JOINs by watching the queries execute in MS SQL and then watching the Cognos cache folder grow during the JOINs. Now I have another instance where i have to monitor SQL and Cognos and cannot remember how to find the Cognos cache folder location. 

Hello Brenda,

have a look at UDA files in temp folder growing to GB size.

regards,

Ralf

Where is the location of this "temp" folder. I see a temp folder under the Cognos root. But there are many subfolders. Trying to find where specifically the path and name of the folder that is used during a Cognos Report JOIN operation. 

Doing a bit of googling on UDA. Seems like those files are created using Compatibility Query Mode (CQM). We use Dynamic Query Mode (DQM) for all of our reports. Do you think DQM still creates temporary files during a JOIN operation?

Hi Brenda,

UDA files are for the CQM
For DQM the location of temporary files used for data processing is <install>/temp/xqe the files have names like:
xqe_ScrollableTabularCache_1698681505294_12.cache
These files are created when Cognos does local processing, including function calls that could not be sent to a database and joins/unions across different database providers.

I hope this helps

Should a query result in local query compensation/decomposition (meaning the whole query does not push to the database), then you may see files under the <cognos>\temp\xqe etc folders.

The reasons can vary ranging from:
- something cannot be pushed to a vendor due to them not supporting  an equivalent concept
- you are doing a multi-data source join/set operation
- the data in the set/joins including many rows and projected columns.

Similar motivating reasons could exist for CQM.

If you need more information, I recommend you open a support ticket and as applicable perhaps a specific use case.