HP Neoview Release 2.3 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.............................................................................................................12
Publishing History................................................................................................................................13
HP Encourages Your Comments..........................................................................................................13
1 Introduction...................................................................................................................15
Repository Features and Interfaces.......................................................................................................15
2 Getting Started with Repository 2.3...........................................................................17
Installation............................................................................................................................................17
Character Set Support in Repository Views.........................................................................................17
Adapting Existing Queries to a New Repository Version....................................................................17
Obtaining Repository Documentation and Prepackaged Queries.......................................................18
Enabling Capture of Session Data........................................................................................................18
Starting the Repository.........................................................................................................................19
Configuring Retention Times for Data.................................................................................................19
3 Repository Views..........................................................................................................21
Overview...............................................................................................................................................21
Query Statistics.....................................................................................................................................21
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1.................................................................22
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2.................................................................25
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1...........................................................27
ODBC Session Data...............................................................................................................................35
VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V1...............................................................35
VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V2...............................................................38
Processing Node Statistics....................................................................................................................41
VIEW NEO.HP_METRICS.NODE_STATS_V1................................................................................41
Process Statistics...................................................................................................................................43
VIEW NEO.HP_METRICS.PROCESS_STATS_V1..........................................................................44
VIEW NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1..............................................46
Table Statistics.......................................................................................................................................52
VIEW NEO.HP_METRICS.TABLE_STATS_V2 and VIEW
NEO.HP_METRICS.TABLE_STATS_DETAIL_V2...........................................................................52
Disk Statistics........................................................................................................................................54
VIEW NEO.HP_METRICS.DISK_STATS_V1..................................................................................54
Summary of Field Definition Changes from Repository 2.1................................................................57
Summary of Field Definition Changes from Repository 2.2................................................................59
4 Examples and Guidelines for Creating Repository Queries....................................61
Overview...............................................................................................................................................61
Table of Contents 3