Replication Agent supports these DB2 UDB 9.5 features:
Large identifiers – the length limit for most identifiers, for example, authorization ID, column, schema, has increased from 18 and 30 bytes to 128 bytes.
To support UDB 9.5 large identifiers, you must upgrade Replication Agent instances from versions 15.2 to 15.5, to accommodate the modified Replication Agent system tables. You must also upgrade Replication Agent instances when UDB is upgraded from an earlier version to 9.5. See the Replication Agent 15.5 Primary Database Guide for upgrade steps.
Replication of DECFLOAT datatype – this datatype combines the accuracy of DECIMAL with some of the performance advantages of FLOAT. DECFLOAT datatype can have either 16 or 34 digits of precision.
Replication Agent does not support these features of DB2 UDB 9.5:
Replication Agent does not support replication of XML datatype, so restrictions have been imposed on marking a table containing XML columns. Replication Agent generates an error message each time an attempt is made to mark a table with XML columns.
However, you may override this behavior by using the force keyword when marking a table. If the table containing an XML column is marked, Replication Agent skips the data in the XML columns and the XML data is not replicated.
When replicating DECFLOAT columns from UDB to other back ends that do not support DECFLOAT or an equivalent datatype, DECFLOAT is mapped to FLOAT, which may cause a loss of precision.
Replication Server 15.5 heterogeneous datatype support
(HDS) scripts are required to replicate DECFLOAT.
Replication Agent does not support replication of DECFLOAT special values such as positive and negative INFINITY, NAN, and SNAN. Replication Agent replicates these values to NULL if the column is nullable, or “0.0” if the column is not nullable.
For more information, see the Replication Agent 15.5 Primary Database Guide.
