Try OpenEdge Now
skip to main content
Database Management
Examining Data from an OpenEdge Database : Understanding OpenEdge database views
 

Understanding OpenEdge database views

The various database views display data about key database components so that you can assess what is happening with the databases. The database agent gathers data for the views by polling the database's Virtual System Tables (VSTs). (View data does not come from the OpenEdge Management Trend Database.) For more information on VSTs, see OpenEdge Data Management: Database Administration.
Views capture information at a specific point in time. Because database status can change from moment to moment, refresh the detail frame to keep the view's data current. All views display the date and time they were built.
Different database views appear in different formats; some include graphical displays of data. Views created for scripted databases do not contain graphical displays of data. For more information about graphical displays of data, see GraphicalDisplays of Database Data.
Some views allow you to narrow the scope of data by clicking on any underlined subject. Note that underlined subjects behave differently than the underlined column headings. Clicking an underlined column heading does not bring you to a more detailed view of the subject; instead, it changes the column's sort order. If the default sort order for a column is ascending, clicking the heading will change the sort to descending. If the default sort order is descending, clicking the heading will make it ascending. Note that when you change the sort order, the page automatically refreshes.
Database views are organized into three overall categories: Informational views, Operational views, and Advanced views. The following table lists and describes all database views, and indicates whether the view can be created for both managed and scripted databases or only for managed databases.
To access the database views, click Resources > Go to Resources and select the required database using the filtering or search options. You can find the following database views on the Database details page:
Table 4. Database views
View name
Database type
Description
Database configuration
Configuration details of the database
Performance Summary
Summary information of buffers, records, transactions, page writers, locks, and connections
Vital Signs
Managed and scripted
Summary of important database information
File Systems
Managed
List of file systems and associated files that the database uses (not available for remote databases)
Storage Areas
Managed and scripted
Storage area and extent information and statistics
User Activity
Managed and scripted
Information about connected users and user statistics
Record and Index Activity
Managed and scripted
I/O activity for tables and indexes
Locks and Latches
Managed and scripted
Information about lock and latch activity
Transactions
Managed and scripted
Information about database transactions
Memory Resources
Managed and scripted
Summary of buffers, memory, etc.
Page Writers
Managed and scripted
Summary of page writer activities
Start Parameters
Managed and scripted
Detail about the database start parameters
General Details
Managed and scripted
General information about the database, such as start, backup, etc.
Raw VST Data
Managed and scripted
Examination of individual VST tables
Raw System Table Data
Managed and scripted
Examination of individual system tables
* Database Configuration view
* Performance Summary view
* Vital Signs view
* File Systems view
* Storage Areas view
* User Activity views
* Record and Index Activity view
* Locks and Latches views
* Transactions view
* Memory Resources view
* Page Writers view
* Advanced views