Required Db2 settings for JDBC binding

The JDBC driver binds its packages on the first CDC Replication connection to the database, unless you bind them manually in advance. Refer to <InstallDir>/lib/libdb2z/CfJDBC zOS Manual Package Creation Instructions.txt for the manual binding instructions.

If you do not bind packages manually, the CDC Replication user ID requires either the SYSCTRL privilege or these individual privileges:
  • All privileges for normal operation
  • BINDADD system privilege
  • CREATE IN on the NULLID collection or another collection specified with the PackageCollection advanced JDBC parameter

The LoginTimeout advanced JDBC parameter might be needed to avoid timing out the connection when binding. Set LoginTimeout=180 to allow up to three minutes for JDBC binding.

Note: These settings are applicable to all configuration options. They are not needed for the less-privileged user in the two users option.