XBM and SUF considerations
To enhance performance, LOADPLUS uses several features of
XBM
or
SUF
during portions of the load process.
If you have installed the required version of XBM or SUF, LOADPLUS can use the following XBM or SUF functions:
- Instant Snapshot functionality for a LOAD RESUME YES SHRLEVEL REFERENCE job
- Software snapshot functionality for referential constraint checking
- zIIP processing
XBM and SUF are licensed, installed, and maintained separately from LOADPLUS. You can use either XBM or SUF, depending on the license that you have obtained:
- A license for the full version of the XBM product authorizes you to use all XBM features.
- A license for SUF authorizes you to use only the snapshot and zIIP-processing features of XBM.
For more information, see theEXTENDED BUFFER MANAGER for DB2 documentation.
Considerations for using XBM or SUF with LOAD RESUME YES SHRLEVEL REFERENCE
When performing a LOAD RESUME YES SHRLEVEL REFERENCE load, LOADPLUS uses the Instant Snapshot functionality of XBM or SUF to create a consistent copy of the participating table space or partitions. LOADPLUS uses this copy as the staging data set for the load process.
For more information, including the procedure and requirements for running this type of load job, see Running-SHRLEVEL-REFERENCE.
Considerations for using
XBM or SUF to enforce referential constraints
LOADPLUS uses the software snapshot functionality of XBM or SUF to make a consistent image of the primary indexes on the parent table of the table that you are loading, without making those indexes unavailable.
If you do not have an appropriate version of XBM or SUF installed and available to LOADPLUS, specifying ENFORCE RI or ENFORCE CONSTRAINTS causes LOADPLUS to terminate.
For more information, including the procedure for enforcing referential constraints, see Referential-and-check-constraints.