LOAD enhancements

Db2 12 introduces enhancements to the LOAD utility.

Db2 12 introduces the following improvements to the LOAD utility:

LOAD PART REPLACE with dummy input against an empty partition-by-range (PBR) partition

You can now benefit from reduced elapsed and CPU time.

LOAD SHRLEVEL CHANGE PARALLEL support for partition-by-growth (PBG)

Removes the single input parallelism restriction for PBG table spaces for LOAD SHRLEVEL CHANGE.

Additional zIIP offload

You can offload the RELOAD phase of the LOAD utility, including the data conversion and loading of the record into the page set.

LOAD RESUME BACKOUT YES to avoid RECP on failure

Adds a new option on LOAD RESUME SHRLEVEL NONE to allow LOAD to back out the rows already loaded upon encountering an error (such as conversion, LOB/XML, duplicate key, referential integrity violation) without leaving the page set in RECP.

PREFORMAT support for auxiliary tables

Support is extended to LOB table spaces and auxiliary indexes.

Maintain MAXASSIGNEDVAL for identity columns

LOAD maintains the MAXASSIGNEDVAL for user-provided input.

LOAD REPLACE support for COMPRESSRATIO column

Gathers the average compression ratio at the record level instead of the page saved level.