Cognos Analytics

Have a client that is on Cognos 11.2.4 or 11.0.7 (don't know for sure, waiting to hear back). All the newer report packages were published with DQM but she has some old packages that were published with CQM. (She cannot republish them with DQM.) She says that her Cognos has to run-in 32-bit mode so that the CQM packages can run without error. Unfortunately, she has some really large DQM packages (queries are complex and return a lot of data) that require 64 bit to run within several hours. To accommodate these large packages she stops Cognos, start in 64 bit mode, run sthe large reports, stop scognos and then bring cognos back up in 32 bit mode. 

Any ideas on how to make this less painful?

Have a client that is on Cognos 11.2.4 or 11.0.7 (don't know for sure, waiting to hear back). All the newer report packages were published with DQM but she has some old packages that were published with CQM. (She cannot republish them with DQM.) She says that her Cognos has to run-in 32-bit mode so that the CQM packages can run without error. Unfortunately, she has some really large DQM packages (queries are complex and return a lot of data) that require 64 bit to run within several hours. To accommodate these large packages she stops Cognos, start in 64 bit mode, run sthe large reports, stop scognos and then bring cognos back up in 32 bit mode. 

Any ideas on how to make this less painful?

My thought was that even in a 32-mode configuration the DQM packages will run in a 64-bit mode, it just allows both modes while the 64-bit mode in the Cognos configuration only allows DQM.

https://youtu.be/l5Ir6BOOScw

However, if you see there is really a huge difference when running the DQM packages in a 64-bit configuration compared to a 32-mode configuration then you can configure IBM Cognos Analytics 11 or 12 to run CQM packages in 32-bit mode and DQM packages in 64-bit mode.

https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=services-enabling-64-bit-version-report-server

To achieve this setup:
Configure the main Cognos Analytics instance to run in 32-bit mode. This allows both CQM and DQM packages to run.
Set up a separate 64-bit report service specifically for DQM content that requires 64-bit processing (you can do this on the same instance by configuring Cognos using different ports then the first one).
Use advanced routing rules to direct DQM queries to the 64-bit server when necessary, while keeping CQM queries on the 32-bit server.

Have a client that is on Cognos 11.2.4 or 11.0.7 (don't know for sure, waiting to hear back). All the newer report packages were published with DQM but she has some old packages that were published with CQM. (She cannot republish them with DQM.) She says that her Cognos has to run-in 32-bit mode so that the CQM packages can run without error. Unfortunately, she has some really large DQM packages (queries are complex and return a lot of data) that require 64 bit to run within several hours. To accommodate these large packages she stops Cognos, start in 64 bit mode, run sthe large reports, stop scognos and then bring cognos back up in 32 bit mode. 

Any ideas on how to make this less painful?

@Kai Zeller and @rene kent nielson - reading the ibm link that Kai provided - so in 64 bit installations, the query service is 64 bit regardless of if the report service is 32 or 64.  If the report service is 32 bit then it seems like it runs in 32 bit only but can accommodate CQM and DQM reports. 64 bit report service will not run CQM reports. I will ask IBM reps at our next meeting about setting up the two report services - one for 32 bit reports and one for 64 bit reports. 

My thought was that even in a 32-mode configuration the DQM packages will run in a 64-bit mode, it just allows both modes while the 64-bit mode in the Cognos configuration only allows DQM.

https://youtu.be/l5Ir6BOOScw

However, if you see there is really a huge difference when running the DQM packages in a 64-bit configuration compared to a 32-mode configuration then you can configure IBM Cognos Analytics 11 or 12 to run CQM packages in 32-bit mode and DQM packages in 64-bit mode.

https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=services-enabling-64-bit-version-report-server

To achieve this setup:
Configure the main Cognos Analytics instance to run in 32-bit mode. This allows both CQM and DQM packages to run.
Set up a separate 64-bit report service specifically for DQM content that requires 64-bit processing (you can do this on the same instance by configuring Cognos using different ports then the first one).
Use advanced routing rules to direct DQM queries to the 64-bit server when necessary, while keeping CQM queries on the 32-bit server.

Have a client that is on Cognos 11.2.4 or 11.0.7 (don't know for sure, waiting to hear back). All the newer report packages were published with DQM but she has some old packages that were published with CQM. (She cannot republish them with DQM.) She says that her Cognos has to run-in 32-bit mode so that the CQM packages can run without error. Unfortunately, she has some really large DQM packages (queries are complex and return a lot of data) that require 64 bit to run within several hours. To accommodate these large packages she stops Cognos, start in 64 bit mode, run sthe large reports, stop scognos and then bring cognos back up in 32 bit mode. 

Any ideas on how to make this less painful?

Have a client that is on Cognos 11.2.4 or 11.0.7 (don't know for sure, waiting to hear back). All the newer report packages were published with DQM but she has some old packages that were published with CQM. (She cannot republish them with DQM.) She says that her Cognos has to run-in 32-bit mode so that the CQM packages can run without error. Unfortunately, she has some really large DQM packages (queries are complex and return a lot of data) that require 64 bit to run within several hours. To accommodate these large packages she stops Cognos, start in 64 bit mode, run sthe large reports, stop scognos and then bring cognos back up in 32 bit mode. 

Any ideas on how to make this less painful?

------------------------------
brenda grossnickle
BI Programmer Analyst
FIS
------------------------------

Have a client that is on Cognos 11.2.4 or 11.0.7 (don't know for sure, waiting to hear back). All the newer report packages were published with DQM but she has some old packages that were published with CQM. (She cannot republish them with DQM.) She says that her Cognos has to run-in 32-bit mode so that the CQM packages can run without error. Unfortunately, she has some really large DQM packages (queries are complex and return a lot of data) that require 64 bit to run within several hours. To accommodate these large packages she stops Cognos, start in 64 bit mode, run sthe large reports, stop scognos and then bring cognos back up in 32 bit mode. 

Any ideas on how to make this less painful?