Plans Editor (IBM DB2 Z/OS)

Go Up to IBM DB2 for z/OS Object Editors

The Plans Editor lets you manage plan properties, view DBRM information, manage packages and contents, and manage run-time environments for a plan.

To edit a plan

1. Open an editor on the plan. For details, see Opening an Object Editor.
2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:

Tab	Settings and tasks
Definition	Lets you work with the following attribute groups:
	Properties	Lets you view the Timestamp, Group Member, Plan Size, Average Size, Valid, Operative, Pkg. List Entries, SysEntries, and Release Bound properties. Lets you set the Owner, Qualifier, and Current Server properties.
	Bind Parameters	Lets you set the Schema Path, Explain, Validate, Degree, Dynamic Rules, Lock Isolation, Resource Acquire, Resource Release, Disconnect, Current Data, DB Protocol, Reoptvar, SQL Rules, Keep Dynamic, Defer Prepare, Encoding, Page Writes, Flag, Optimization Hint, and Cache Size properties.
DBRMs	Lists details for each DBRM associated with a plan. Optionally, select a DBRM from the list and click Edit to open the DBRM editor on that DBRM.
Packages	Displays details for each package associated with a plan. Optionally, you can:
		Select a package and click Edit to open the Package editor on that package. For details, see Packages Editor (IBM DB2 Z/OS).
		Select a package and click Rebind to open the Rebind Packages dialog.
		Select a package and click Free to open the Free (Packages) dialog.
DBRM/Packages	Displays the entire contents of the plan, DBRMs and packages, in a single display. The first column contains either a 'D' for DBRM or 'P' for packages. Optionally, take one of the following actions:
		Select a package list entry and click Edit to open the Package editor on that package. For details, see Packages Editor (Oracle).
		Select a package and click Rebind to open the Rebind Packages dialog.
		Select a package and click Free to open the Free (Packages) dialog.
Dependencies	For details on using this tab, see Working with Object Dependencies.
Privileges	For details on using this tab, see Working with Privileges and Permissions.
Environments	Displays run-time environments information for a plan. Optionally, you can:
		Use the arrow buttons to move environments between the Enabled Environments and Disabled Environments lists.
		Select an environment and click Edit Connections to open the Connection editor.
Command	Displays the command that originally built the plan.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.