Creating a Replication Server Connection to the Primary Database

Create a Replication Server connection to the primary database.

  1. In Replication Server, create a connection to the primary DB2 UDB database:
    create connection to pds.pdb
    using profile rs_rs_to_udb_ra;standard
    set username muser
    set password mpwd
    with log transfer on, dsi_suspended
    go
    where:
    • pds is the value of the rs_source_ds parameter specified in Replication Agent.

    • pdb is the value of rs_source_db specified in Replication Agent.

    • muser is the maintenance user for the primary DB2 UDB database.

    • mpwd is the maintenance user password.

    For information about the maintenance user, see the Replication Agent Primary Database Guide.
  2. Use admin show_connections, 'primary' to display the primary connection you created.