HP Neoview Release 2.5 Software User Manual
Hp neoview repository user guide
Table of contents
Document Outline
- HP Neoview Repository User Guide
- Table of Contents
- About This Document
- 1 Introduction
- 2 Getting Started with Repository
- 3 Repository Views
- Overview
- Query Statistics
- ODBC Session Data
- Processing Node Statistics
- Disk Statistics
- EMS Events
- Space Management Views and Sample Query Views for Space Management
- VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1
- VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1
- Sample Query Views for Space Management
- SPACE_Q_CATALOG_SIZE_VW1
- SPACE_Q_DISK_FULL_VW1
- SPACE_Q_NUM_GUARDIAN_FILES_VW1
- SPACE_Q_OBJECT_GROWTH_VW1
- SPACE_Q_PARTITION_FULL_VW1
- SPACE_Q_SYSTEM_DETAILS_VW1
- SPACE_Q_SYSTEM_TOTAL_SIZE_VW1
- SPACE_Q_TABLES_BY_SCHEMA_VW1
- SPACE_Q_TABLE_FULL_VW1
- SPACE_Q_TABLE_SIZE_VW1
- SPACE_Q_TOP_10_CATEGORY_SIZE_VW1
- SPACE_Q_TOP_10_NON_PARTITION_DETAIL_VW1
- SPACE_Q_TOP_10_PARTITION_DETAIL_VW1
- SPACE_Q_TOP_10_SCHEMA_SIZE_VW1
- SPACE_Q_TOP_10_TABLE_SIZE_VW1
- SPACE_Q_TOP_10_USER_SPACE_SIZE_VW1
- 4 Examples and Guidelines for Creating Repository Queries
- Overview
- Get the Number of Rows in a View
- Retrieve a Specified Number of Rows from a View
- Retrieve Statistics for Completed Queries
- Retrieve Statistics for Incomplete Queries
- List Statement Counts for a Selected Time Period
- Count Completed Queries, According to Specified Criteria
- Completed Queries Executed on a System in the Last 24 Hours
- Completed Queries Executed on a System in the Previous Two Days
- Queries within the Past 24 Hours, Grouped by Client Name
- Queries within the Past 24 Hours, Grouped by Data Source
- Queries within the Past 24 Hours, Grouped by Client Name and Including Average and Maximum Elapsed Time
- Formatting Techniques to Enhance Readability of Query Output
- Retrieving UCS2 Columns From a Workstation Configured for ISO8859-1
- A Sample Queries for Event Information
- B STATEMENT_TYPE Field
- C Repository Views Disabled by Default
- D History of New and Changed Information in Previous Releases of the Repository
- E Pre-R2.5 Query Statistics Views
- F History of Field Changes for Repository
- Glossary
- Index