Cognos BI 10.1.1
Microsoft Windows 2008 R2 server
Does the anti virus program affect my performance in Cognos BI ?
Yes - you should disable any local active scanning on Cognos BI folders and sub-folders.
If you have rules in the Anti virus program - you should test to turn them off, this can increase performance in Cognos BI reporting.
You must have all anti-virus software turned off during install of Cognos BI products, or the installation may fail.
refers to the installation directory of each Cognos BI Instance.
Example c:\Program Files\ibm\cognos\c10_64\configuration\
Exclude files of type:
The configuration folder is a tree structure with several levels. Exclusions should apply to the folder levels and any other subfolder level below.
Example c:\Program Files\ibm\cognos\c10_64\temp\
The temp folder is used by Cognos BI to store temporary files used for local operations or cached data.
Files in this folder don’t have any extensions. Files can be differentiated based on their prefix, fx: ‘uda*’. The recommendation is that the entire folder and subfolder structure is excluded from access scanning.
You can inside Cognos Configuration set the environment value for TEMP files to something else than default - if you set to d:\temp you must exclude that folder also from the anti virus scan software.
File types to exclude: *.mdc
The cubes folder is divided into various sub-folders with different levels. Exclusion should apply all folder levels below.
Example c:\Program Files\ibm\cognos\c10_64\ logs\
File types to exclude:
cbs* (Note: exclude on prefix, the ‘cbs*’ files does not have extensions)
The logs folder is also a tree structure with different levels below. Exclusions should apply to all levels below.
Example c:\Program Files\ibm\cognos\c10_64\data\
File types to exclude:
The runtime models folder is a tree structure with sub-levels. Exclusions should apply to all levels below.
Please also do not forget to turn DEP off in Microsoft Windows 2008 R2 servers.
Go to controller panel - system - advanced system settings
Go to system properties - advanced - system performance.
Go to Data Execution Prevention tab and select to top value only.
Data Execution Prevention (DEP) is a security feature that can help prevent damage to your computer from viruses and other security threats. Harmful programs can try to attack Windows by attempting to run (also known as execute) code from your computer's memory reserved for Windows and other authorized programs. These types of attacks can harm your programs and files.
DEP can help protect your computer by monitoring your programs to make sure that they use computer memory safely. If DEP notices a program on your computer using memory incorrectly, it closes the program and notifies you.