Databases Editor (IBM DB2 Z/OS)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for z/OS Object Editors

The Databases Editor lets you manage basic properties, permissions, and object dependencies for a database.

To edit a database

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

Properties

The Database Creation group lets you view the Name and Group Member properties and set the Type property. The Database Attributes group lets you view the Encoding Scheme, Create Date, and Last Altered properties and lets you set the Tablespace Buffer Pool, Index Buffer Pool, Storage Group, and CCSID properties.

Permissions

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

Dependencies

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

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

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