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.

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

Settings for DB2®

If you use DB2®, you must use version 9.7.8 or higher.

Important: You must set the following value before you begin applying the Unica Deliver reports:
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
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

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:

  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.