HP Neoview Release 2.5 Software - Manual (Page 3)

Table of Contents
About This Document.........................................................................................................9
Supported Release Version Updates (RVUs)..........................................................................................9
Intended Audience.................................................................................................................................9
New and Changed Information in This Edition.....................................................................................9
Document Organization.......................................................................................................................10
Notation Conventions...........................................................................................................................10
General Syntax Notation.................................................................................................................10
Related Documentation........................................................................................................................12
Neoview Customer Library.............................................................................................................13
Publishing History................................................................................................................................14
HP Encourages Your Comments..........................................................................................................14
1 Introduction...................................................................................................................15
Repository Features and Interfaces.......................................................................................................15
2 Getting Started with Repository..................................................................................17
Installation............................................................................................................................................17
Character Set Support in Repository Views.........................................................................................17
Obtaining Prepackaged Queries...........................................................................................................17
Starting the Repository.........................................................................................................................17
Configuring Retention Times for Data.................................................................................................17
3 Repository Views..........................................................................................................19
Overview...............................................................................................................................................19
Query Statistics.....................................................................................................................................19
VIEW NEO.HP_METRICS.QUERY_STATS_VW2..........................................................................19
VIEW NEO.HP_METRICS.SQL_TEXT_VW1.................................................................................32
ODBC Session Data...............................................................................................................................33
VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V1...............................................................33
VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V2...............................................................36
Processing Node Statistics....................................................................................................................40
VIEW NEO.HP_METRICS.NODE_STATS_V1................................................................................40
Disk Statistics........................................................................................................................................42
VIEW NEO.HP_METRICS.DISK_STATS_V1..................................................................................42
EMS Events...........................................................................................................................................45
VIEW NEO.HP_METRICS.EVENTS_VW1.....................................................................................45
Space Management Views and Sample Query Views for Space Management....................................47
VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1...................................................47
VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1.................................50
Sample Query Views for Space Management.................................................................................54
SPACE_Q_CATALOG_SIZE_VW1............................................................................................54
SPACE_Q_DISK_FULL_VW1....................................................................................................55
SPACE_Q_NUM_GUARDIAN_FILES_VW1............................................................................55
SPACE_Q_OBJECT_GROWTH_VW1........................................................................................55
SPACE_Q_PARTITION_FULL_VW1.........................................................................................56
SPACE_Q_SYSTEM_DETAILS_VW1.........................................................................................56
SPACE_Q_SYSTEM_TOTAL_SIZE_VW1..................................................................................56
SPACE_Q_TABLES_BY_SCHEMA_VW1..................................................................................56
Table of Contents 3