See SHRLEVEL-considerations for important information about using this option.
You can specify the default for the SHRLEVEL option in your installation options module by using the SHRLEVEL installation option. LOADPLUS was shipped with a default value of NONE for this option. The command option overrides the default that is in the installation options module.
SHRLEVEL NONE tells LOADPLUS to drain the objects that you are loading, making them unavailable during the entire load process.
SHRLEVEL REFERENCE tells LOADPLUS to make the objects that you are loading available in read-only status. LOADPLUS writes the loaded data to staging data sets. The original VSAM data sets remain intact throughout the load process. This non-destructive process allows you to easily restart from a failure or make the objects available without having to recover the objects.
For more information about using this option, see Running-SHRLEVEL-REFERENCE.
For LOAD RESUME YES, LOADPLUS uses the Instant Snapshot functionality of XBM or SUF. You must have XBM or SUF installed and available to LOADPLUS. For more information, see SUF-also-known-as-XBM-considerations and Running-SHRLEVEL-REFERENCE.
This option is not valid when LOADPLUS invokes DSNUTILB. LOADPLUS issues message BMC50178E and terminates.
SHRLEVEL CHANGE allows the objects that you are loading to remain in read/write status. This option functions differently depending on whether you specify LOAD REPLACE, LOAD RESUME YES with PART n REPLACE, or LOAD RESUME YES without PART n REPLACE.
For SHRLEVEL CHANGE with either LOAD REPLACE or LOAD RESUME YES PART n REPLACE, LOADPLUS writes the loaded data to staging data sets. The original VSAM data sets remain intact throughout the load process. This non-destructive process allows you to easily restart from a failure or make the objects available without having to recover.
Warning
This option fully replaces the data in the table space or partition, including any inserts, updates, or deletes to the base object that occur during the load process.
For more information about using this option, including the procedure and restrictions for running this type of load job, see Running-LOAD-REPLACE-or-LOAD-RESUME-YES-PART-n-REPLACE.
This option is not valid when LOADPLUS invokes DSNUTILB. LOADPLUS issues message BMC50178E and terminate.
For SHRLEVEL CHANGE with LOAD RESUME YES without PART n REPLACE, 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 BMC AMI Log Master product. However, the High-speed Apply Engine component must be installed and made available through the STEPLIB, JOBLIB, or LINKLIST at runtime.
For important information about using this option, including the procedure for running this type of load and compatibility with other LOAD command options, see Running-LOAD-RESUME-YES-SQLAPPLY-load.
Important
For ease of reference, this space refers to this type of load as an SQLAPPLY load.
If you specify SHRLEVEL CHANGE with LOAD RESUME YES, the following additional command options allow you to control your load job.
| This option is valid only when you specify LOAD RESUME YES without PART REPLACE. SQLAPPLY specifies that you want to use the type of online load that uses a High-speed Apply Engine. For this type of load, LOADPLUS passes processing to a High-speed Apply Engine during the COMBINED phase. For considerations, including restrictions, when using this option, see SHRLEVEL CHANGE considerations. You can specify one or more of the following options to further control your SQLAPPLY load job. The values for these options are passed to High-speed Apply Engine as configuration parameters for use during High-speed Apply Engine processing. Additional considerations The following information applies to the SQLAPPLY options: - When you specify more than one of the following SQLAPPLY options, your syntax must follow the sequence that is shown in the syntax diagram. For example, if you specify APCOMMIT, it must always appear before APOWNER.
- When invoking DSNUTILB, LOADPLUS ignores these options.
| APMAXAGENTS defines the maximum number of agents that High-speed Apply Engine can start for this load. Valid values for this option are 1 through the number of batch threads that are available in your Db2 subsystem. APMAXAGENTS affects only partitioned or multi-table table spaces. LOADPLUS uses at most one agent per partition and table. For partition-by-growth table spaces, LOADPLUS uses only one agent per load regardless of the value that you specify. LOADPLUS passes the value of this parameter to the MaxAgents parameter in the Agent section of the High-speed Apply Engine. For more information about the MaxAgents parameter, see High-speed Apply Engine documentation. Important If you specify a value greater than 1 when the following conditions exist, you might encounter a task deadlock, which could result in the LOADPLUS job failing: - You are loading a partitioned (except partition-by-growth) table space.
- The table space is defined with LOCKSIZE TABLESPACE or LOCKSIZE ANY.
If you encounter this deadlock condition, we recommend that you change the value of this option to 1. Specifying the default You can specify the default for the APMAXAGENTS option in your installation options module by using the APMXAGNT installation option. LOADPLUS was shipped with a default value of 10 for this option. The command option overrides the default that is in the installation options module. | | APCOMMIT specifies the number of records that each High-speed Apply Engine agent should load before issuing a COMMIT statement. Valid values for this option are 1 through 32767. LOADPLUS passes the value of this parameter to the StatementCount parameter in the CommitTriggers section of the High-speed Apply Engine. For more information about the StatementCount parameter, see High-speed Apply Engine documentation. Specifying the default You can specify the default for the APCOMMIT command option in your installation options module by using the APCOMMIT installation option. LOADPLUS was shipped with a default value of 2500 for this option. The command option overrides the default that is in the installation options module. | | APRETRYLIM tells High-speed Apply Engine what measure to use to determine the limit for retry attempts following SQL -911, -913, or -904 errors. The value for this option is used in conjunction with the APRETRYVAL option. The following table describes valid values for the APRETRYLIM option: | |
|---|
| COUNT tells High-speed Apply Engine to base the limit for these retry attempts on the number of attempts that the APRETRYVAL option specifies. | | TIME tells High-speed Apply Engine to retry until it reaches the number of seconds that the APRETRYVAL option specifies. |
LOADPLUS passes the value of this parameter to the RetryLimit parameter in the Conflict section of the High-speed Apply Engine. For more information about the RetryLimit parameter, see the High-speed Apply Engine documentation. Specifying the default You can specify the default for the APRETRYLIM command option in your installation options module by using the APRETLIM installation option. LOADPLUS was shipped with a default value of COUNT for this option. The command option overrides the default that is in the installation options module. | | APRETRYVAL provides High-speed Apply Engine with the retry limit for each unit of recovery in the load job. The value for this option is used in conjunction with the APRETRYLIM option. Valid values are 0 through 32767. A value of 0 tells High-speed Apply Engine not to retry. LOADPLUS passes the value of this parameter to the RetryValue parameter in the Conflict section of the High-speed Apply Engine. For more information about the RetryValue parameter, see High-speed Apply Engine documentation. Specifying the default You can specify the default for the APRETRYVAL command option in your installation options module by using the APRETVAL installation option. LOADPLUS was shipped with a default value of 5 for this option. The command option overrides the default that is in the installation options module. | | APCOLLECTION provides High-speed Apply Engine with the ID for the collection to which High-speed Apply Engine dynamically binds packages during execution. You can specify a collection ID with a length of up to 128 bytes. You cannot specify a null value for this option. LOADPLUS passes this value to High-speed Apply Engine. If you do not specify a value for this command option, one of the following actions occurs: - If the value of the APCOLLECTION installation option is not null, LOADPLUS passes the value to High-speed Apply Engine.
- If the value of the APCOLLECTION installation option is null, LOADPLUS does not pass any value to High-speed Apply Engine.
- High-speed Apply Engine uses the default value of the CollectionID parameter in the Bind section of High-speed Apply Engine.
For more information, see the High-speed Apply Engine documentation. Specifying the default You can specify the default for the APCOLLECTION command option in your installation options module by using the APCOLLECTION installation option. LOADPLUS was shipped without a value for this option. The command option overrides the default that is in the installation options module. | | APOWNER provides High-speed Apply Engine with the authorization ID to use to bind the Db2 plan and packages for the apply request. You can specify an owner ID with a length of up to 128 bytes. You cannot specify a null value for this option. LOADPLUS passes this value to High-speed Apply Engine. If you do not specify a value for this command option, one of the following actions occurs: - If the value of the APOWNER installation option is not null, LOADPLUS passes the value to High-speed Apply Engine.
- If the value of the APOWNER installation option is null, LOADPLUS does not pass any value to High-speed Apply Engine.
- High-speed Apply Engine uses the default value of the BindOwner parameter in the Bind section of High-speed Apply Engine.
For more information, see the High-speed Apply Engine documentation. Specifying the default You can specify the default for the APOWNER command option in your installation options module by using the APOWNER installation option. LOADPLUS was shipped without a value for this option. The command option overrides the default that is in the installation options module. | | APMULTIROW tells the High-speed Apply Engine whether to insert multiple rows in a single insert action and, if so, how many rows to insert at one time. You can specify a value from 0 through 32767. A value of 0 or 1 tells High-speed Apply Engine to insert one row at a time. LOADPLUS passes this value to the MultiRowInsert and MaxRows parameters in the MultiRowInsert section of the High-speed Apply Engine. For more information about these parameters, see the High-speed Apply Engine documentation. Specifying the default You can specify the default for the APMULTIROW command option in your installation options module by using the APMULTIROW installation option. LOADPLUS was shipped with a default value of 100 for this option. The command option overrides the default that is in the installation options module. |
|
