Neoview Repository User Guide (R2.4 SP1)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.4 Software

Table of Contents

About This Document.........................................................................................................9

Supported Release Version Updates (RVUs)..........................................................................................9

Intended Audience.................................................................................................................................9

New and Changed Information in This Edition.....................................................................................9

New and Changed Information in Previous Editions..........................................................................10

Document Organization.......................................................................................................................10

Notation Conventions...........................................................................................................................11

General Syntax Notation.................................................................................................................11

Related Documentation........................................................................................................................13

Neoview Customer Library.............................................................................................................13

Publishing History................................................................................................................................15

HP Encourages Your Comments..........................................................................................................15

1 Introduction...................................................................................................................17

Repository Features and Interfaces.......................................................................................................17

2 Getting Started with Repository..................................................................................19

Installation............................................................................................................................................19

Character Set Support in Repository Views.........................................................................................19

Obtaining Prepackaged Queries...........................................................................................................19

Starting the Repository.........................................................................................................................19

Configuring Retention Times for Data.................................................................................................20

3 Repository Views..........................................................................................................21

Overview...............................................................................................................................................21

Query Statistics.....................................................................................................................................22

VIEW NEO.HP_METRICS.QUERY_STATS_VW1..........................................................................22

VIEW NEO.HP_METRICS.SQL_TEXT_VW1.................................................................................34

Query Statistics for Release 2.4........................................................................................................35

VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1_2400...................................................36

VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400...................................................39

VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400............................................42

ODBC Session Data...............................................................................................................................50

VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V1...............................................................50

VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V2...............................................................53

Processing Node Statistics....................................................................................................................56

VIEW NEO.HP_METRICS.NODE_STATS_V1................................................................................56

Process Statistics...................................................................................................................................58

VIEW NEO.HP_METRICS.PROCESS_STATS_V1..........................................................................58

VIEW NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1..............................................61

Table Statistics.......................................................................................................................................65

VIEW NEO.HP_METRICS.TABLE_STATS_V2 and VIEW

NEO.HP_METRICS.TABLE_STATS_DETAIL_V2...........................................................................66

Disk Statistics........................................................................................................................................68

VIEW NEO.HP_METRICS.DISK_STATS_V1..................................................................................68

EMS Events...........................................................................................................................................71

VIEW NEO.HP_METRICS.EVENTS_VW1.....................................................................................71

Table of Contents 3