Pinned topic Cognos BO v.10.1 and Controller BIG installation problem on DB2 v9.7
I've spent few days trying to install Controller on Windows2008R2 using DB2 v.9.7 as DBMS.
And ... there are many problems running CreateDB scripts using DbCnv/Database Conversion Utility in legacy or Java mode.
IBM/COGNOS/Frango programmers used ORA compatibility mode (PL/SQL scripts ...) but ... those scripts used in applications doesn't work ;-((((
For example in Java mode it is ONE BIG transaction (lock exclusively database - sic!!!)
richcoll 2700024PKX19 PostsACCEPTED ANSWER
Re: Cognos BO v.10.1 and Controller BIG installation problem on DB2 v9.72012-02-28T12:28:43Z in response to SystemAdminThe cause is explained here: http://www-01.ibm.com/support/docview.wss?uid=swg21579333
The fix is here: http://www-01.ibm.com/support/docview.wss?uid=swg21570572
G5Q0_John_Fong 270004G5Q02 PostsACCEPTED ANSWER
Re: Cognos BO v.10.1 and Controller BIG installation problem on DB2 v9.72013-04-19T01:36:27Z in response to SystemAdmin
Hopefully, you have your issue solved by now. If not, like us, opened countless PMR with them and finally push them to release us patches to get the Controller 8.5 to work on DB2 9.7.4 SP4. After two years of pushing and testing Controller, we finally see the light to release to platform to production.
Many of our patches are internal build and you wont see it from a public place. Call your Sales Rep. and push them to get your issue resolved!