Software User guide

Table of Contents
About This Document.........................................................................................................7
Supported Release Version Updates (RVUs)..........................................................................................7
Intended Audience.................................................................................................................................7
New and Changed Information in This Edition.....................................................................................7
Document Organization.........................................................................................................................8
Notation Conventions.............................................................................................................................8
General Syntax Notation...................................................................................................................8
Related Documentation........................................................................................................................10
Neoview Customer Library.............................................................................................................10
Publishing History................................................................................................................................12
HP Encourages Your Comments..........................................................................................................12
1 Introduction...................................................................................................................13
Repository Features and Interfaces.......................................................................................................13
2 Getting Started with Repository..................................................................................17
Installation............................................................................................................................................17
Character Set Support in Repository Views.........................................................................................17
Obtaining Prepackaged Queries...........................................................................................................17
Enabling Capture of Session Data........................................................................................................17
Starting the Repository.........................................................................................................................18
Configuring Retention Times for Data.................................................................................................18
3 Repository Views..........................................................................................................21
Overview...............................................................................................................................................21
Query Statistics.....................................................................................................................................21
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1.................................................................22
Format of the Query ID Field.....................................................................................................25
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2.................................................................26
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1...........................................................29
ODBC Session Data...............................................................................................................................37
VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V1...............................................................37
VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V2...............................................................40
Processing Node Statistics....................................................................................................................43
VIEW NEO.HP_METRICS.NODE_STATS_V1................................................................................43
Process Statistics...................................................................................................................................45
VIEW NEO.HP_METRICS.PROCESS_STATS_V1..........................................................................46
VIEW NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1..............................................48
Table Statistics.......................................................................................................................................54
VIEW NEO.HP_METRICS.TABLE_STATS_V2 and VIEW
NEO.HP_METRICS.TABLE_STATS_DETAIL_V2...........................................................................54
Disk Statistics........................................................................................................................................56
VIEW NEO.HP_METRICS.DISK_STATS_V1..................................................................................56
Summary of Field Definition Changes from Repository 2.1................................................................59
Summary of Field Definition Changes from Repository 2.2................................................................62
4 Examples and Guidelines for Creating Repository Queries....................................65
Overview...............................................................................................................................................65
Table of Contents 3