README for HP Neoview Release 2.5 (R2.5)

in parallel script files. PRUN now includes those commands in its total count of operations,

errors, warnings, and successes.

There are several NCI commands that you can run after you disconnect from the Neoview

platform. For more information, see the Neoview Command Interface (NCI) Guide.

Neoview ODBC Drivers

Release 2.5 includes these enhancements for ODBC drivers:

• “Unicode Support” (page 20)

• “Network I/O Compression” (page 20)

Unicode Support

ODBC drivers are now Unicode drivers and accept Unicode functions (with a suffix of W) and

Unicode data. The Neoview Unicode driver allows an application to provide and retrieve Unicode

data using an ODBC interface for access to the Neoview database. The driver translates as

necessary between the client character set (locale) and the character encoding in the database.

For more information, see the Neoview ODBC Drivers Manual.

Network I/O Compression

Beginning with Release 2.5, you can configure optional network I/O compression for connecting

with Neoview system running Release 2.5 or later. This feature is disabled by default.

NOTE: HP recommends that you do not enable network I/O compression when connecting

with a Neoview system running Release 2.4 or earlier. Undefined behavior can result.

To enable network I/O compression:

• For UNIX-type systems, set compression = 1 in the MXODSN or odbc.ini file.

• For Windows systems, set compression = 1 in the network configuration tab of the ODBC

DataSource Administrator.

To disable network I/O compression, set compression = 0 or SYSTEM_DEFAULT.

Neoview Workload Management Services (WMS)

Query Statistics Aggregation

In Release 2.5, you now have the option of enabling query statistics aggregation for repetitive,

short-running queries. Repetitive, short-running queries are INSERT, UPDATE, DELETE, and

SELECT statements that are prepared once and executed many times. The queries in many load

jobs and in some reports behave in this manner—they are prepared once and executed repeatedly.

Without query statistics aggregation, the execution of repetitive, short-running queries can

overload system resources and inundate the Neoview Repository with unnecessary records. In

Release 2.5, the aggregation of query statistics improves system performance and reduces the

number of Repository records, enabling you to use the Repository data more effectively.

Benefits of Query Statistics Aggregation

When enabled, query statistics aggregation:

• Improves system performance by reducing the overhead for repetitive, short-running queries.

• Reduces the number of records in the Repository, causing reports to run more quickly and

making it easier for you to analyze historical data. Fewer records also allow more historical

data to be stored in the Repository.

• Provides visibility for unique queries (that is, queries that access only one row of data) in

WMS, allowing you to track those queries' progress in real time.