For CA Datacom SQL access, a program can run under its own default-plan or under another assigned plan. The default plan is generated automatically when you compile the program, using the plan options set in either the Environment fill-in of the program definition or the site and session DBSQL options. You can also create alternate plans for a program by entering the DEFINE AUTHORIZATION command.
The plan name is composed of the authorization ID and the program name in the following format:
authid-$Ivvvsssprogram
Authorization ID specified in either the Environment fill-in or the DEFINE AUTHORIZATION command.
Supplied by the system, it indicates that the plan is for a CA Ideal program.
Version of the program.
System where the program resides.
Name of the program.
When the plan is generated, it is stored as an entity in the PLAN table in the dictionary. The plan options are stored as intersection data in the PGM-PLN-USES relationship in the dictionary. (The program object also includes the plan options.) To change the plan, you must either recompile the program or rebind the plan. When you create an alternate plan for the program with the DEFINE AUTHORIZATION command, the plan options are copied from the PGM-PLN-USES relationship. For more information about creating alternate plans, see Maintaining Access Plans for the Runtime Environment in this chapter.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|