Every Oracle GoldenGate process makes a database connection. Depending on the number of processes that you will be using and the number of other DB2 connections that you expect, you might need to adjust the following DB2 system parameters on the DSNTIPE DB2 Thread Management Panel:

• MAX USERS (macro DSN6SYSP CTHREAD)

• MAX TSO CONNECT (macro DSN6SYSP IDFORE)

• MAX BATCH CONNECT (macro DSN6SYSP IDBACK)

If using RRSAF, allow:

• Two DB2 threads per process for each of the following:

  • Extract

  • Replicat

  • The GGSCI command DBLOGIN (logs into the database)

  • DEFGEN utility (generates data definitions for column mapping)

• One extra DB2 thread for Extract for IFI calls.

• One extra DB2 thread for each SQLEXEC parameter statement that will be issued by each Extract and Replicat process. For more information about SQLEXEC, see the Reference for Oracle GoldenGate.

If using CAF, there can be only one thread per Oracle GoldenGate process.