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
2 Click the Databases tab, and click the database you want.
3 Click the appropriate tab to view database-specific statistics.
n
In the Backup & Recovery tab, monitor backups and perform recovery operations.
n
In the Alarms tab, view warnings and alarms, such as health check and application status alarms.
n
In the Tasks & Events tab, view tasks, events, and their status.
n
In the Reports tab, view statistics reports or revise settings such as sampling intervals.
n
In the Logs tab, view the database activity log. You can also download the log from this tab.
n
In the Permissions tab, view roles, assign roles, or grant permissions.
SQL Management
Managing SQL includes developing and testing SQL queries and monitoring and tuning query performance.
You must have appropriate permissions on the schema and database to develop and manage SQL queries. You
can manage SQL from the schema page.
Enter and Run a SQL Query
Create and modify SQL queries.
Prerequisites
You are logged in to Data Director as a user with appropriate privileges on the database or schema.
Procedure
1 Click the Manage & Monitor tab and select the schema for which you want to manage SQL queries.
2 Click Enter SQL.
The SQL dialog box has the following sections.
n
Entry pane.
n
Output pane. Allows you to examine query output, examine the query's actual run time and cost,
view any output messages, and examine query run history.
3 Enter a query in the entry pane.
You can type or modify a SQL query, test the query, and analyze the query's execution plan before running
it.
n
Type the query in the entry pane.
n
Click Open to open a SQL script file.
4 Click Execute to run the query.
If the query runs successfully, data appears in the Output pane.
If the query does not run successfully, Data Director shows the error message in the Messages tab.
To cancel the query, click Cancel.
Chapter 9 Managing Database Entities
VMware, Inc. 75