Database guidelines

When configuring the database for Business Intelligence, consider the tuning guidelines for databases.

Table 1. Database guidelines forBusiness Intelligence
Database Guideline	Comment
Disk I/O	Disk I/O is a vital part of the ETL process. For more information, refer to the performance tuning guidelines for your database.
Roll Back Log Files	Ensure enough space is allocated for transaction logs. For information about sizing redo logs, refer to Redo logs.
Paging Space - Swap Space	For Db2®, paging and swap space should be set to twice the physical memory. For Oracle, swap space should be equal to the physical memory and up to 16 GB. For more paging and swap space recommendations, refer to the guidelines for your database.
Sort Space	Automatic memory management should enabled. Because the Business Intelligence ETL’s perform some complex queries, sufficient sort space is required for high performance.