Cognos 10 BI server 安装经验分享，安装注意要点

最近自己尝试安装cognos，一开始没弄好，遇到不少问题，现在都解决了，故就此分享下经验：

1.这次安装的server是使用c10自带的JDK，如果本机没有安装配置过JDK的话，可以跳过。

有安装配置过JDK的话，先将JDK环境去掉：

    ①删除JAVA_HOME环境变量和path环境变量%JAVA_HOME%bin;

    ②将C:WINDOWSsystem32目录下的java.exe、javaw.exe、javaws.exe这三个文件剪切出来.

2.然后按提示安装c10 server；

3.（默认安装好DB2）复制DB2数据库jdbc驱动到cognos中，复制DB2安装目录下java目录中的DB2jcc.jar 和 jcc_license_cu.jar到cognos安装目录下的webappp2pdWEB-INFlib下；

4.content manager 用到的数据库用户要有足够的权限，createtab、connect、load等等权限；

5.内容库的db2数据库要按符合cognos一定的标准，例如：缓冲池、应用程序堆栈大小、锁定超时、表空间等等；

这里给个例子：

如果用到的数据库不符合标准,会报以下错误信息：

20:16:32, 'LogService', 'StartService', 'Success'.
20:16:32, CAF input validation disabled.
20:16:32, CAF Third Party XSS checking disabled.
20:16:36, 'com.cognos.pogo.contentmanager.coordinator.ActiveCMControl', 'pogo', 'Failure'.
DPR-DPR-1035 调度程序检测到错误。
null
20:16:35, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.  CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. Cause: CM-CFG-5137 Content Manager was unable to complete the initialization of the content store. For more information, review the log file. Before you restart Content Manager, you may need to recreate the content store database or clean it using dbClean_*.sql.    Runtime Exception stack trace:  CM-CFG-5137 Content Manager was unable to complete the initialization of the content store. For more information, review the log file. Before you restart Content Manager, you may need to recreate the content store database or clean it using dbClean_*.sql.  at com.cognos.cm.dbstore.CMDbStoreFactory.initContentIndependentBeforeLock(CMDbStoreFactory.java:1976)  at com.cognos.cm.dbstore.CMDbStore.initializeContentIndependentBeforeLock(CMDbStore.java:3828)    at com.cognos.cm.server.CMServlet.initializeContentStoreContentIndependentBeforeLock(CMServlet.java:2122)     at com.cognos.cm.server.CMServlet.init(CMServlet.java:1894)     at com.cognos.cm.server.ContentManager.start(ContentManager.java:403)  at com.cognos.cm.server.ContentManagerLifecycleHandler.start(ContentManagerLifecycleHandler.java:62)      at com.cognos.pogo.services.DefaultHandlerService.start(DefaultHandlerService.java:94)  at com.cognos.pogo.services.DispatcherServices.startInititalServices(DispatcherServices.java:388)  at com.cognos.pogo.transport.PogoServlet$PogoStartup.run(PogoServlet.java:604)    at com.cognos.pogo.util.threads.SafeThread.safeRun(SafeThread.java:70)  at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) 
20:16:36, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 无法确定活动的 Content Manager。 请定期重试。
20:17:35, 'CPS Producer Registration Service', 'StopService', 'Success'.
20:17:35, 'MetadataService', 'StopService', 'Success'.
20:17:35, 'EventService', 'StopService', 'Success'.
20:17:35, 'AgentService', 'StopService', 'Success'.
20:17:35, 'AnnotationService', 'StopService', 'Success'.
20:17:35, 'IndexUpdateService', 'StopService', 'Success'.
20:17:35, 'HumanTaskService', 'StopService', 'Success'.
20:17:35, 'JobService', 'StopService', 'Success'.
20:17:35, 'DeliveryService', 'StopService', 'Success'.
20:17:35, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 调度程序检测到错误。
null
20:17:35, 'IndexDataService', 'StopService', 'Success'.
20:17:36, 'IndexSearchService', 'StopService', 'Success'.
20:17:36, 'IBM Cognos Enhanced Search Service', 'StopService', 'Success'.
20:17:36, 'ReportDataService', 'StopService', 'Success'.
20:17:36, 'GraphicsService', 'StopService', 'Success'.
20:17:36, 'BUX Service', 'StopService', 'Success'.
20:17:36, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'.
DPR-DPR-1035 调度程序检测到错误。
null
20:17:36, 'MonitorService', 'StopService', 'Success'.
20:17:36, 'DimensionManagementService', 'StopService', 'Success'.
20:17:36, 'ReportService', 'StopService', 'Success'.
20:17:36, 'ContentManagerCacheService', 'StopService', 'Success'.
20:17:36, 'camAsyncAA', 'StopService', 'Success'.
20:17:38, 'SystemService', 'StopService', 'Success'.
20:17:38, 'BatchReportService', 'StopService', 'Success'.
20:17:38, 'Fragment Server Service', 'StopService', 'Success'.
20:17:38, 'ContentManagerService', 'StopService', 'Success'.
20:17:38, 'QueryService', 'StopService', 'Success'.
20:17:38, 'LogService', 'StopService', 'Success'.
[错误] CFG-ERR-0103 无法启动 IBM Cognos 服务。
执行外部进程后返回值为“-1”的错误代码。

处理方法，创建符合标准的数据库：

get database configuration for cognosdb;
 
update db cfg for cognosdb using applheapsz 1024;
 

update db cfg for cognosdb using LOCKTIMEOUT 240;

 create bufferpool bigbuff immediate size 250 pagesize 32 k;
 
create system temporary tablespace bigbuffsttmptabl pagesize 32 k managed by automatic storage extentsize 16 overhead 10.5 prefetchsize 16 transferrate 0.14 bufferpool bigbuff; 
 
create user temporary tablespace smallbuffsttmptabl pagesize  4 k managed by automatic storage extentsize 16 overhead 10.5
prefetchsize 16 transferrate 0.14 bufferpool ibmdefaultbp; 
 
create regular tablespace smallbuffusrregtbl pagesize  4 k managed by automatic storage extentsize 16 overhead 10.5 prefetchsize 16 transferrate 0.14 bufferpool ibmdefaultbp dropped table recovery on;
      

最后在configuration中配置好Cognos的内容存储数据库。

安装时注意好这几点，cognosserver安装就应该可以完美启动了。

测试过，cognosserver可以正常运行后就可以重新配置好原来的JDK环境，还有记得将java.exe、javaw.exe、javaws.exe 放回C:WINDOWSsystem32目录下，这样其他程序也可以正常使用这个JDK.