Packages Editor (IBM DB2 Z/OS)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for z/OS Object Editors

The Packages Editor lets you manage properties and bind parameters for a package, as well as view environment information, package contents and associated plans.

To edit a package

  1. Open an editor on the package. 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


Lets you work with the following properties: Average Size, Bind Time, Consistency Token, Dec31, Decimal Point, Group Member, Katakana Charset, Language, Mixed Character Set, Operative, Package Size, Package Source, PDS Name, Precompile Timestamp, Release Bound, String Delimiter, SysEntries, Timestamp, and Valid.

Bind Parameters

Lets you set the Schema Path, Creator, Qualifier, Explain, Validate, Degree, Dynamic Rules, Lock Isolation, Encoding, Page Writes, Resource Release, CurrentData, DB Protocol, Reoptvar, Keep Dynamic, Defer Prepare, SQL Error, and Optimization Hint properties.


Displays the plans contained in the package if the package was bound individually, or as part of a complete collection ID.

Optionally, you can:

Select a plan and click Edit to open the Plans editor on the plan. For more information, see Plans Editor (IBM DB2 Z/OS).

Select a plan and click Rebind to initiate rebinding the plan. For more information, see Rebind Plans.

Select a plan and click Free to initiate deleting the plan. For more information, see Drop.


Shows the contents of any package statement on the datasource. Optionally, select a statement and click Explain to copy the statement to an ISQL Editor window. NOTE: For more information, see Using the SQL Editor.


For details on using this tab, see Working with Object Dependencies.


For details on using this tab, see Working with Privileges and Permissions.


Displays run-time environments information for a package. Use the arrow buttons to move environments between the Enabled Environments and Disabled Environments lists. To modify a connection, select the environment and click Edit Connections. For more information, see Connection Editor.


Displays the command that originally built the package.

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

Connection Editor

The Connection Editor lets you modify plan and package connections. It is opened from the Packages editor. For more information, see Packages Editor (IBM DB2 Z/OS).

The table below describes the options and functionality of the Connection Editor:

Option Description


Displays the connections for the plan or package.


Click to add the connection.