Dynamic bind


BMC AMI Copy uses a dynamic bind process, which is a proprietary technology of BMC.

The dynamic bind process uses packages instead of plans to optimize the DBRM bind process and allows SQL preparation to be completed during execution.

Related topic


Important

We recommend that you execute the installation verification procedure (IVP) that the Installation System generates. Doing so avoids potential bind issues, including authorization issues, during later executions of the utility. For more information, see Installation System documentation.

Based on the dynamic bind technology, BMC AMI Copy has the following behavior when it is retrying plan OPENs and BINDs:

  • If the initial plan OPEN fails because the plan is not found, is invalid, or you lack authority and the plan is bound successfully, BMC AMI Copy retries the OPEN.

    Important

    If the reason code for the initial OPEN failure is lack of authority, the error might be due to the plan not existing or to insufficient user privilege. If GRANT EXECUTE to PUBLIC is supported, BMC AMI Copy attempts to BIND the plan even though the plan might already be bound.

    If the reason code for the initial OPEN failure is lack of authority and GRANT EXECUTE to PUBLIC is not supported, BMC AMI Copy will not allow the BIND attempt.

  • If the initial plan OPEN fails for any other reason than the plan is not found, is invalid, or you lack authority, BMC AMI Copy retries the OPEN, but does not attempt a plan BIND.
  • If the plan BIND is successful, but the following retry of the OPEN fails, BMC AMI Copy does not retry the plan BIND regardless of the reason for the OPEN failure.
  • If the BIND fails because of a deadlock, BMC AMI Copy retries the OPEN, and if the OPEN fails for any of the reasons listed above, the BIND is retried. Otherwise, the BIND is not retried.
  • If the BIND attempt is not allowed by BMC AMI Copy or fails for any reason, no retry of the OPEN or the BIND is done.

Important

If the dynamic bind is not supported, BMC AMI Copy does not allow the BIND attempt.

See also the description for the BINDQUALIFIER=ACP vvr and PUBLICPLAN=YES.

 

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