Creating Q Apply control tables for native Oracle targets

You use the ASNCLP program or Replication Center to create Q Apply control tables for native Oracle targets. All of the Q Apply control tables are created in the Oracle database.

Before you begin

Before you begin

The ASNCLP program or Replication Center must be able to connect to the Oracle database.

About this task

Procedure

Procedure

Use one of the following methods:
Method Description
ASNCLP command-line program Use the CREATE CONTROL TABLES FOR command. First create a configuration file with information for connecting to the Oracle database, and then specify the file in the SET SERVER command.

For example, the following commands set the environment and create control tables on the ORATGT1 database. Connection details are saved in the /home/oracle/asnservers.ini configuration file:

ASNCLP SESSION SET TO Q REPLICATION;
SET SERVER target TO CONFIG SERVER ORATGT1
FILE "/home/oracle/asnservers.ini" ID uid PASSWORD "pwd";
SET QMANAGER "QM1" FOR APPLY SCHEMA;
SET RUN SCRIPT NOW STOP ON SQL ERROR ON;
CREATE CONTROL TABLES FOR APPLY SERVER;
Replication Center Follow these steps:
  1. Open the Create Control Tables wizard by right-clicking the Q Apply Servers folder and clicking Create Q Apply control tables.
  2. On the Server page, click Add to add the Oracle database to the Replication Center. When you do so, the Add Connection window opens. Use this window to specify details for connecting to the Oracle database, including user ID and password.
  3. If you want to customize the table spaces where control tables are created, select the Custom option. Note that the Replication Center does not create table spaces in an Oracle database, so to use this option you must provide the names of existing table spaces and specify in the Replication Center which control tables should be placed in which table spaces.