SQL/MX 2.x Installation and Management Guide (H06.04+)

What’s New in This Manual
HP NonStop SQL/MX Installation and Management Guide—540436-001
xx
New and Changed Information
Section 12, Performing
Recovery Operations
Added prohibitions against recovering SQL/MX files to
new locations under Recovering Files to New Locations
on page 12-4.
Added information about recovering disabled triggers
from dropped tables under Table Recovery Procedures
on page 12-9 and Tables With Triggers on page 12-13.
Added guidelines for managing the security information
contained in DDL files for the DELETE and INSERT
statements after table recovery under Example:
Recovering Table Privileges on page 12-11.
Added information about using FIXUP to correct
timestamps under Tables With Partitions on
page 12-13, Example: Recovering an Accidentally
Dropped Table on page 12-14, and the new subsection
Changing Catalog, Schema, and Object UIDs on
page 12-35.
Section 13, Managing an
SQL/MX Distributed
Database
Added information about using co-located indexes and
remote application processes under Enhancing the
Performance of a Distributed Database on page 13-23.
Added information about interoperability under
Managing Mixed Versions of NonStop SQL/MX on
page 13-25.
Section 14, Measuring
Performance
Throughout the section, added new information about
the Measure product.
Section 15, Enhancing
SQLMX Database
Performance
Added information about enhancements to the SQL/MX
Release 2.1.1 internal algorithm for generating
histogram UECs with UPDATE STATISTICS under
Creating More Accurate Histogram Tables With
UPDATE STATISTICS on page 15-8.
Added information about managing, troubleshooting,
and sizing the SLQ/MX buffer under Managing SQL/MX
Buffer Space on page 15-8.
Added information about sizing the DP2 data cache
under Managing DP2 Data Cache Memory Size on
page 15-14.
Clarified that the SEQUENTIAL BLOCKSPLIT option is
not supported by NonStop SQL/MX under Matching
Block Split Operation to Table Usage on page 15-20.