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.

Related topics

Using DELETEFILES with SmartSwitch and the BMC AMI Utilities

NGTSSJCL-data-set

NGTSSSYN-data-set

BMCHIST-table

Licensing requirements

To use SmartSwitch, the following conditions must exist:

  • You are using version 13.1.00 of LOADPLUS.
  • You are using version 13.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.

Limitations

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


QuickCourseArrow.png

For more information, view the Quick Course Setting up SmartSwitch.


 

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