Overview of SmartSwitch feature
The SmartSwitch feature lets you take advantage of the BMC AMI Load for Db2 (BMC AMI Load) product without changing your existing LOADPLUS JCL. SmartSwitch dynamically "switches" jobs from LOADPLUS to BMC AMI Load, based on BMC AMI Load capabilities and the rules that you specify to comply with your business needs. With SmartSwitch, you can enhance performance by exploiting a mixture of LOADPLUS and BMC AMI Load functions.
Licensing requirements
To use SmartSwitch, the following conditions must exist:
- You are using version 11.2.00 of LOADPLUS.
- You are using version 11.2.00 or 12.1.00 of BMC AMI Load.
- You have a license to use at least one of the following BMC solutions:
- BMC AMI Utilities for Db2
- BMC AMI Database Administration for Db2
- BMC AMI Unload-Load for Db2
Limitations
Version 11.2.00 of BMC AMI Load can execute a LOADPLUS job with a DDTYPE option to dynamically allocate one or more COPY data sets, but you must modify the REXX automation control point to allocate the COPY data sets.
When specifying UPDATEDB2STATS YES and switching to BMC AMI Utilities, LOADPLUS updates only cardinality statistics. Frequency stats are not updated.
For more information about SmartSwitch, see the following references:
Task | Reference |
---|---|
How SmartSwtich works | |
Managing SmartSwitch rules | |
Troubleshooting SmartSwtich |
For more information, view the Quick Course Setting up SmartSwitch. |
Related topics