Use the new DB2 version 9.1 reordered row format (RRF) option to automatically move variable-length column data to the end of each physical row of data. Because log records are a copy of what is stored in the database for each row, log records in Replication Agent for DB2 UDB also are kept in the RRF format.
Each log record has a bit flag that indicates whether the table row data is in column or reordered format. RRF:
Places fixed-length columns at the front of the row.
Lists displacements to the variable-length columns after the fixed columns.
Places all variable columns at the end of the row.
To the DB2 user, columns appear to be in the same order in which they were defined. DB2 and Replication Agent for DB2 UDB both process the row’s columns in the order that they were specified at table creation. The row’s columns are passed to Replication Server in the same order as in earlier versions of Replication Agent for DB2 UDB.
See the IBM DB2 version 9.1 for z/OS documentation for more information.
