Plans Editor (IBM DB2 Z/OS)

From DBArtisan
Jump to: navigation, search

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.