pds_admin_connection_pool_size

(IBM DB2 UDB only) Specifies the primary data server admin connection pool size.

Default

15

Value

An integer in the range of 2 to 64.

Comments

  • If you change the value of pds_admin_connection_pool_size to a valid value, the value is recorded in the configuration file. If you specify a value that is greater than or equal to the total number of free and used primary data server connections, the new value takes effect immediately. Otherwise, you must restart the Replication Agent instance to make the new value take effect.
  • You cannot view the total number of free and used primary data server admin connections available. Therefore, it is recommended that the configuration parameter pds_admin_connection_pool_size is set to greater value so that Replication Agent does not have to wait for the used primary data server admin connections to be released.
  • If a Replication Agent admin command execution requires multiple primary data server connections simultaneously, you can increase the pds_admin_connection_pool_size value to reduce the connection contention.