README for HP Neoview Release 2.5 HP Part Number: 613730-001 Published: July 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............................................................................................................................................7 Release Version Identifier Naming Convention for Hardware Platforms.............................................7 Where to Download Client Software......................................................................................................7 HP Neoview Windows Client Package........................................................
Connectivity Service Error Messages.........................................................................................25 JDBC Client Error Messages.......................................................................................................27 For More Information ..........................................................................................................................
List of Tables 1 2 3 4 5 6 7 NEO.HP_METRICS.BAR_JOB_STATUS_VW1 ............................................................................21 HP_METRICS.BAR_JOB_STATUS_VW2......................................................................................22 HP_METRICS.BAR_JOB_STATUS_VW3......................................................................................22 HP_METRICS.BAR_JOB_STATUS_VW4......................................................................................23 HP_METRICS.
Introduction This README describes the new features in Neoview Release 2.5 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.
This table lists applicable documentation, new and updated, for Release 2.5: Type of Information Title Updated for Release 2.5? New features README for HP Neoview Release 2.5 (this in this document) release: New See “New Features in Release 2.5” (page 10). Database Neoview Database Administrator's Guide management: Updated See “Neoview DB Admin” (page 21). HP Database Manager (HPDM) User Guide (and online help embedded within the product) Updated See “HP Database Manager (HPDM)” (page 17).
Products Removed From Release 2.5 These products are classified as mature and have been removed from Release 2.5: • • • • HP Neoview DBAdmin HP Neoview Management Dashboard Client HP Neoview Reports Client HP Neoview System Monitor 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.
New Features in Release 2.5 Release 2.5 introduces new features and enhancements to the Neoview software. Some highlights of the new features and enhancements include: New Feature or Enhancement For more information, see the ... • Neoview SQL enhancements that include: “Neoview SQL Database” (page 12).
New Feature or Enhancement For more information, see the ... • Neoview Command Interface (NCI) enhancements that include: “Neoview Command Interface (NCI)” (page 19).
— — HP Neoview Transporter Java Client HP Database Manager (HPDM) The package does not include this client software product: • HP Neoview ODBC Drivers for UNIX You must still download and install the ODBC Drivers for UNIX individually. For more information, see the README for the HP Neoview ODBC Drivers for UNIX. The Neoview Windows Client Package has an easy-to-use interface that allows you to install all of the drivers and tools by default or select the components that you want to install.
• by the REPLICATE command. These options include the rate of replication and progress monitoring by using the query ID. New information regarding the DISK POOL clause in the CREATE TABLE statement for Neoview systems having 2, 3, and 4 logical disk volumes per CPU. For more information, see the Neoview SQL Reference Manual.
NOTE: It is possible to log on to Neoview with a client from a release earlier than Release 2.5, but features such as role selection and industry-standard password encryption will not be available on those connections, and therefore any such connection presents a potential security risk. For more information about these issues and Neoview security in general, see the Neoview User Management and Security Administration Guide.
• • • • • • • • • Solaris for SPARC® Solaris for SPARC® 64-bit x86 Linux x86-64 Linux IA64 Linux HP-UX PA-RISC HP-UX PA-RISC 64-bit HP-UX IA-64 HP-UX IA-64 64-bit Logging On as a Database User To log in to the Neoview database, provide: • Your username. If you are a remotely authenticated database user—that is, if your credentials are stored in an external directory server such as an LDAP server—your username must match the name by which you are known on that server.
NOTE: The Neoview JDBC Type 4 driver no longer lets you change your password when you log on. If you are a locally authenticated database user, you can change your password using NCI or HPDM, as described in the Neoview User Management and Security Administration Guide. If you are a remotely authenticated database user, your password is managed on an external directory server; no Neoview client offers an interface for changing it.
1. 2. Checks the location specified by CertificateDir and CertificateFile to determine whether a certificate exists at that location. If the application did not specify a directory, the driver checks the user's home directory. If the application did not specify a filename, the driver assumes the name SYSTEM_NAME.cer, where SYSTEM_NAME consists of the first five characters of the Neoview platform name.
Data Source and Connectivity Management HPDM has a new area called Connectivity, which you can use to view Neoview Database Connectivity Service (NDCS) services, servers, data sources, and sessions. Users who have operator privileges can: • Create, update, and delete data sources • Start and stop data sources • Stop sessions • Start and stop NDCS services • Grant operator privileges (to allow other users to manage data sources).
This information can help you understand the operation of the query statistics aggregation feature, which can improve performance for repetitive, short-running queries. For more information, see “Query Statistics Aggregation” (page 20).
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.
Configuring Query Statistics Aggregation WMS introduces new aggregation parameters (in connection rules) that enable you to turn on and configure query statistics aggregation for your query workloads. For more information, see the Neoview Workload Management Services Guide. Graceful Cancellation of Queries WMS now returns a standard SQL error message, 8007, to the client application when an executing query is cancelled. The client application remains connected to the Neoview platform.
Table 1 NEO.HP_METRICS.BAR_JOB_STATUS_VW1 (continued) PASS_NUM INT UNSIGNED NO DEFAULT, NOT NULL, NOT DROPPABLE Online dump pass number Primary Key This is always 1. PLATFORM_NAME CHAR(64) NO DEFAULT Name of platform (composed of the first five characters of the system name). Example: ARC01 OVERALL_START_LCT_TS TIMESTAMP(6) NO DEFAULT Start time of the overall backup job run in LCT. START_UTC_TS TIMESTAMP(6) NO DEFAULT Start time of the online dump pass in UTC.
HP_METRICS.BAR_JOB_STATUS_VW4 Table 4 HP_METRICS.BAR_JOB_STATUS_VW4 Description: Returns aggregated data grouped by PASS_NUM and SEGMENT_ID. Columns Included: PASS_NUM SEGMENT_ID TOTAL_NUM_FILES_DUMPED TOTAL_NUM_FILES_NOT_DUMPED TOTAL_NUM_BYTES_DUMPED Views Used: NEO.HP_METRICS.BAR_JOB_STATUS_VW4 HP_METRICS.BAR_JOB_STATUS_VW5 Table 5 HP_METRICS.BAR_JOB_STATUS_VW5 Description: Returns RPO TS along with the set of NSFR TS (unique per SEGMENT_ID) per OVERALL_START_UTC_TS.
Table 6 HP_METRICS.OVERALL_BAR_JOB_STATUS_VW1 (continued) Field Name Data Type Description STATUS CHAR(64) NO DEFAULT Overall current status of backup job run; status of each segment affects the overall status. Example: If backup fails in one segment, STATUS is set to BACKUP_FAILED.
Stored Procedures for Managing BACKUP Jobs You can manage a backup operation using these: • • • “START_JOB_BACKUP Stored Procedure” (page 25) “STATUS_JOB_BACKUP Stored Procedure” (page 25) “STOP_JOB_BACKUP Stored Procedure” (page 25) START_JOB_BACKUP Stored Procedure The START_JOB_BACKUP stored procedure starts the overall backup operation asynchronously and: • • Determines the status of the currently executing backup operation. Ensures that the Neoview full backup job is in “manual-initiation” mode.
ODBC NativeError: 0 JDBC SQLSTATE:HY000 JDBC SQLCODE: 29153 Invalid authorization specification means that the user did not present a valid user name or password or that the user's account is locked or frozen. SQLSTATE:38001 SQLCODE: error-code Indicates that an error occurred during password processing or certificate management operations. The following table lists possible errors and what you can do about them.
Password encryption is required. Please check client version. Indicates that the Neoview platform requires password encryption, but the login request came from an ODBC or JDBC driver that does not encrypt passwords. Install a newer version of the ODBC or JDBC driver no older than version 2.93.
Error Code and Text Description and Recovery [29720] No HOME environment variables are The client was unable to identify the home directory. The home set on the system. directory is most often defined by the HOME environment variable. If that variable is not set on the workstation, the security client derives the directory name from the environment variables HOMEDRIVE and HOMEPATH. If those variables are not defined on the workstation, the driver derives the directory name from the Java property user.
