Replication Guide and Reference

Defining replication control tables

Normally, the replication control tables are created in one of the following ways:

• By customizing the DPCNTL file for your operating system and running the file before initiating any actions from the DB2 Control Center.

  See comments within the file for tailoring the SQL for a specific database platform. You need to customize the DPCNTL file for the following definitions:

  • To define the location and size of DB2 for OS/390 table spaces and databases for the control tables. The Control Center creates the control tables in the default table space and database, unless you specify a different table space or database.

  • To define and size DB2 for VSE or VM dbspaces for the control tables. The Control Center creates the control tables in the default dbspace, unless you specify a different dbspace.

  • To tailor the control tables for specific operating system environments because not all definitions are supported for all operating systems.

  • To place control tables in specific DB2 Universal Database table spaces or in a DB2 EEE single node group.

• By using the Control Center to define replication sources and subscriptions; these actions create default versions of the control tables.

  If you use this option, you cannot customize the replication control tables without dropping the existing control tables and customizing them. If you are running OS/390, VSE/ESA, or VM/ESA, you must customize the replication control tables.

• By selecting Create Replication Control Tables in DJRA.

When you create customized control tables, you must customize the CREATE TABLE statements in the DPCNTL files. There is one DPCNTL file for each operating system environment; these files are located in the SQLLIB\SAMPLES\REPL\ directory. The file names are:

DPCNTL.UDB

Creates control tables for DB2 Universal Database.

DPCNTL.MVS

Creates control tables for DB2 for OS/390.

DPCNTL.VM

Creates control tables for DB2 for VSE & VM.

DPCNTL.400

Creates control tables for DB2 for AS/400.

DPCNTL.SAT

Creates and drops control tables for DB2 Universal Database Satellite Edition.

If, after creating customized control tables, you need to drop them, you must customize the DROP TABLE statements in the DPNCNTL files. There is a DPNCNTL file for each operating system environment located in the SQLLIB\SAMPLES\REPL\ directory. The files names are:

DPNCNTL.UDB

Drops control tables for DB2 Universal Database.

DPNCNTL.MVS

Drops control tables for DB2 for OS/390.

DPNCNTL.VM

Drops control tables for DB2 for VSE & VM.

DPNCNTL.400

Drops control tables for DB2 for AS/400.

To customize the SQL for creating or dropping control tables:

1. Open the appropriate file (SQLLIB\SAMPLES\REPL\DPCNTL.platform_name or SQLLIB\SAMPLES\REPL\DPNCNTL.platform_name, where platform_name is UDB, MVS, or VM.) in a text editor.

2. Read the commented areas for each operating system and table.

3. Edit the file for your site or application.

4. Close the file.

5. Connect to the database in which the control tables will be created (use the DB2 CONNECT TO database-name command).

6. Run the file (DPCNTL or DPNCNTL) using one of the following commands from a command window:

   db2 -tf dpcntl.platform_name
    
   db2 -tf dpncntl.platform_name
   

[ DB2 List of Books | Search the DB2 Books ]