Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Managing Distribution Packages
  10. Appendix C: Connecting to Databases from UNIX or Linux
  11. Appendix D: Connecting to Databases from Windows
  12. Appendix E: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

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!