HP Neoview Release 2.4 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
- Process Statistics
- Table 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 History of New and Changed Information in Previous Releases of the Repository
- C Pre-R2.4 SP2 Query Statistics Views
- Query Statistics for R2.4 SP1
- Query Statistics for Pre-R2.4 SP1
- VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1_2400
- VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400
- VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400
- Query Statistics for Release 2.4
- VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1
- VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2
- VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1
- D History of Field Changes for Repository
- Glossary
- Index