This section describes the schema and details of Replication
Agent objects for a primary database that resides in the IBM DB2
Universal Database server. For more general information, see the Replication
Agent Administration Guide.
Replication Agent creates objects in the IBM DB2 Universal Database primary database to assist with replication tasks. Replication Agent also uses the native database transaction log maintained by the IBM DB2 Universal Database server to capture transactions in the primary database for replication.
Replication Agent for UDB creates tables in the primary database for its system information. Replication Agent also creates Java stored procedures used to truncate transaction log files in the primary database. To create the procedures, Replication Agent installs jar files into the primary database.The Replication Agent system tables and procedures are created when the pdb_xlog command is invoked with the init keyword. When you invoke this command, Replication Agent generates a SQL script that is run in the primary database. This script is stored in the create.sql file in the RAX-15_2\inst_name\scripts\xlog directory.
The create.sql script creates the Replication Agent objects. These objects must be created before any tables can be marked for replication in the primary database.
The JAR files are installed when the pdb_xlog
init command is executed. The pdb_xlog
remove command uninstalls the JAR files from the primary database.
You must issue pdb_xlog remove command
before reinitializing Replication Agent. See “Java procedure objects”.
