SUF (also known as XBM) considerations


To enhance performance, LOADPLUS uses several features of SUF (also known as XBM) during portions of the load process.

If you have installed the required version of 

SUF

 (also known as 

XBM

), LOADPLUS can use the following 

SUF

 (also known as 

XBM

) functions:

  • Instant Snapshot functionality for a LOAD RESUME YES SHRLEVEL REFERENCE job
  • Software snapshot functionality for referential constraint checking
  • zIIP processing

SUF (also known as XBM) are licensed, installed, and maintained separately from LOADPLUS. You can use either SUF (also known as XBM), depending on the license that you have obtained:

  • A license for the full version of the SUF (also known as XBM) product authorizes you to use all SUF (also known as XBM) features.
  • A license for SUF (also known as XBM) authorizes you to use only the snapshot and zIIP-processing features of SUF (also known as XBM).

Important

If you are licensed only for a BMC solution that contains LOADPLUS, your license authorizes you to use SUF, not the full version.

For more information, see the SNAPSHOT UPGRADE FEATURE for DB2 documentation..

Considerations for using SUF (also known as XBM) with LOAD RESUME YES SHRLEVEL REFERENCE

When performing a LOAD RESUME YES SHRLEVEL REFERENCE load, LOADPLUS uses the Instant Snapshot functionality of SUF (also known as XBM) 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 SUF (also known as XBM) to enforce referential constraints

LOADPLUS uses the software snapshot functionality of SUF (also known as XBM) 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 SUF (also known as XBM) 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.


 

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