Exception Management Audit Database Requirements
The exception management audit database is a single repository for data that describes the work that Analyst tool users perform on Human task instances. The Analyst Service identifies the database connection and the schema name. The Data Integration Service writes the audit data to the database.
If the Analyst Service does not identify an exception management audit database, the Data Integration Service writes the audit data to the database that contains the task instance records.
The reference data warehouse supports the following database types:
- •IBM DB2 UDB
- •Microsoft SQL Server
- •Oracle
Allow 200 MB of disk space for the database.
Note: Ensure that you install the database client on the machine on which you want to run the Content Management Service.
IBM DB2 Database Requirements
Use the following guidelines when you set up the repository on IBM DB2:
- •The database user account must have the CREATETAB, CONNECT, CREATE VIEW, and CREATE FUNCTION privileges.
- •Informatica does not support IBM DB2 table aliases for repository tables. Verify that table aliases have not been created for any tables in the database.
- •Set the tablespace pageSize parameter to 32768 bytes.
- •Set the NPAGES parameter to at least 5000. The NPAGES parameter determines the number of pages in the tablespace.
Microsoft SQL Server Database Requirements
Use the following guidelines when you set up the repository on Microsoft SQL Server:
- •The database user account must have the CONNECT, CREATE TABLE, CREATE VIEW, and CREATE FUNCTION privileges.
Oracle Database Requirements
Use the following guidelines when you set up the repository on Oracle:
- • Verify that the database user has the following privileges:
- - ALTER TABLE
- - CREATE SESSION
- - CREATE TABLE
- - DROP TABLE
- - UPDATE TABLE
- •Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.
- •Set the tablespace parameter. Use the following formula to determine the value: 2 MB x (number of tables in each scan x number of concurrent scans)
For example, you have 1,000 tables in each scan and you plan to run 10 scans concurrently. Calculate the tablespace parameter value as follows: 2 MB x (100 x 10) = 20 GB
Note: The tablespace must be distributed across multiple disks.
- •Set the following parameters to the Informatica recommended values:
Parameter | Recommended Value |
|---|
open_cursors | 3000 |
Sessions | 1000 |
Processes | 1000 |