If you changed the plan options with the ALTER PROGRAM ENVIRONMENT command, you must rebind the plan to regenerate the plan using the changed options. If you need to change an alternate plan or regenerate the default plan without recompiling (for example, in a production environment where you do not have the program source), you must use the REBIND command.
The format of the REBIND command is:
{ * }
REBIND {PROGRAM name [VERSION ver] }{FOR AUTHORIZATION AUTHORIZATION}
If you do not specify AUTHORIZATION, the authorization ID of the default plan (stored in the program object) is used. For a complete explanation of the REBIND command syntax, see the Command Reference Guide.
The REBIND command only affects the plan identified with the specified (or implied default) authorization ID, version, and program name. If you issue an ALTER PROGRAM ENVIRONMENT command against a program associated with more than one plan, you must issue the REBIND command for each plan that requires the changed plan options.
Note: If the specified program was converted to load module format, the REBIND command uses the load module. To change plan options without recompiling the program, you must enter the ALTER PROGRAM ENVIRONMENT command before creating the load module. You can enter the REBIND command after the CREATE MODULE command to regenerate the plan.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|