DBRMs Editor (IBM DB2 Z/OS)

Go Up to IBM DB2 for z/OS Object Editors

The DBRM Editor lets you view into the metadata of each DBRM, view and cross-reference all associated Plans and Packages as well as view and Explain all Package SQL Statements.

To edit a DBRM

1. Open an editor on the DBRM. 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
Description	Displays the main contents of the DBRM header information, including the Precompile Timestamp, Language, and Consistency Token, as well as String Delimiter, Katakana Charset, Mixed Character Set, and Decimal Point specifiers.
Plans	Lists details of the plans containing the DBRM. 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.
Packages	Displays a cross-reference to the collections, packages, and plans where the DBRM was bound. Optionally, you can:
		Select a package and click Edit to open the Packages editor on the package. For more information, see Packages Editor (IBM DB2 Z/OS).
		Select a package and click Rebind to initiate rebinding the package. For more information, see Rebind Packages.
		Select a package and click Free to initiate deleting the package. For more information, see Free (Packages).
Statements	Displays the information about the SQL statements in the DBRM. The information is for programmers reference only. Optionally, click Explain to copy the selected statement(s) to an ISQL window. The Explain output displays in the report pane. For more information, see Using the SQL Editor.

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