HP Neoview Release 2.5 Software - Manual (Page 4)

SPACE_Q_TABLE_FULL_VW1.................................................................................................57
SPACE_Q_TABLE_SIZE_VW1...................................................................................................57
SPACE_Q_TOP_10_CATEGORY_SIZE_VW1...........................................................................57
SPACE_Q_TOP_10_NON_PARTITION_DETAIL_VW1...........................................................57
SPACE_Q_TOP_10_PARTITION_DETAIL_VW1......................................................................58
SPACE_Q_TOP_10_SCHEMA_SIZE_VW1................................................................................58
SPACE_Q_TOP_10_TABLE_SIZE_VW1....................................................................................58
SPACE_Q_TOP_10_USER_SPACE_SIZE_VW1.........................................................................58
4 Examples and Guidelines for Creating Repository Queries....................................59
Overview...............................................................................................................................................59
Get the Number of Rows in a View......................................................................................................59
Retrieve a Specified Number of Rows from a View.............................................................................59
Retrieve Statistics for Completed Queries............................................................................................60
Retrieve Statistics for Incomplete Queries............................................................................................60
List Statement Counts for a Selected Time Period................................................................................61
Count Completed Queries, According to Specified Criteria................................................................62
Completed Queries Executed on a System in the Last 24 Hours....................................................62
Completed Queries Executed on a System in the Previous Two Days...........................................62
Queries within the Past 24 Hours, Grouped by Client Name.........................................................62
Queries within the Past 24 Hours, Grouped by Data Source..........................................................63
Queries within the Past 24 Hours, Grouped by Client Name and Including Average and
Maximum Elapsed Time.................................................................................................................63
Formatting Techniques to Enhance Readability of Query Output.......................................................63
Retrieving UCS2 Columns From a Workstation Configured for ISO8859-1........................................64
A Sample Queries for Event Information.......................................................................67
Sample Query Result............................................................................................................................72
B STATEMENT_TYPE Field...............................................................................................73
C Repository Views Disabled by Default.......................................................................75
Process Statistics...................................................................................................................................75
VIEW NEO.HP_METRICS.PROCESS_STATS_V1..........................................................................75
VIEW NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1..............................................78
Table Statistics.......................................................................................................................................82
VIEW NEO.HP_METRICS.TABLE_STATS_V2 and VIEW
NEO.HP_METRICS.TABLE_STATS_DETAIL_V2...........................................................................83
D History of New and Changed Information in Previous Releases of the
Repository.........................................................................................................................87
New and Changed Information in Previous Editions..........................................................................87
E Pre-R2.5 Query Statistics Views..................................................................................89
Query Statistics for R2.4 SP2.................................................................................................................89
VIEW NEO.HP_METRICS.QUERY_STATS_VW1..........................................................................89
Query Statistics for R2.4 SP1...............................................................................................................101
Query Statistics for Pre-R2.4 SP1........................................................................................................101
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1_2400......................................................102
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400......................................................105
4 Table of Contents