H06.08 Release Version Update Compendium

H06.08 Release Version Update Compendium—543560-001
4-1
4
Database and Transaction
Processing Products
SQL/MX
A new NonStop SQL/MX control query default (CQD) statement is introduced to enable
users to specify that transactions always be doomed by SQL/MX when an
unrecoverable error occurs. A new error message is introduced to indicate that the
transaction is doomed.
Set the CQD to ON for SQL/MX to doom transactions and for JDBC and ODBC to
handle the error or return the error to the application or user.
You must set the CQD to OFF by default. Ensure that the attributes have these
defaults:
•
DOOM_USERTRANSACTION is set to OFF.
The DOOM_USERTRANSACTION attribute controls whether NonStop SQL/MX
dooms a transaction when it encounters an unrecoverable error and the
transaction cannot be rolled back to a savepoint. When a transaction is doomed by
TMF, it is marked for abort and must be aborted explicitly. A new transaction is
started before the user can proceed. When DOOM_USERTRANSACTION is set to
ON and NonStop SQL/MX cannot roll back to a savepoint, the transaction is
doomed. When DOOM_USERTRANSACTION is set to OFF, NonStop SQL/MX:
°
dooms the transaction if it inherits the transaction from the user application or
from the JDBC or OCBC drivers.
°
aborts the transaction if it started the transaction.
If you set DOOM_USERTRANSACTION to ON, SQL/MX encounters an
unrecoverable error and displays this message:
8878 Transaction has been doomed. The user should explicitly
rollback the transaction before proceeding.
For more information, see the SQL 8878 error in the SQL/MX Messages Manual.
•
SORT_MAX_HEAP_SIZE_MB is set to 20.
Use the CQD command to set the SORT_MAX_HEAP_SIZE_MB attribute, which
allocates the default value to the heap memory size for the operations involving the
sort operator.
For more information, see the SQL/MX Reference Manual.