HP Neoview Release 2.4 Software - Manual (Page 4)

4 Examples and Guidelines for Creating Repository Queries....................................67
Overview...............................................................................................................................................67
Get the Number of Rows in a View......................................................................................................67
Retrieve a Specified Number of Rows from a View.............................................................................67
Retrieve Statistics for Completed Queries............................................................................................68
Retrieve Statistics for Incomplete Queries............................................................................................68
List Statement Counts for a Selected Time Period................................................................................68
Count Completed Queries, According to Specified Criteria................................................................69
Completed Queries Executed on a System in the Last 24 Hours....................................................69
Completed Queries Executed on a System in the Previous Two Days...........................................70
Queries within the Past 24 Hours, Grouped by Client Name.........................................................70
Queries within the Past 24 Hours, Grouped by Data Source..........................................................70
Queries within the Past 24 Hours, Grouped by Client Name and Including Average and
Maximum Elapsed Time.................................................................................................................71
Formatting Techniques to Enhance Readability of Query Output.......................................................71
Retrieving UCS2 Columns From a Workstation Configured for ISO8859-1........................................72
A Sample Queries for Event Information.......................................................................73
Sample Query Result............................................................................................................................82
B History of New and Changed Information in Previous Releases of the
Repository.........................................................................................................................83
New and Changed Information in Previous Editions..........................................................................83
C Pre-R2.4 SP2 Query Statistics Views.........................................................................85
Query Statistics for R2.4 SP1.................................................................................................................85
Query Statistics for Pre-R2.4 SP1..........................................................................................................85
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1_2400..............................................................86
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400..............................................................89
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400.......................................................92
Query Statistics for Release 2.4 ..........................................................................................................100
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1.....................................................................101
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2.....................................................................104
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1..............................................................106
D History of Field Changes for Repository.................................................................117
Summary of Changes for Repository 2.4 SP2.....................................................................................117
New Fields in QUERY_STATS_VW1 ............................................................................................117
New Fields in SQL_TEXT_VW1....................................................................................................117
New Space Management Views....................................................................................................117
Summary of Changes For Repository 2.4 SP1....................................................................................118
New Repository View For Accessing Error Event Information....................................................118
Repository View Changes For Easy Access to Query Statistics....................................................118
USER_NAME Field Increased to 128 Characters..........................................................................119
Summary of Changes for Repository 2.4............................................................................................119
Summary of Field Definition Changes for Repository 2.3..................................................................119
Summary of Field Definition Changes for Repository 2.2..................................................................121
Glossary.........................................................................................................................125
4 Table of Contents