HP Neoview Release 2.5 Software - Manual (Page 9)

About This Document
This document describes the views supported by the Neoview Manageability Repository, a
Neoview SQL database and set of programs that collect and store statistics and other information
about queries, query sessions, tables, disks, processing nodes, and (optionally) selected processes
involved in query execution on a Neoview platform.
Supported Release Version Updates (RVUs)
This manual supports Neoview Release 2.5 and subsequent Neoview releases until otherwise
indicated in a replacement publication.
Intended Audience
This document is intended for Neoview platform administrators, database administrators, and
other users interested in evaluating query performance and resource utilization on a Neoview
platform. Familiarity with Neoview SQL is a prerequisite.
New and Changed Information in This Edition
• Added a new view for accessing query statistics: QUERY_STATS_VW2. This view differs
from QUERY_STATS_VW1 by the addition of 5 new fields for WMS query aggregation and
changes to 8 existing field data types. See
“VIEW NEO.HP_METRICS.QUERY_STATS_VW2”
(page 19) . The new fields:
— QAG_OPTION
— QAG_TOTAL
— CONN_RULE
— COMP_RULE
— EXEC_RULE
The fields with data type changes:
— SQL_MEMORY_SPACE_ALLOCATED
— SQL_MEMORY_SPACE_USED
— SQL_MEMORY_HEAP_ALLOCATED
— SQL_MEMORY_HEAP_USED
— EXECUTOR_IN_DISK_MEMORY_SPACE_ALLOCATED
— EXECUTOR_IN_DISK_MEMORY_SPACE_USED
— EXECUTOR_IN_DISK_MEMORY_HEAP_ALLOCATED
— EXECUTOR_IN_DISK_MEMORY_HEAP_USED
• Increased the retention times for the following views:
— Processing node statistics
— Session data
— ODBC/JDBC Query compilation and execution statistics
— Table statistics
— Disk statistics
See
Section : “Configuring Retention Times for Data” (page 17)
• Added 3 columns to ODBC_SESSION_STATS_V1 and ODBC_SESSION_STATS_V2:
— TOTAL_LOGIN_ELAPSED_TIME_MCSEC
— LDAP_LOGIN_ELAPSED_TIME_MCSEC
— CLIENT_USER_NAME
Supported Release Version Updates (RVUs) 9