Neoview Management Dashboard Client Guide for Database Administrators (R2.3)
Table Of Contents
- HP Neoview Management Dashboard Client Guide for Database Administrators
- Table of Contents
- About This Document
- 1 Introduction to Dashboard
- 2 Installing the Client
- 3 Starting and Running the Client
- 4 Using the Client Windows
- Browse Window
- Browse Window Toolbar Button Summary
- Browsing and Analyzing Segments, Entities, and Objects
- Other Browse Window Toolbar Functions
- Command Wizard Toolbar Button
- Download Wizard Toolbar Button
- Object State Change Toolbar Button
- OEM Toolbar Button
- OIL Toolbar Button
- Properties Toolbar Button
- Refresh With Latest Data Button
- Rotate Graph Control
- Rotate Graph Toolbar Button
- Sort View Toolbar Button
- Suppress States Toolbar Button
- Thresholds Toolbar Button
- Browse Window Pull-Down Menus
- Browse Window File, Edit, View, and Help Menus
- Browse Window Shortcut Menus
- Object State Changes (OSC) Window
- Graph Window
- Report Window
- Session Window
- 5 Using the Client Property Sheets
- Attribute Property Sheet
- Font Property Sheet
- General Property Sheet
- Annotate Grid With States Check Box
- Clear Registry Button
- Command Wizard Check Box
- Data Query Tool Bar Enable Check Box
- Icons Button
- New Graph on Data Grid Double Click Check Box
- Reports Auto Refresh Check Box
- Set Password Button
- Show Help in Grid Check Box
- Show Splash Screen Check Box
- Show Removed Objects Check Box
- Stretch/Compress Grid Columns to Fit Window Check Box
- Graph Property Sheet
- Icon Server Control Panel
- OEM Property Sheet
- OIL Property Sheet
- OSC Property Sheet
- Monitor Object State Changes Check Box
- Display Log Window Check Box
- State Upgrades Monitored Check Box
- Notify Button
- State Downgrades Monitored Check Box
- Minimum State Change Monitored List
- Maximum Change History Retained in Log List
- Late Data Integrity Check List
- Audible Alert State Threshold List
- Notify Control Panel
- SSG Property Sheet
- Client Server Gateway Check Box
- Retrieval Options
- Sample Delay Options
- Trace Requests Check Box
- Trace Replies Check Box
- Trace Audits Check Box
- Show CSG Until Connected Check Box
- Auto Connect to CSG at Startup Check Box
- Auto Restart Session Check Box
- Max Rows/Object Field
- SSG/CSG Advanced Button
- SSG/CSG Advanced Control Panel
- Exit Shutdown Check Box
- Data Cache Check Box
- SSG Cache Field
- Enable Flow Control Option
- Disable Flow Control Option
- Accept Server Initiated Flow Control Option
- Term Name Check Box
- User Name Field
- Defaults Button
- 6 Using Entity Screen Information
- 7 Using Command and Control to Manage Queries
- 8 Switching Between Neoview Platforms
- Index
Table Entity Attributes
Table 6-6 describes the attributes displayed on the Table entity screen.
Table 6-6 Table Entity Attributes
Default Attribute
for Grid?
Default Attribute
for Graph?
DescriptionAttribute
YesNoCatalog name of the table or materialized view.Catalog
YesNoSchema name of the table or materialized view.Schema
YesNoName of the table or materialized view. If you
rename the object, the new name will appear
the next time the display is refreshed.
Name
YesNo“Table” for a table, “Mat View” for a
materialized view.
Type
YesYes“Up” means the table or materialized view is
being monitored. “Dropped” means that the
table or materialized view was dropped or
renamed, and no other object with the same
name was created. “Removed” means the table
or materialized view is no longer being
monitored and will stop appearing in displays
15 minutes after that change in status.
“NoTable” means that a table was specified in
the Dashboard server configuration as a
monitored object, but no table of the specified
name exists. If all missing statistics for an
automatically monitored object are updated
and the reorg status is Complete, the object will
no longer be monitored and will disappear
from the display after fifteen minutes.
Status
YesYesList of columns lacking statistics, along with
the number of missing statistics warnings. A
single column name indicates that histogram
statistics are needed for that column; a
parenthesized list indicates that a multi-column
histogram for that set of columns is needed.
Items in the list are in descending order by the
number of missing statistics events generated
for the column since the table or materialized
view began to be monitored; this count is given
in parentheses after the column name. If no
columns or sets of columns have missing
statistics, the value “-” is displayed. Updating
statistics for a column will cause that column
to be removed from this list.
NOTE: The count of missing statistics events
does not take into account query caching. If a
query compile results in the use of a cached
query plan, no additional missing statistics
event is generated.
MissingStats
YesYesTotal number of missing update statistics
events for the table or materialized view since
it began to be monitored. This number is the
sum of missing statistics events for individual
columns, as displayed in the MissingStats
attribute. Changing the Dashboard
configuration (on the server side) so that the
table or materialized view is no longer
monitored causes MissingStatsCnt to be reset
to zero.
MissingStatsCnt
98 Using Entity Screen Information