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
Important
These solutions also give you access to BMC AMI Command Center for Db2 product functions, which you will use to set up and manage SmartSwitch rules.
Tip
SmartSwitch switches to BMC AMI Load more often with version 12.1.00 than with version 11.2.00 because version 12.1.00 contains additional features (for example, OUTPUT statement support). Therefore, although SmartSwitch is compatible with version 11.2.00 of BMC AMI Load, BMC recommends upgrading to version 12.1.00 as soon as possible.
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 | How SmartSwitch works |
Managing SmartSwitch rules | Using SmartSwitch |
Troubleshooting SmartSwtich | Troubleshooting SmartSwitch |
For more information, view the Quick Course Setting up SmartSwitch. |
Comments
Log in or register to comment.