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: Connecting to Databases from UNIX or Linux
  10. Appendix C: Updating the DynamicSections Parameter of a DB2 Database

Installation for Data Engineering

Installation for Data Engineering

Sybase Database Requirements

Sybase Database Requirements

Use the following guidelines when you set up the repository on Sybase ASE:
  • Set the database server page size to 16K or higher. You must set the page size to 16K as this is a one-time configuration and cannot be changed afterwards.
  • Set the database locking configuration to use row-level locking.
    The following table describes the database locking configuration that you must set:
    Database Configuration
    Sybase System Procedure
    Value
    Lock scheme
    sp_configure "lock scheme"
    0, datarows
  • Set the Sybase database option "ddl in tran" to TRUE.
  • Set "allow nulls by default" to TRUE.
  • Turn ON the Sybase database option select into/bulkcopy/pllsort.
  • Enable the "select" privilege for the sysobjects system table.
  • Create the following login script to disable the default VARCHAR truncation:
    create procedure dbo.sp_string_rtrunc_proc as set string_rtruncation on sp_modifylogin "user_name", "login script", sp_string_rtrunc_proc
    The login script is executed every time the user logs into the Sybase instance. The stored procedure sets the parameter at the session level. The sp_modifylogin system procedure updates "user_name" with the stored procedure as its "login script". The user must have permission to invoke the stored procedure.
  • Verify that the database user has CREATE DEFAULT, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, and CREATE VIEW privileges.
  • Set the database configurations to the recommended baseline values.
    The following table lists the database memory configuration parameters that you must set:
    Database Configuration
    Sybase System Procedure
    Value
    Maximum amount of total physical memory
    sp_configure "max memory"
    2097151
    Procedure cache size
    sp_configure "procedure cache size"
    500000
    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"
    5000
    Heap memory per user
    sp_configure "heap memory per user"
    49152
    Number of locks
    sp_configure "number of locks"
    100000
    1