How to change default plan name for DB2/MVS


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:

  1. choose a valid plan name,
  2. make a copy of the current DBRM member and give it the chosen plan name,
  3. edit the new member and change the first line from the default plan name to the chosen plan name,
  4. BIND pointing to the new plan name and member, and
  5. 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.