README for HP Neoview Release 2.4 HP Part Number: 531837-001 Published: April 2009 Edition: HP Neoview Release 2.
© Copyright 2009 Hewlett-Packard Development Company, L.P. Legal Notice Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
Table of Contents Introduction............................................................................................................................................5 Neoview System Time Changes.............................................................................................................5 Where to Download Client Software......................................................................................................5 Where to Find Documentation......................................
Introduction This README describes Release 2.4 of the HP Neoview Data Warehousing Platform for Business Intelligence. Your HP representative can help you determine the release level of software currently installed on your Neoview platform. In general, the Neoview platform supports clients on Windows XP Service Pack 2 and later releases of Windows XP. Windows Vista is supported on some, but not all, clients. For information about Windows Vista support, see the README for each client product.
Product Type README Title Updated for Release 2.4? Neoview Transporter README for the HP Neoview Transporter Java Client Yes README for the HP Neoview Transporter SAI API3 No 1 2 3 Previously published as the README for the HP Neoview Performance Analyzer. Previously published as the README for the HP Neoview ODBC UNIX Drivers. Discontinued at Release 2.4. New Features From Earlier Service Packs Release 2.4 includes the new features and fixes described in this document. Release 2.
Database These are the new database features: • • • • • • • • • • • • “Compiler and Executor Enhancements” (page 7) “Automatic Clustering of ON RECOMPUTE MVs” (page 7) “Automatic Query Retry” (page 8) “CONVERTOHEX Function” (page 9) “Enhancements to MERGE INTO” (page 9) “Extensions to MAINTAIN REORG” (page 9) “FORMAT Option” (page 9) “New UPDATE STATISTICS Automation CHG_AUTO_LIST Command” (page 9) “Parser-Syntax Error Enhancement” (page 9) “Schema Privileges in Release 2.
Automatic Query Retry Prior to Release 2.4, most of the errors raised during query execution were returned to the application. Many of these errors were transient errors that were related to locking, timeouts, resource limitations, and other issues. If retried, such errors would very likely succeed, but the retry responsibility belonged to the application. In Release 2.4, the Neoview platform automatically retries the operation if it encounters certain errors.
Delay is the delay in seconds before each retry. The default is 1. CONVERTOHEX Function The CONVERTTOHEX function is new for Release 2.4 and allows the display of a column's contents (or the value of an arbitrary expression) in hexadecimal. The function works for all Neoview SQL data types. CONVERTOHEX is particularly useful when a column contains foreign characters that your PC or terminal is not configured to display.
^ (25 characters from start if SQL statement) *** ERROR[8822] The statement was not prepared. Schema Privileges in Release 2.4 Schema privileges are enabled by default in Neoview Release 2.4. This means that the schema owner can use GRANT and REVOKE statements to modify these privileges for individual schemas. The Neoview SQL Reference Manual documents the use of the GRANT and REVOKE statements. Previously, schema privileges were disabled by default. Neoview platforms that are migrated to Release 2.
• Includes two new error messages: Message Description Indicates that a parameter had a value inconsistent 29183 22001 Invalid Parameter Value: CHAR|VARCHAR data should be either bytes with its data type. The message indicates whether the type is CHAR or VARCHAR. or String for column: paramNumber Indicates that the value NULL was not valid for the 29184 23000 NULL cannot be assigned to a NOT NULL column, parameter paramNumber column and identifies the parameter where the error occurred.
The Release 2.
For more information about these features, plus updated migration and driver compatibility information and new troubleshooting procedures, see the Neoview Character Sets Administrator's Guide. Neoview Command Interface (NCI) NCI provides these new commands for Release 2.4: Command Function ALIAS Allows you to map a string to any NCI or Neoview SQL command. DELAY Allows the NCI session to be placed into sleep mode for a specified interval.
• • Windows XP, 2003 Server HP-UX v11.23 and later (64-bit) JVM support is: • Sun JDK 1.5 or later (1.6 is strongly recommended) • 32 or 64 bit (64-bit is recommended) Support for the Transporter API The Transporter client now includes a set of APIs for deep integration with ETL tools. The API infrastructure is available as a platform-specific shared library object called libjnvt.so. It is intended for use only by ETL tools.
— — — — — — — — — — — — — — — — — ADD RULE EXEC Command ALTER RULE CONN Command ALTER RULE COMP Command ALTER RULE EXEC Command ALTER SERVICE COMP Command ALTER SERVICE EXEC Command ALTER WMS CONN Command ALTER WMS RESET STATS Command INFO RULE Command INFO RULE CONN Command INFO RULE COMP Command INFO RULE EXEC Command DELETE RULE Command INFO SERVICE COMP Command INFO SERVICE EXEC Command INFO WMS CONN Command HOLD Command, including: ◦ HOLD QUERIES SERVICE — RELEASE Command, including: ◦ RELEASE QUERI
and JDBC connection attributes or SET SERVICE command is ignored by the Release 2.4 NDCS server. An error is returned to the client application. • The ADD SERVICE command now uses the threshold values from the WMS system configuration if values are unspecified in the command. In Release 2.
— — — — — — — — — — — CMP_DOP CMP_TXN_NEEDED CMP_MANDATORY_X_PROD CMP_MISSING_STATS CMP_NUM_JOINS CMP_FULL_SCAN_ON_TABLE CMP_HIGH_DP2_MAX_BUF_USAGE CMP_ROWS_ACCESSED_FULL_SCAN CMP_DP2_ROWS_ACCESSED CMP_DP2_ROWS_USED WARN_LEVEL The SERVICE_INDEX and QUERY_INDEX columns no longer exist in Release 2.4.
