• Skip to main content

IBM Blueview

Cognos Analytics and all things IBM

  • The Blog
  • Cognos Glossary
  • Cognos Resources
  • About Me
  • Categories
    • Cognos
      • Data Modules
      • Administration
      • Framework Manager
      • Dashboards
    • Opinion
    • Community Spotlight
  • PMsquare
  • Subscribe

64-bit vs 32-bit Ain’t Just for Playstation and Nintendo

March 17, 2015 by Ryan Dolley 1 Comment

Redditor Aybabtu123 on the IBM Cognos subreddit asks:

“I’m putting together a 10.2.2 sandbox environment and I’d like to enable dynamic query mode on it. Is it true that all datasources must be 64 bit for this?”

This is a great question and one that IBM frequently discusses in a way that is clear as mud, so here is the answer as succinctly as I can phrase it. Assuming a 64-bit installation of Cognos on a 64-bit server with a 64-bit OS…

  • With the Report Server Execution mode in Cognos Configuration set to 32-bit, queries routed to this server will execute in either CQE or DQM depending on how the datasource and package have been defined.
  • With the Report Server Execution mode in Cognos Configuration set to 64-bit, queries routed to this server will only execute in DQM. CQE queries will error out.
Cognos 64-bit option
Where the magic happens

Cognos is automatically set to 32-bit Report Server Execution upon installation, so as long as you don’t change it your application servers will be able to execute both 32-bit (CQE) and 64-bit (DQM) queries – and by extension utilize both CQE and DQM datasources.

Tomorrow (or soon anyway) we’ll discuss what situations would warrant switching to a 64-bit only application server and the steps you need to take to properly route traffic. I’ll give you a big hint though, and it rhymes with crynamic dubes.

Filed Under: Administration, Cognos

Reader Interactions

Trackbacks

  1. 64-bit Reporting: When To Use It? says:
    March 17, 2015 at 12:25 am

    […] discussed in an earlier post the misconception that 32-bit Cognos application servers cannot execute 64-bit queries when in fact […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Copyright © 2023 · Atmosphere Pro on Genesis Framework · WordPress · Log in