SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

What’s New in This Manual
HP NonStop SQL/MX Installation and Management Guide—523723-004
xix
Changes in the June 2005 Revision of the Manual
Section 3, Installing
NonStop SQL/MX
Clarified that InstallSqlmx does not currently
support user aliases of SUPER.SUPER in Using the
InstallSqlmx Script on page 3-23.
Updated the information about installing the DP2
fallback SPRs in Preinstallation Tasks on page 3-1.
Added Table 3-1, SQL/MX Releases and Their SPR
Equivalents in Installing NonStop SQL/MX on page 3-3
Clarified the need to use the migrate utility
immediately after installing SQL/MX Release 2.1 or
SQL/MX Release 2.0 and to create user catalogs and
schemas in the SQL/MX database when migrating
Stored Procedures in Java (SPJs) and SQL/MP aliases
in Installing NonStop SQL/MX on page 3-3.
Section 5, Planning
Database Security and
Recovery
Added Safeguard and SQL/MX File Security on
page 5-4.
Added Other Restrictions on Backup and Restore 2
Operations on page 5-34.
Section 6, Reviewing and
Setting System Defaults
Added information about
HIST_SECURITY_WARNINGS,
INTERACTIVE_ACCESS, POS_LOCATIONS and
POS_NUM_OF_PARTNS in New System Defaults for
Release 2.0 on page 6-3.
Added information about DDL_DEFAULT_LOCATIONS
in New System Default for Release 2.1 on page 6-6.
Section 7, Creating an
SQL/MX Database
Added Using DDL_DEFAULT_LOCATIONS to
Distribute Primary Range Partitions on page 7-17.
Added information about changing the attributes of a
default index with the MODIFY and ALTER TABLE
commands in Constraints Implemented With Indexes on
page 7-36.
Section 8, Querying
SQL/MX Metadata
Clarified that MXCI displays the version identifier R2.0
for both SQL/MX Release 2.0 and SQL/MX Release 2.1
in Displaying Version Numbers on page 8-62.
Section 10, Reorganizing
SQL/MX Tables and
Maintaining Data
Added information about the steps involved in splitting a
range partition and adding range partitions to a
hash-partitioned table in Using MODIFY to Manage
Range-Partitioned Tables and Indexes on page 10-14.