Required database, user accounts, and schemas
Before you create a CDC Replication instance you need to ensure that you have the required database, user account, and directory access.
Configuring a Db2 Database database
When you configure the CDC Replication Engine for Db2® Database, you are prompted for the name of the Db2 Database database you want CDC Replication to connect to and replicate data. Before installing the software, ensure that this Db2 Database database exists and that you have created and set up a database user that has access to it.
Setting up a Windows user account
If you are installing CDC Replication on a Windows system, you must set up a new, or decide on an existing Windows account that you will use to install, configure, or upgrade CDC Replication
Setting up a UNIX user account
When you are installing CDC Replication on a UNIX machine, you must set up a new, or decide on an existing UNIX account that you will use to install, configure, or upgrade CDC Replication. You can install CDC Replication in the directory of your choice, however, it must be owned by the UNIX account.
Setting up a Db2 Database user account with SYSADM or DBA privileges
For CDC Replication to connect to your Db2 database, you need to create a Db2 user account and assign system administrator (SYSADM) or database administrator (DBA) privileges to this use. When you configure CDC Replication, you are prompted for the name of the Db2 database you want CDC Replication to connect to and the user name and password of the Db2 user that has access to this database.
Configuring a Db2 Database schema
Create a schema or choose an existing schema for your database metadata tables. You will have to specify this schema when you configure CDC Replication.
Creating directories for Db2 Database Fast Load files
Create or decide on the directory you want to use for the Fast Load utility in Db2 Database. Both your CDC Replication user and your Db2 instance user must have read, write and execute permissions for the fast load directory. Use a different directory for each instance of CDC Replication.