Db2 for IBM i streaming connector
The Db2 for IBM i connector can monitor and capture row-level changes within Db2 for IBM i schemas. The connector produces a change event record for every insert, update, and delete event occurring in any tables being monitored by the streaming agent.
How the connector works
The connector captures row-level changes from your Db2 for IBM i instance. This works by reading journal entries for the tracked tables. The tracked tables must therefore be journaled, and the Db2 for IBM i user requires permissions to query these journals. For a guide to setting up user permissions and configuring journaling in Db2 for IBM i, read Configure your Db2 for IBM i database.
The connector initially queries the database to determine which journals capture the selected tables. When streaming, the connector will read from each of the relevant journal receivers. If you want to add new tables to the pipeline, they must be added to the relevant journal, as described in Configure new tables.
You can optionally enable snapshotting to capture an up-to-date point-in-time view of the database before streaming begins, giving you a baseline from which to begin streaming changes. For a further discussion of this feature, read Snapshots.
The streaming process uses a Hybrid SaaS architecture and requires a Streaming agent to be deployed within your virtual private cloud (VPC). The agent must be deployed before you create your streaming pipeline.
Source setup
Refer to this section when you create a streaming pipeline. Complete the following properties, then click Connect to establish the connection to your source database.
Server address = string
The server address of your Db2 for IBM i database.
Port = integer
The port number used to access your Db2 for IBM i database. The default is 8471.
Username = string
The username used to log in to the specified database.
Secrets manager = drop-down
Choose the service you use to manage secrets.
Password secret name = string
The name of the secret in your secret manager service that references your Db2 for IBM i password.
JDBC parameters and specific connection settings = column editor (optional)
Specify any parameters you need to use as part of the connection. In the Add JDBC parameters & specific connection settings, list any parameter names and values that you require, then click Save.
Specific JDBC parameters may be required during the setup of the pipeline. Refer to the Db2 for IBM i documentation to determine what parameters you might need.