PowerCenter Repository Database Requirements
A PowerCenter repository is a collection of database tables containing metadata. A PowerCenter Repository Service manages the repository and performs all metadata transactions between the repository database and repository clients.
The PowerCenter repository supports the following database types:
- •IBM DB2 UDB
- •Microsoft SQL Server
- •Oracle
- •Sybase ASE
Allow 35 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 PowerCenter Repository Service.
For more information about configuring the database, see the documentation for your database system.
IBM DB2 Database Requirements
Use the following guidelines when you set up the repository on IBM DB2:
- •To optimize repository performance, set up the database with the tablespace on a single node. When the tablespace is on one node, PowerCenter Client and PowerCenter Integration Service access the repository faster than if the repository tables exist on different database nodes.
Specify the single-node tablespace name when you create, copy, or restore a repository. If you do not specify the tablespace name, DB2 uses the default tablespace.
- •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.
Microsoft SQL Server Database Requirements
Use the following guidelines when you set up the repository on Microsoft SQL Server:
- •Set the database server page size to 8K or higher. This is a one-time configuration and cannot be changed afterwards.
- •Verify that the database user account has the CONNECT, CREATE TABLE, and CREATE VIEW privileges.
Oracle Database Requirements
Use the following guidelines when you set up the repository on Oracle:
- •Set the storage size for the tablespace to a small number to prevent the repository from using an excessive amount of space. Also verify that the default tablespace for the user that owns the repository tables is set to a small size.
The following example shows how to set the recommended storage parameter for a tablespace named REPOSITORY:
ALTER TABLESPACE "REPOSITORY" DEFAULT STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS UNLIMITED PCTINCREASE 50 );
Verify or change the storage parameter for a tablespace before you create the repository.
- •Verify that the database user has the CONNECT, RESOURCE, and CREATE VIEW privileges.
- •Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.
Sybase ASE Database Requirements
Use the following guidelines when you set up the repository on Sybase ASE:
- •Set the database server page size to 8K or higher. This is a one-time configuration and cannot be changed afterwards.
- •Set the Sybase database option "ddl in tran" to TRUE.
- •Set "allow nulls by default" to TRUE.
- •Verify the database user has CREATE TABLE and CREATE VIEW privileges.
- • Set the database memory configuration requirements.
The following table lists the memory configuration requirements and the recommended baseline values:
Database Configuration | Sybase System Procedure | Value |
|---|
Number of open objects | sp_configure "number of open objects" | 5000 |
Number of open indexes | sp_configure "number of open indexes" | 5000 |
Number of open partitions | sp_configure "number of open partitions" | 8000 |
Number of locks | sp_configure "number of locks" | 100000 |