1.0
Table Of Contents
- VMware vFabric Data Director Administrator and User Guide
- Contents
- About VMware vFabric Data Director
- Updated Information
- VMware vFabric Data Director and vFabric Postgres Overview
- Managing Data Director Resources
- Managing Users and Roles
- Managing Organizations
- Managing Database Groups
- Managing Database Templates
- Managing Databases
- Cloning Databases
- Managing Database Entities
- Safeguarding Data
- Monitoring the Data Director Environment
- Managing Licenses
- Reconfiguring Data Director Networks
- Change the vCenter IP Address
- Reconfigure the Web Console Network Mapping or Network Adapter
- Reconfigure the vCenter Network Mapping
- Reconfigure the vCenter Network Adapter Settings
- Reconfigure the DB Name Service Network or DB Name Service Network Adapter
- Reconfigure the Internal Network or Internal Network Adapter Mapping
- Verify Network Settings in Data Director
- Data Director Troubleshooting
- Index
n
Backing up databases.
SQL Management
SQL management tasks include SQL profiling, query plan analysis, running
ad-hoc queries or SQL scripts.
After you log in to an organization in Data Director, click the Manage & Monitor tab to view your database
groups and databases. You see a list of database groups to which you have access and the list of databases
within that database group. To view a database and its entities, double-click the database in the middle pane.
The database appears under the database group in the left pane. You can expand the database to view its
entities and the objects those entities contain, such as schemas and the number of tables, views, and other
objects.
You can perform administrative and SQL management tasks.
n
Monitoring database status and resource usage.
n
Alarms.
n
Status of tasks and events.
n
Viewing reports.
n
Checking the database logs.
n
Entering SQL queries.
n
Obtaining the JDBC connection string.
To manage a specific database entity or object, click the entity or object in the left pane. The entity or object
appears in the middle pane and you can perform management tasks.
This chapter includes the following topics:
n
“Database Entity Management,” on page 66
n
“Database Administration,” on page 70
n
“SQL Management,” on page 75
Database Entity Management
You can manage database entities such as databases, schemas, users, and roles from the Data Director Manage
& Monitor tab.
Managing database entities includes creating, altering, dropping, and browsing database entities such as the
following.
n
Schemas
n
Tables
n
Views
n
Columns
n
Indexes
n
Sequences
n
Constraints (primary, foreign, and unique key)
n
Users
Click any of the schema objects in the left pane to view a list of the objects in the middle pane. You can manage
individual objects from the middle pane.
VMware vFabric Data Director Administrator and User Guide
66 VMware, Inc.