README for HP Neoview Release 2.4 Service Pack 2

Mature Products in Release 2.4 SP2
These products are classified as mature in Release 2.4 SP2:
• HP Neoview DB Admin
• HP Neoview Management Dashboard Client
• HP Neoview Reports Client
• HP Neoview System Monitor
Now that those products are mature, HP will no longer accept requests for enhancements of
those products but will fix critical defects.
You are encouraged to download and start using the HP Database Manager (HPDM) as your
primary database management tool. HPDM offers many of the same capabilities as Neoview DB
Admin and the other mature products. For more information about HPDM, see the HP Database
Manager (HPDM) User Guide. To install HPDM, use the “HP Neoview Windows Client Package”
(page 10), or see the README for the HP Database Manager (HPDM).
New Features in Release 2.4 SP2
Release 2.4 SP2 introduces new features and enhancements to the Neoview software. Some
highlights of the new features and enhancements include:
For more information, see the ...New Feature or Enhancement
“Neoview SQL Database”
(page 8)
• Neoview SQL enhancements that include:
— Performance enhancements
— Limiting CPU time and memory for a query
— Obtaining EXPLAIN plans while queries are running
— Recalibrating internal sequence generators
— Loading data into an existing table
“Neoview Client Software
Installation” (page 10)
• An easy-to-use interface called the HP Neoview Windows Client Package for
downloading and installing Windows client products
“Neoview JDBC and ODBC
Drivers” (page 11)
• Drivers that return VARCHAR instead of LONGVARCHAR
“Neoview Transporter ”
(page 11)
• Neoview Transporter enhancements that include:
— A new Control File Generator option for specifying data files of your choice
in the sources section of a control file
— A new compression feature that improves load performance for staging
table loads and nonaudited loads
— Multi-session side-tree inserts for staging table loads and nonaudited loads
— Support of nulls in scalar expressions
“Neoview Performance Analysis
Tools (NPAT)” (page 14)
• Neoview Performance Analysis Tools (NPAT) enhancements for managing
Neoview Workload Management Services (WMS) that include:
— Allowing more users to become administrators
— Immediately stopping all queries in a service
“HP Database Manager
(HPDM)” (page 16)
• A Space Management area in HPDM for monitoring and displaying SQL
space-related data for the Neoview platform
• Ability to specify a default client port number for the Neoview system monitor
“Neoview Repository” (page 17)• New columns in the QUERY_STATS_VW1 and SQL_TEXT_VW1 views
• New Repository views and sample queries for space management
“Messages” (page 17)• New and improved error messages
The next pages provide more information about those features and enhancements.
Mature Products in Release 2.4 SP2 7