Specifying the Number of Connection Threads

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)

Log reads use RRSAF, allow:

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

  • Extract

  • Replicat

  • The Admin Client 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.