Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see LOADPLUS for DB2 13.1.

Considerations for reordered row format

This topic describes considerations that apply to reordered row format (RRF) in LOADPLUS.

The following table describes the considerations for RRF:

Option

Additional condition

Consideration

LOAD REPLACE

or

LOAD RESUME YES PART n REPLACE (in which case considerations apply to the partitions that are being replaced)

VALIDPROC or EDITPROC on the table

LOADPLUS uses the existing row format of the table space.

Partition-by-growth table space

LOADPLUS uses the existing row format of the table space. The following requirements apply:

  • All partitions in the table space must be in the same row format.
  • The partitions must be in the following format, based on the Db2 subsystem parameter RRF:
    • When RRF=ENABLE, the format must be RRF.
    • When RRF=DISABLE, the format must be BRF.

FORMAT BMCUNLOAD

LOADPLUS uses the existing row format of the table space. The following requirements apply:

  • The row format on the target table space must be the same as the row format on the source.
  • All partitions in the table space must be in the same row format.

All other conditions

LOADPLUS converts data from BRF to RRF. The following considerations apply:

  • LOADPLUS does not convert objects from BRF to RRF when running on a subsystem that has been migrated directly from Db2 Version 8 to Db2 Version 10, but has not yet been migrated to Db2 Version 10 new-function mode.
  • If a table space is compressed, LOADPLUS builds a new dictionary except when both of the following options are in effect:
    • The value of the LOADPLUS KEEPDICTIONARY option is YES.
    • The value of the Db2 subsystem parameter HONOR_KEEPDICTIONARY is YES.

LOAD RESUME YES

Partition-by-growth table space

LOADPLUS uses the existing row format of the table space. The following requirements apply:

  • All partitions in the table space must be in the same row format.
  • The partitions must be in the following format, based on the Db2 subsystem parameter RRF:
    • When RRF=ENABLE, the format must be RRF.
    • When RRF=DISABLE, the format must be BRF.

FORMAT BMCUNLOAD

LOADPLUS uses the existing row format of the table space. The following requirements apply:

  • The row format on the target table space must be the same as the row format on the source.
  • All partitions in the table space must be in the same row format.

All other conditions

LOADPLUS uses the existing row format of the table space.

Related topic

Operational-considerations

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*