Neoview Repository User Guide (R2.4 SP1)

4 Examples and Guidelines for Creating Repository Queries....................................75
Overview...............................................................................................................................................75
Get the Number of Rows in a View......................................................................................................75
Retrieve a Specified Number of Rows from a View.............................................................................75
Retrieve Statistics for Completed Queries............................................................................................75
Retrieve Statistics for Incomplete Queries............................................................................................79
List Statement Counts for a Selected Time Period................................................................................82
Count Completed Queries, According to Specified Criteria................................................................82
Completed Queries Executed on a System in the Last 24 Hours....................................................83
Completed Queries Executed on a System in the Previous Two Days...........................................83
Queries within the Past 24 Hours, Grouped by Client Name.........................................................83
Queries within the Past 24 Hours, Grouped by Data Source..........................................................84
Queries within the Past 24 Hours, Grouped by Client Name and Including Average and
Maximum Elapsed Time.................................................................................................................84
Formatting Techniques to Enhance Readability of Query Output.......................................................84
Retrieving UCS2 Columns From a Workstation Configured for ISO8859-1........................................86
A Sample Queries for Event Information.......................................................................87
Sample Query Result............................................................................................................................96
B Pre-R2.4 SP1 Query Statistics Views..........................................................................99
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1.......................................................................99
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2.....................................................................102
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1..............................................................105
C History of Changes for Repository..........................................................................115
Summary of Field Definition Changes for Repository 2.2..................................................................115
Summary of Field Definition Changes for Repository 2.3..................................................................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
Glossary.........................................................................................................................121
Index...............................................................................................................................123
4 Table of Contents