Table of Contents

Search

  1. Preface
  2. Content Installation
  3. Configuration Steps for Address Reference Data
  4. Appendix A: Address Validator Transformation Advanced Properties

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.


Updated August 04, 2020