Prerequisites for eMessage Reports

If you are using eMessage reports, you comply with specific prerequisites in addition to the system requirements for installing reports.

See Prerequisites for information about the system requirements for installing reports.

For better performance, you might need 40% of the data size as temp table space. Work with your database administrator to regularly fine-tune your database. For best results, you can store eMessage system tables in a separate tablespace that is mounted on a separate, unshared disk.

Settings for IBM DB2®

You must use IBM DB2 version 9.7.8 or higher.
Important: You must set the following value before you begin applying the eMessage Reports:

db2set DB2_COMPATIBILITY_VECTOR=ORA

Example of sizings for DB2

For an IBM DB2 Campaign database of approximately 600 GB with most of the data population in the reporting tables (UCC_*), you might use the following settings:
  • Tablespace page size: 16K
  • Temp tablespace: 250 GB
  • db2 update db cfg using auto_reval DEFERRED_FORCE;
  • db2 update db cfg using decflt_rounding ROUND_HALF_UP;
  • db2 update db config using LOGFILSIZ 102400;
  • db2 update db config using logprimary 13;
  • db2 update db config using LOGSECOND 25;
  • db2stop force
  • db2start
Important: The size of your transaction log can affect reports processing. Review your database environment requirements, especially the size of the transaction log, with your database administrator.

Settings for Oracle

You must use Oracle 11g or higher. Review your environment requirements with your database administrator.

Example of sizings for Oracle

For an Oracle Campaign database of approximately 650 GB with most of the data population in the reporting tables (UCC_*), you might use the following settings:
  • Temp tablespace: 250 GB
  • Size for REDO logs: 2 GB
  • Number of REDO logs: 4

Settings for Microsoft™ SQL Server

You must use Microsoft SQL Server 2008 or higher. Review your environment requirements with your database administrator.

Example of sizings for Microsoft SQL Server

For Microsoft SQL Server database of approximately 520 GB with most of the data population in the reporting tables (UCC_*), you might use the following settings:
  • Temp tablespace: 250 GB

Settings for Internet Explorer

If you use the Internet Explorer browser, make sure that your security settings of the browser allow automatic prompting for file downloads. Complete the following steps to verify that the browser allows automatic prompting for file downloads:
  1. Open Internet Explorer and go to Tools > Internet Options..
  2. In the Security tab, click Custom Level.
  3. Scroll down to the Downloads section.
  4. Make sure that the Automatic prompting for file downloads option is set to Enable.