Preparing DB2 internal format input records that are not generated by UNLOAD for LOAD
Before you load records that are in DB2® internal format, but are not generated by the UNLOAD utility, you need to modify the input records.
About this task
For LOAD input records that are in DB2 internal format, the seventh bit of the first byte in each record needs to indicate whether the record is in basic row format or reordered row format. A value of 0 in the seventh bit of the first byte indicates that the record is in basic row format. A value of 1 indicates that the record is in reordered row format.
Procedure
If your input records are in DB2 internal
format, and you did not use UNLOAD with FORMAT INTERNAL to generate
the input data, you need to set the seventh bit of the first byte
of each record to indicate the row format of the record.
To avoid extra row format conversions that degrade performance, ensure that input data rows are in the row format of the target table space or partition.