Release Notes


15.7 Chapter 5. Planning for Replication

15.7.1 Table and Column Names

Replication does not support blanks in table and column names.

15.7.2 DATALINK Replication

DATALINK replication is available on Solaris as part of Version 7.1 FixPak 1. It requires an FTP daemon that runs in the source and target DATALINK file system and supports the MDTM (modtime) command, which displays the last modification time of a given file. If you are using Version 2.6 of the Solaris operating system, or any other version that does not include FTP support for MDTM, you need additional software such as WU-FTPD.

You cannot replicate DATALINK columns between DB2 databases on AS/400 and DB2 databases on other platforms.

On the AS/400 platform, there is no support for the replication of the "comment" attribute of DATALINK values.

If you are running AIX 4.2, before you run the default user exit program (ASNDLCOPY) you must install the PTF for APAR IY03101 (AIX 4210-06 RECOMMENDED MAINTENANCE FOR AIX 4.2.1). This PTF contains a Y2K fix for the "modtime/MDTM" command in the FTP daemon. To verify the fix, check the last modification time returned from the "modtime <file>" command, where <file> is a file that was modified after January 1, 2000.

If the target table is an external CCD table, DB2 DataPropagator calls the ASNDLCOPY routine to replicate DATALINK files. For the latest information about how to use the ASNDLCOPY and ASNDLCOPYD programs, see the prologue section of each program's source code. The following restrictions apply:

15.7.3 LOB Restrictions

Condensed internal CCD tables cannot contain references to LOB columns or LOB indicators.

15.7.4 Planning for Replication

On page 65, "Connectivity" should include the following fact:

   If the Apply program cannot connect to the control server, 
   the Apply program terminates.

When using data blocking for AS/400, you must ensure that the total amount of data to be replicated during the interval does not exceed "4 million rows", not "4 MB" as stated on page 69 of the book.


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