DB2 Replication Guide and Reference

Data Restrictions

Currently, IBM Replication cannot replicate certain types of data. Here is a list of the major restrictions of which you should be aware:

• Archive log access restrictions with DB2 for MVS V3.1, and DB2 for VSE & VM

  IBM Replication cannot replicate data that is held only in a DB2 archive log unless you are using DB2 for MVS V4.1 or higher or DB2 Universal Database.

• Data compression restrictions with DB2 for MVS

  IBM Replication can replicate data that is compressed through DB2 software or hardware compression on DB2 for MVS V4.1 or higher if the compression dictionary that was used to compress the row is available. Before issuing REORG for compressed replication sources, perform one of the following tasks:

  • Ensure that the Capture program has completed capturing all of the existing changes.

  • Use the KEEPDICTIONARY option on the REORG command to preserve the existing compression dictionary.

  IBM Replication cannot replicate data that is compressed through EDITPROCs or FIELDPROCs.

• Utility program restrictions

  IBM Replication cannot capture the data updates made by any of the database utilities. This restriction applies also to data loaded with an option of LOAD RESUME LOG YES.

• Data encryption restrictions

  IBM Replication cannot replicate data that is encrypted.

• Data type restrictions

  Based on the current level of IBM Replication described in this book, here is a full list of the data types that cannot be replicated under any circumstances:

  • Binary large objects (BLOBs)
  • Character large objects (CLOBs)
  • Double-byte character large objects (DBCLOBs)
  • Any column on which an EDITPROC has been defined
  • Any column on which a FIELDPROC has been defined
  • Any column on which a VALIDPROC has been defined
  • Binary data types with precision

  Here is a list of the data types that can be replicated only under certain circumstances:

  • Long variable graphic (LONG VARGRAPHIC) requires that the source and target tables are in DB2 for MVS, DB2 for VSE, or DB2 for VM.

  • Any user-defined type (distinct data type in DB2 Universal Database) will be converted to the base data type before replication.

[ DB2 List of Books | Search the DB2 Books ]