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:
- Open Internet Explorer and go to .
- In the Security tab, click Custom Level.
- Scroll down to the Downloads section.
- Make sure that the Automatic prompting for file downloads option is set to Enable.