When BLOB, CLOB, or DBCLOB data is stored fully inline, the row size in the base table space is limited by the maximum DB2 page size of 32 KB. The DB2 ECCR can capture LOB data up to the inline length, provided that this length does not exceed the 32-KB page size limit minus the size of the DB2 control fields and the size of the columns. PowerExchange delivers the inline LOB data to PowerCenter workflows that use a DB2zOS CDC application connection.

When CLOB (including DBCLOB) data is stored fully or partially in an auxiliary table space, you can use the new generated DTL__ST column in the extraction map to determine if the CLOB data in the PowerExchange Logger log files is complete or incomplete. If the CLOB data is incomplete, you can use an Expression transformation and unconnected Lookup transformation in the PowerCenter workflow to retrieve all of the current CLOB data from the DB2 source table so that all of this data can be delivered to the target. Informatica recommends that you use a single target because the use of multiple targets can cause updates to be applied in the wrong sequence.

When BLOB data is stored fully or partially in an auxiliary table space, PowerCenter cannot retrieve all of the BLOB data because of limitations related to using binary ports in Lookup transformations. In this case, contact Global Customer Support to determine if a custom solution is available.