README for HP Neoview Release 2.4 Service Pack 2 HP Part Number: 601726-002 Published: March 2010 Edition: HP Neoview Release 2.
© Copyright 2010 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 Where to Download Client Software......................................................................................................5 Where to Find Documentation...............................................................................................................5 Mature Products in Release 2.4 SP2.............................
Introduction This README describes the new features in Neoview Release 2.4 Service Pack 2 (SP2) of the HP Neoview Data Warehousing Platform for Business Intelligence. The README also mentions where to download client software and where to find documentation. Your HP representative can help you determine the release level of software currently installed on your Neoview platform.
Type of Information Title Updated for Release New Features 2.4 SP2? Covered? Reference: Neoview SQL Reference Manual (R2.4 SP2) Updated See “Recalibrating Internal Sequence Generators” (page 9) and “Loading Data Into an Existing Table With the LOAD IF EXISTS Option” (page 9). Installation of client products: README for the HP Neoview Windows Client Package (R2.4 SP2) New Single interface to download and install Windows client products. See “Neoview Client Software Installation” (page 10).
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.
Neoview SQL Database Release 2.4 SP2 introduces these new features and enhancements to the Neoview SQL database: • • • • • • “Performance Enhancements” (page 8) “Limiting CPU Time for a Query” (page 8) “Limiting Memory for a Query” (page 8) “Obtaining EXPLAIN Plans While Queries Are Running” (page 8) “Recalibrating Internal Sequence Generators” (page 9) “Loading Data Into an Existing Table With the LOAD IF EXISTS Option” (page 9) Performance Enhancements Release 2.
• EXPLAIN statement: EXPLAIN [OPTIONS {'f' | 'n' | 'e' | 'm'}] FOR QID qid The qid is a delimited identifier or regular identifier, which represents the query ID. This example shows the query ID, which contains lowercase characters, as a delimited identifier: QID "MXID01001011194212103659400053369000000085905admin00_2605_S1" • EXPLAIN function: SELECT * FROM TABLE(EXPLAIN(NULL, 'QID=qid')) The qid is a case-sensitive identifier, which represents the query ID.
error is returned, stating that data already exists in the table. With a user-defined transaction, newly added rows are rolled back if an error occurs. For more information, see the Neoview SQL Reference Manual for Release 2.4 SP2. Neoview Client Software Installation Release 2.4 SP2 introduces the HP Neoview Windows Client Package, which greatly simplifies the installation of the client software. Release 2.4 SP2 also includes enhancements to some of the client software products.
Client Software Enhancements for Release 2.4 SP2 These client software products have been updated to include new features and fixes: Client Product New Features or Enhancements HP Database Manager (HPDM) See the “HP Database Manager (HPDM)” (page 16). Neoview Command Interface (NCI) Fixes only Neoview Performance Analysis Tools See the “Neoview Performance Analysis Tools (NPAT)” (page 14). Neoview JDBC Type 4 Driver See the “Neoview JDBC and ODBC Drivers” (page 11).
New Control File Generator Option When the Control File Generator creates a control file, by default, it populates the sources section with a default data file named ./datafiles/nvt_datafile.dat. This example shows the default data file in the sources section of a control file: sources { ACCT_src file "./datafiles/nvt_datafile.dat", ACCT_tgt jdbc table NEO.USR.ACCT } The Control File Generator has a new optional argument, -srcfile, which allows you to specify the names of data files of your choice.
By default, compression is disabled. To enable compression, set this property in the nvt.properties file: rwrs-compression-enabled=true To enable compression for a specific load, use this new control file option: compression="true" NOTE: Compression applies only to staging table loads, where forcestaging=true in the control file, and nonaudited loads, where noaudit=true in the control file. Teamsize Option and Multi-Session Side-Tree Inserts Before Release 2.
maps { map1 from file1 to table1 ( col1 = field1, col2 = expression "NVL(CAST(:field2 AS INT), DEFAULT)", col3 = field3 ) } For more information about using expressions in the maps section, see the Neoview Transporter User Guide for Release 2.4. Neoview Performance Analysis Tools (NPAT) Release 2.4 SP2 introduces these new features in NPAT: • • • 14 The Neoview Performance Analyzer now allows users other than ROLE.DBA and super.
• When you stop a Neoview Workload Management Services (WMS) service in NPAT, you can now immediately stop all queries in the service by selecting the Stop Immediately check box: Selecting Stop Immediately cancels all executing queries in the service, instead of allowing the queries to finish executing. Waiting queries are rejected, and no new queries are allowed into the service. • NPAT displays Session Statistics for a query that you are monitoring.
HP Database Manager (HPDM) Release 2.4 SP2 introduces these new features in HPDM: • • “Space Management” (page 16) “Fixed Incoming Port Option” (page 16) NOTE: To connect to a Neoview platform, the HP Database Manager requires the HP Neoview ODBC Driver for Windows (HP ODBC 2.0 client driver for Windows). Download the HP Neoview ODBC Driver for Windows from the HP Software Depot site and install it before running the HP Database Manager.
Neoview Repository Release 2.4 SP2 introduces two new columns in these Neoview Repository views: • • QUERY_STATS_VW1 SQL_TEXT_VW1 The Space Management feature introduces these new Repository views: • SPACE_PARTITION_DETAIL_VW1 • SPACE_PARTITION_DETAIL_HISTORY_VW1 For more information about those new and changed views, see the Neoview Repository User Guide for Release 2.4 SP2. Messages Release 2.
column's default specification type is GENERATED BY DEFAULT, recalibrate the CURRENT_VALUE of the internal sequence generator by using this syntax: ALTER TABLE table-name ALTER COLUMN column-name RECALIBRATE TO value NO SELECT If the IDENTITY column's default specification type is GENERATED ALWAYS AS IDENTITY, recalibrate the CURRENT_VALUE of the internal sequence generator by using the ALTER TABLE ALTER COLUMN SET INCREMENT BY statement and manual calibration instructions.
• • The recalibration value must not be greater than the maximum value allowed for the data type of the IDENTITY column. If the statement does not contain the NO SELECT option, the recalibration value provided must be greater than the maximum value in the IDENTITY column. Effect The statement fails to execute. Recovery Correct the recalibration value and resubmit the statement. SQL 1600 1600 Unable to lock table, table-name, for the IDENTITY column, column-name, during recalibration.
Effect The query fails to compile. Recovery Rewrite your query to prevent that join from overflowing its memory to disk. Contact HP Support for assistance. SQL 9200 9200 UPDATE STATISTICS for table catalog-name.schema-name.table-name encountered an error (error-num) from statement-name. catalog-name is the name of the catalog for the table that was the subject of the UPDATE STATISTICS operation.
11003 encctlprops file open/access violation, file=file-name file-name Cause Effect is the encctlprops.txt file. The Neoview Transporter Client is unable to open the encctlprops.txt file. The Neoview Transporter Client stops processing the control file. Recovery Verify that the $NVTHOME/conf/security/encctlprops.txt file exists and that the security permissions are properly set. 11004 Property file open/access violation, file=file-name file-name Cause Effect is the ctlprops.txt file.
47079 Pipe pipename is found but no data is written to it before retries=num-retries * tenacity=tenacity-num-seconds. Data must be written to pipe before computed num-seconds seconds. Modify the retries and/or the tenacity value in the control file to make Neoview Transporter wait longer for data to be written pipename is the name of the pipe that you specified. num-retries is the number of retries that you specified. tenacity-num-seconds is the number of seconds that you specified for the tenacity.
