DB2 Replication Guide and Reference

Working with Customized Replication Control Tables

The replication control tables are created in two ways:

By customizing the DPCNTL file for your platform and then running the file before running any actions from the Control Center.
By running the first replication request at a server from the Control Center to create the default version of the control tables.

If you use the second option, you cannot customize the replication control tables for your site without dropping the existing control tables and customizing the tables as discussed below. The default custom tables are designed for the DB2 Universal Database platforms. If you are running on MVS/ESA, VSE/ESA, or VM/ESA, you must customize the replication control tables.

You need to customize the file for your platform before performing any replication action at the server. See comments within the file for tailoring the SQL to run on a specific database platform. You will need to customize the DPCNTL file for the following definitions:

To define and size DB2 for MVS table spaces and databases for the control tables. The Control Center automatically creates the control tables in the default table space and database, unless you specify a different table space or database.
To define DB2 for MVS V3.1 padding to support row-level locking.
To define and size DB2 for VSE or VM dbspaces for the control tables. The Control Center will automatically create the control tables in the default dbspace, unless you specify a different dbspace.
To tailor the control tables to run on specific platforms because not all definitions are supported on all platforms.
To define additional indexes for better performance on a specific platform.
To place control tables in specific DB2 Universal Database table spaces or in a DB2 EEE single node group.

When you create customized control tables, you need to customize SQL files for the CREATE TABLE statements. The DPCNTL file contains the SQL for creating control tables. There is a DPCNTL file for each platform located in the SQLLIB\SAMPLES\REPL\ directory. The files names are:

DPCNTL.UDB: Creates control tables for the DB2 Universal Database platform.
DPCNTL.MVS: Creates control tables for the DB2 for MVS platform.
DPCNTL.VM: Creates control tables for the DB2 for VSE & VM platforms.

To customize the SQL for creating control tables:

Open the SQLLIB\SAMPLES\REPL\DPCNTL.platform_name file as ASCII in an editor, where platform_name is the platform name in the previous list.
Read the commented areas for each platform and table.
Edit the file for your site or application.
Close the file.
After you have connected to the database in which the control tables will be created (via DB2 CONNECT TO database-name), run the file by entering the following command from a command line window:
```
db2 -tf dpcntl.platform_name
```

When you drop customized control tables, you need to customize SQL files for the DROP TABLE statements. The DPNCNTL file contains the SQL for dropping control tables. There is a DPNCNTL file for each platform located in the SQLLIB\SAMPLES\REPL\ directory. The files names are:

DPNCNTL.UDB: Drops control tables for the DB2 Universal Database platform.
DPNCNTL.MVS: Drops control tables for the DB2 for MVS platform.
DPNCNTL.VM: Drops control tables for the DB2 for VSE & VM platforms.

To customize SQL for dropping the control tables:

Open the SQLLIB\SAMPLES\REPL\DPNCNTL.platform_name file as ASCII in an editor, where platform_name is the platform name in the previous list.
Read the commented areas for each platform and table.
Edit the file for your site or application.
Close the file.
After you have connected to the database in which the control tables will be created (via DB2 CONNECT TO database-name), run the file by entering the following command from the command line window:
```
db2 -tf dpncntl.platform_name
```

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]