By default, SASĀ® expects that a plan exists when it tries to connect to DB2. If you want to use a different plan name or have multiple plans, there are several steps required:
- choose a valid plan name,
- make a copy of the current DBRM member and give it the chosen plan name,
- edit the new member and change the first line from the default plan name to the chosen plan name,
- BIND pointing to the new plan name and member, and
- set the SAS system option DB2PLAN= to the new plan (this can be done in a CONFIG file, at SAS invocation, or on an OPTIONS statement).
You can use multiple plans in a SAS job, but can only use one plan at a time.