Hp Neoview Release 2.4 Software Manuel d'utilisateur Page 4
- Page / 128
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
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
- HP Part Number: 621366-001 1
- Published: May 2010 1
- Table of Contents 3
- 4 Table of Contents 4
- Table of Contents 5 5
- List of Figures 6
- List of Tables 7
- List of Examples 8
- About This Document 9
- Notation Conventions 10
- Notation Conventions 11 11
- Related Documentation 12
- • Connectivity 13
- • Reference 13
- Publishing History 14
- HP Encourages Your Comments 14
- 1 Introduction 15
- 16 Introduction 16
- Installation 17
- Obtaining Prepackaged Queries 17
- Starting the Repository 17
- 3 Repository Views 19
- ODBC Session Data 33
- Processing Node Statistics 38
- Process Statistics 40
- Table Statistics 47
- Disk Statistics 50
- EMS Events 53
- Management 55
- SPACE_Q_CATALOG_SIZE_VW1 62
- SPACE_Q_DISK_FULL_VW1 62
- SPACE_Q_OBJECT_GROWTH_VW1 63
- SPACE_Q_PARTITION_FULL_VW1 63
- SPACE_Q_SYSTEM_DETAILS_VW1 63
- SPACE_Q_SYSTEM_TOTAL_SIZE_VW1 63
- SPACE_Q_TABLES_BY_SCHEMA_VW1 64
- SPACE_Q_TABLE_FULL_VW1 64
- SPACE_Q_TABLE_SIZE_VW1 64
- SPACE_Q_TOP_10_TABLE_SIZE_VW1 65
- Overview 67
- 0030'; 72
- Sample Query Result 82
- Releases of the Repository 83
- Query Statistics for R2.4 SP1 85
- New Fields in QUERY_STATS_VW1 117
- New Fields in SQL_TEXT_VW1 117
- New Space Management Views 117
- Glossary 125
Produits connexes et manuels pour Logiciel Hp Neoview Release 2.4 Software
(194 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.064 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels