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 and 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.
- Restrictions when using DB2 Extended Enterprise Edition and Data
Sharing Environments
- There should be no more than one Capture program per sysplex in a
data-sharing environment.
- The Capture program does not support EEE; user tables on a EEE server
cannot be defined as replication sources. The Control Center rejects attempts
to define replication sources at an EEE server.
- 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 character string (LONG VARCHAR) requires that the source and
target tables are in DB2 for MVS, DB2 for VSE, or DB2 for VM.
- 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.
