Running LOAD RESUME YES (SQLAPPLY load)

• LOAD RESUME YES SHRLEVEL CHANGE SQLAPPLY
• LOAD RESUME YES SHRLEVEL CHANGE without PART n REPLACE

For an SQLAPPLY load, the object that you are loading remains in read/write status while LOADPLUS loads the data by using SQL insert processing.

For this type of load, LOADPLUS uses the High-speed Apply Engine component of the BMC AMI Log Master for Db2 product. This feature does not require that you have a license for the Log Master product. However, the High-speed Apply Engine must be installed and made available through the STEPLIB, JOBLIB, or LINKLIST at runtime. The High-speed Apply Engine is installed separately from the Log Master product.

To run an SQLAPPLY load job

1. Ensure that a minimum of version 11.1.00 of the High-speed Apply Engine is available to LOADPLUS.
2. Ensure that you have the appropriate authorizations.For information about these authorizations, see Setting-LOADPLUS-authorizations.

3. With your LOAD command, specify one of the following syntax options or the equivalent installation option:

   • RESUME YES SHRLEVEL CHANGE SQLAPPLY
   • RESUME YES SHRLEVEL CHANGE without PART n REPLACE

   Optionally, specify one or more of the options that are available with SHRLEVEL CHANGE SQLAPPLY. For information about these options, see SHRLEVEL.

4. Include an APTDUMP DD statement in your JCL.If High-speed Apply generates a SNAP dump in response to an error, High-speed Apply writes the dump to this data set. For more information, see APTDUMP-data-sets-in-LOADPLUS.
5. Use the information in Considerations for an SQLAPPLY load to make any necessary changes to your JCL or environment.