Prerequisites for Unica Deliver Reports
If you use Unica Deliver reports, you must comply with specific prerequisites in addition to the system requirements for installing reports.
Settings for DB2®
If you use DB2®, you must use version 9.7.8 or higher.
db2set DB2_COMPATIBILITY_VECTOR=ORA
Sample sizes for DB2®
For an DB2® Unica 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
Settings for Oracle
If you use Oracle, you must use version 11g or higher. Review your environment requirements with your database administrator.
Sample sizes for Oracle
For an Oracle Unica 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
If you use Microsoft™ SQL, you must use SQL Server 2008 or higher. Review your environment requirements with your database administrator.
Sample sizes 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 Internet Explorer, make sure that the browser security settings 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.