README for HP Neoview Release 2.5 (R2.5)

Configuring Query Statistics Aggregation
WMS introduces new aggregation parameters (in connection rules) that enable you to turn on
and configure query statistics aggregation for your query workloads. For more information, see
the Neoview Workload Management Services Guide.
Graceful Cancellation of Queries
WMS now returns a standard SQL error message, 8007, to the client application when an executing
query is cancelled. The client application remains connected to the Neoview platform. For more
information, see the Neoview Workload Management Services Guide.
Neoview Repository
The Neoview Repository is enhanced to add a new view for accessing query statistics:
QUERY_STATS_VW2. This view differs from QUERY_STATS_VW1 by the addition of 5 new
columns and changes to 6 existing column data types.
For more information about the Neoview Repository, see the Neoview Repository User Guide.
Neoview DB Admin
Neoview DB Admin has been removed from the Neoview platform. The Neoview Database
Administrators Guide has been updated to remove references to DB Admin and Dashboard and
information about Neoview data types. The most up-to-date information resides in the Neoview
SQL Reference Manual.
Detailed user ID and role information and management of multiple Neoview users has been
moved to the Neoview User Management and Security Administration Guide. Role and user ID
overview information has been retained. The remaining sections of the manual have been
extensively reorganized and more information about database management tools has been added.
Neoview RMDR
There are two new features for Neoview RMDR in Release 2.5:
• “Repository Views for BAR Job Status Data” (page 21)
• “Stored Procedures for Managing BACKUP Jobs” (page 25)
Repository Views for BAR Job Status Data
In Release 2.5, backup job status data is stored in two new repository tables. For each backup job
run, there is one row per pass (per segment), written to the BAR_JOB_STATUS table. Overall
data for each backup job run is stored in the OVERALL_BAR_JOB_STATUS table.
There are seven views to access the repository tables. Each of the seven views can be accessed
by role.dba.
HP_METRICS.BAR_JOB_STATUS_VW1
Table 1 NEO.HP_METRICS.BAR_JOB_STATUS_VW1
DescriptionData TypeField Name
Start time of the overall backup job run in
UTC..
Primary Key; Leading clustering key
TIMESTAMP(6) NO DEFAULT, NOT
NULL, NOT DROPPABLE
OVERALL_START_UTC_TS
Segment number
Primary Key
INT UNSIGNED NO DEFAULT, NOT
NULL, NOT DROPPABLE
SEGMENT_ID
New Features in Release 2.5 21