IBM Blueview

Cognos Analytics and all things IBM

The Blog

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

by 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.

We Need To Talk: The Blue View Manifesto

by 1 Comment

We need to talk.

I am continuously surprised at the lack of strong IBM Cognos community content available on the web. With a few notable exceptions Cognos blogs burn bright, die fast and leave a handful of good posts slowly aging into obsolescence.

If you have made a career in Cognos this is a critical time. Cognos can do data discovery, visualization, self-service and collaboration but even IBM seems to lack a holistic vision to stitch it together.  Or else True Blue and the business partners are content to keep it behind the consulting pay wall.

That’s a huge problem. That’s the old world that Tableau and Birst have been sent here to destroy. Yes the new breed of BI tools are powerful and cool and excel in their particular niche, but more than anything they foster a user community that feels connected to one another. Last time I checked Tableau’s forum had over 18,000 posts. Where is IBM’s forum?

That’s a trick question because it doesn’t matter. A software community can only be formed and sustained by a group of people who have knowledge and the passion to share it. The deeply technical how-to’s and the holistic design philosophies have already been crafted by the army of talented Cognos developers.

We just need to talk about it.

So let’s start now.