Use the Administration Explorer view
with the Object List to connect to and browse
databases, and to work with your database objects.
In the Administration Explorer, the All
Databases folder contains user-defined connections and connections
that are read from the local database catalog. Initially, instance
names under the host systems are represented by the associated port
number until you establish a connection and an instance name is determined.
The databases are listed under the instances.
The Working Sets folder is displayed at the same hierarchical
level as the All Databases folder. When you define a working
set, only the objects that belong to the databases that you specify
are displayed, which makes working with a group of related objects
easier. When you expand a working set, the databases are displayed.
Each database can contains two types of folders:
- Change Management Scripts folder
- Each database has one Change Management Scripts folder, which
is used to store change management scripts.
A Change
Management Scripts folder is displayed only if you have
installed the Database Change Manage feature of Optim™ Database
Administrator and
have enabled change management capability.
- Object type folders
- Each database has folders that represent the object types within
the database. When you click an object type folder, the Object
List opens in the editor area of the workbench. The Object
List displays the objects for the object type that you selected, including
various properties for each object. These folders are also called
flat folders because they cannot be expanded to display the objects
directly in the Administration Explorer.
You
must use the Object List to work with the objects.
You can use the context-sensitive menu for an object to perform various
actions on the object.
Use the
Administration Explorer to do the
following types of tasks:
- Create and manage database connections.
- Open the Object List to browse database objects
and work with those objects.
- Initiate actions to create new database objects.
- Initiate actions to run utilities on instances and databases.
- Define a working set to limit the objects that the Administration
Explorer displays to only those objects that come from
the databases that you specify.
Use the
Object List to do the following types
of tasks:
- Display the objects that are related to the database object that
you select.
- Display table data.
- Modify data objects and manage changes.
- Initiate actions to run utilities on the data objects.
- Sort the data that is displayed.
- Filter the data that is displayed.
- Change which properties are displayed for the objects
- Create custom properties to be displayed for the objects