README for HP Neoview Release 2.4 Service Pack 2

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.4 SP2 introduces these new and changed error messages, which are not yet documented
in the Neoview Messages Manual.
NOTE: SQL message 11005 is no longer a dial-out message. The event target for that message
is now DBADMIN.
SQL Messages
SQL 1299
1299 You cannot specify some columns with just the name and others with
name & data attributes.
Cause In the CREATE TABLE statement, one or more of the column definitions specify only
the column name and not the data type.
Effect The CREATE TABLE statement fails to create a table.
Recovery Fix the column definitions in the CREATE TABLE statement and retry the statement.
For the syntax of the CREATE TABLE statement, see the Neoview SQL Reference Manual.
SQL 1596
1596 Recalibration of the internal sequence generator failed. Please
see additional messages for details.
Cause The recalibration of the CURRENT_VALUE column in the internal sequence generator
table failed.
Effect The statement fails to execute.
Recovery Review the additional messages provided with this error for the internal UPDATE
statement failure. The additional messages will help you determine why the update to the
CURRENT_VALUE column failed.
SQL 1597
1597 The maximum of the IDENTITY column, column-name, for the table,
table-name, could not be obtained.
column-name
is the name of the IDENTITY column.
table-name
is the name of the table that contains the IDENTITY column.
Cause The maximum value of the IDENTITY column could not be obtained from the table.
Effect The statement fails to execute.
Recovery Resubmit the statement. If resubmitting the statement fails, manually obtain the
maximum value of the IDENTITY column. Increment this value by using the value of the
INCREMENT BY internal-sequence-generator option of the IDENTITY column. If the IDENTITY
New Features in Release 2.4 SP2 17