HP Neoview Release 2.4 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.........................................................................................................................9
Notation Conventions...........................................................................................................................10
General Syntax Notation.................................................................................................................10
Related Documentation........................................................................................................................12
Neoview Customer Library.............................................................................................................12
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_VW1..........................................................................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....................................................................................................................38
VIEW NEO.HP_METRICS.NODE_STATS_V1................................................................................38
Process Statistics...................................................................................................................................40
VIEW NEO.HP_METRICS.PROCESS_STATS_V1..........................................................................40
VIEW NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1..............................................43
Table Statistics.......................................................................................................................................47
VIEW NEO.HP_METRICS.TABLE_STATS_V2 and VIEW
NEO.HP_METRICS.TABLE_STATS_DETAIL_V2...........................................................................48
Disk Statistics........................................................................................................................................50
VIEW NEO.HP_METRICS.DISK_STATS_V1..................................................................................50
EMS Events...........................................................................................................................................53
VIEW NEO.HP_METRICS.EVENTS_VW1.....................................................................................53
Space Management Views and Sample Query Views for Space Management....................................55
VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1...................................................55
VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1.................................58
Sample Query Views for Space Management.................................................................................62
Table of Contents 3