Table of Contents

Search

  1. Preface
  2. Content Installation
  3. Post-Installation Steps for Address Reference Data
  4. Address Validator Transformation Advanced Properties

Content Guide

Content Guide

IBM DB2 Database Requirements

IBM DB2 Database Requirements

Use the following guidelines when you set up the repository on IBM DB2:
  • Verify that the database user account has CREATETAB and CONNECT privileges.
  • Verify that the database user has SELECT privileges on the
    SYSCAT.DBAUTH
    and
    SYSCAT.DBTABAUTH
    tables.
  • 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.

0 COMMENTS

We’d like to hear from you!