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.