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, such as pie graphs or column graphs. Views created for scripted databases do not contain graphical displays of data. For more information about graphical displays of data, see Chapter 2, "Graphical Displays 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: Operations views, Informational views, and Advanced views. Table 3–2 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.

Table 3–2: Database views 
View name
Database type
Description
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.

Note: You access the views listed in Table 3–2 from the Database Details page.

Copyright © 2008 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095