Topic
2 replies Latest Post - ‏2013-04-19T01:36:27Z by G5Q0_John_Fong
SystemAdmin
SystemAdmin
41 Posts
ACCEPTED ANSWER

Pinned topic Cognos BO v.10.1 and Controller BIG installation problem on DB2 v9.7

‏2011-12-30T19:21:45Z |
Hi,

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!!!)

Please help.

Best regards,
Adam
Updated on 2012-02-28T12:28:43Z at 2012-02-28T12:28:43Z by richcoll
  • richcoll
    richcoll
    11 Posts
    ACCEPTED ANSWER

    Re: Cognos BO v.10.1 and Controller BIG installation problem on DB2 v9.7

    ‏2012-02-28T12:28:43Z  in response to SystemAdmin
    The 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

    Good luck!
  • G5Q0_John_Fong
    G5Q0_John_Fong
    2 Posts
    ACCEPTED ANSWER

    Re: Cognos BO v.10.1 and Controller BIG installation problem on DB2 v9.7

    ‏2013-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!