README for HP Neoview Release 2.4 Service Pack 1 HP Part Number: 588803-001 Published: September 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 Where to Download Client Software......................................................................................................5 Where to Find Documentation...............................................................................................................5 New Features for Release 2.4 SP1...............................
List of Tables 1 2 3 4 4 USTAT_AUTO_LIST View............................................................................................................11 USTAT_AUTO_LIST_DETAIL View.............................................................................................11 STATUS WMS Configuration Values............................................................................................16 STATUS WMS DETAIL Command Output.........................................................................
Introduction This README describes the new features in Neoview Release 2.4 Service Pack 1 (SP1) 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.
• • • “Neoview Repository” (page 14) “Neoview Workload Management Services (WMS)” (page 14) “Messages” (page 17) Some highlights of the new features and enhancements include: New Feature or Enhancement For more information, see the ...
Neoview SQL Database The current software release introduces these new features and enhancements to the Neoview SQL database: • • • • “Extended Support for Delimited Identifiers NEW!” (page 8) “ANSI Holdable Cursor Support NEW!” (page 8) “MAINTAIN OVERRIDE Option NEW!” (page 10) “Automated Update Statistics and Reorganize Operations” (page 10) Extended Support for Delimited Identifiers NEW! Neoview has extended support within Neoview SQL to include the forward slash (/) character.
NOTE: Holdable cursors are not currently supported for result sets that are returned by stored procedure calls. ANSI holdable cursors are supported by SELECT statements that use one of these transaction isolation levels: • READ UNCOMMITTED • READ COMMITTED ANSI holdable cursors are not supported by SELECT statements that use the SERIALIZABLE or REPEATABLE READ transaction isolation level.
retCode = SQLSetCursorName(hstmtC1, (SQLCHAR*) "C1", SQL_NTS); checkSQL_3_0("Set C1 cursor name ",SQL_HANDLE_STMT,hstmtC1,retCode); retCode = SQLSetStmtAttr(hstmtC1, (SQLINTEGER)SQL_ATTR_CURSOR_HOLDABLE, (SQLPOINTER)SQL_HOLDABLE, SQL_IS_INTEGER); checkSQL_3_0("Set C1 holdable ",SQL_HANDLE_STMT,hstmt,retCode); To specify a non-holdable cursor in an ODBC client application, use SQL_NONHOLDABLE instead of SQL_HOLDABLE. In Neoview SQL, the default is a non-holdable cursor.
Table 1 USTAT_AUTO_LIST View • Column Name Data Type Description SCH_NAME CHAR(25) Schema name. For a delimited schema name, the name is stored in internal format, which means that two successive double quotes are stored as only one double quote. TBL_NAME CHAR(25) Table name. For a delimited table name, the name is stored in internal format, which means that two successive double quotes are stored as only one double quote. LAST_RUN CHAR(11) Time of last UPDATE STATISTICS run.
do not specify MAXREORGSLICE, the default percentage value for REORG is 50%. Neoview Security The current software release introduces two new database views for monitoring and logging user-management actions, such as: • • • Adding or deleting users Granting or revoking roles Setting or changing passwords By default, if you are ROLE.MGR or the super.services ID (HP Support), you can use these views to monitor user-management actions taken by ROLE.MGR or by other users (in the case of a password change).
To install the Neoview Transporter Java Client, see the README for the HP Neoview Transporter Java Client for Release 2.4 SP1. Neoview Performance Analysis Tools The current software release introduces these new features in the Neoview Performance Analysis Tools: • • A new field, QUERY_TEXT, is included in Live View. This field shows the SQL text. A point-and-click interface for configuring Workload Management Services (WMS) services and rules. If you are an administrator (ROLE.DBA, super.
The System Offender tab helps users identify the sources of runaway queries and offers tools for gathering workload information. Users can display workload detail, process detail, and children processes for a selected process. Only administrators (ROLE.DBA, super.services, and super.super by default) can alter System Offender parameters, display Pstate information, use the Pstate command, and cancel queries, but non-administrator users can use all other System Offender features.
[WMS]Programming exception: ComExecDirect, Service service-name is outside the active time • The STATUS QUERIES ALL STATS and STATUS QUERY STATS commands now display an “SQL_” prefix before these statement types in the STATEMENT_TYPE column: — SQL_OTHER — SQL_UNKNOWN — SQL_SELECT_UNIQUE — SQL_SELECT_NON_UNIQUE — SQL_INSERT_UNIQUE — SQL_INSERT_NON_UNIQUE — SQL_UPDATE_UNIQUE — SQL_UPDATE_NON_UNIQUE — SQL_DELETE_UNIQUE — SQL_DELETE_NON_UNIQUE — SQL_CONTROL — SQL_SET_TRANSACTION — SQL_SET_CATALOG —
Table 3 STATUS WMS Configuration Values Column Name Data Type Description STATE VARCHAR(9) State of WMS: INIT (for initialization), ACTIVE, HOLD, STOPPING, STOPPED, or STOP MAX_CPU_BUSY INT Maximum CPU busy allowed. Zero (0) means no limit. MAX_MEM_USAGE INT Maximum memory usage allowed. Zero (0) means no limit. MAX_ROWS_FETCHED LARGEINT Maximum number of rows that can be returned.
Table 4 STATUS WMS DETAIL Command Output Column Name Data Type Description SEGMENT INT Segment number NODE INT Node number CPU_BUSY FLOAT Current CPU busy MEM_USAGE FLOAT Current memory usage Example This command displays information about CPU and memory consumption per segment and per node: NS%status wms detail; SEGMENT NODE CPU_BUSY MEM_USAGE ----------- ----------- ------------------------ -----------------------1 0 100.0 66.0 1 1 100.0 62.0 1 2 100.0 71.0 1 3 100.0 64.0 2 0 0.
SQL 8013 You are trying to update or delete from a cursor that is not in the fetched state. Cause Effect You are updating or deleting from a cursor that is not in the fetched state. The operation fails. Recovery Do not attempt recovery. HP Support must perform recovery operations in response to an automatically generated dial-out message about this condition. SQL 8839 Transaction was aborted. Cause The Neoview engine aborted the transaction.
51018 Exception encountered while reading template file: template-file exception Cause An error occurred while reading the template file. Neoview Transporter might not have permission to access the template file. Effect The Control File Generator terminates. Recovery Check the template file, and rerun the Control File Generator. If the problem persists, contact HP Support and report this condition.
Recovery Specify the name of a service other than one of the predefined system services, and then retry the command. [WMS]Programming exception: ComExecDirect, Rule name cannot contain blank(s) Cause Effect The name of the rule contains one or more blank spaces. The ADD RULE command fails to create the rule. Recovery Remove the blank spaces in the rule name, and then retry the ADD RULE command.
