H06.19 Release Version Update Compendium

4 Database and Transaction Processing Products
NonStop SOAP 3.0
NonStop SOAP now supports context-free SOAP messages of up to 2 MB in size.
Migration Considerations
None.
Fallback Considerations
None.
SQL/MX 2.3.3
The NonStop SQL/MX 2.3.3 release includes the following new features:
• Large block support:
This feature enables you to create objects of block size 32768 bytes (32 KB).
• Check constraint-based query pruning:
This feature enables you to eliminate unwanted table scans when a predicate on that table
violates the check constraints defined on the table. This feature enhances query performance
by reducing compilation and execution time. This feature is applicable for timestamp and
numeric columns.
• Fastcopy:
The fastcopy operation enables you to copy data between the existing source and target
table, optionally with concurrent copying of associated indexes. It involves the execution of
one or more FASTCOPY commands. The FASTCOPY utility is a syntax-based utility that
can be executed from MXCI, and from management applications using dynamic SQL. The
FASTCOPY utility includes the following commands:
— FASTCOPY TABLE command - copies all rows from one table to an existing equivalent
table.
— FASTCOPY INDEX command - copies all rows from one index into an existing equivalent
index.
• MultiUnion:
This feature provides enhanced functionality to handle queries which have large number
of table unions. This feature compresses the binary union backbone in such queries into a
single n-way “MultiUnion” operator, there by reducing query execution and compilation
time.
• Union transitive predicates:
This feature extends the existing ability of the SQL/MX compiler to perform a transitive
closure on predicates to include predicates defined on Unions or MultiUnions.
• The BRCOM syntax supports new keywords INDEX in the sqlmx-object-type and IPART
in the sqlmx-part by modifying the sqlmx-object-spec for both BACKUP and RESTORE
commands, such that one or more index name with keyword INDEX can be specified in the
BACKUP or RESTORE command and not together with any other sqlmx-object-type or
sqlmx-backup-object-spec or sqlmx-restore-object-spec.
• The BRCOM syntax supports a new backup job option called BRICONFRESHTAPE. It is
intended primarily for setups involving the Virtual Tape Server (VTS). It can use either of
the parameters: ON or OFF.
NonStop SOAP 3.0 17