H06.13 Release Version Update Compendium

Option to Suppress Automatic Transaction Starting
Currently, NonStop SQL/MX will automatically start a transaction if the transaction is not started
by the application. A new SET TRANSACTION option is provided that suppresses this automatic
starting of a transaction. The new option is SET TRANSACTION AUTOBEGIN OFF.
SQL/MP
New DEFINES
• The DEFINE for COMMIT WORK AUDITONLY behavior, if set, releases locks on audited
objects and hold locks on non-audited objects. If the DEFINE is not set, locks acquired inside
a transaction for parallel plans, or locks acquired outside a transaction regardless of plan
type, are not released for audited objects. For non-audited objects there is no behavior change.
• The DEFINE for index inconsistency detection, if set, identifies a mismatch in the record
count when the index has more records than the table. If the DEFINE is not set, the mismatch
will not be detected.
TMF
Automatically Increase Transaction Threshold
The TransCountThresh attribute controls the number of active transactions in a system. When
the TransCountThresh limit is reached, TMF disables new transactions. In the H06.13 RVU,
new options are added to the TMF TMFCOM Alter BeginTrans command to enable you to
direct TMF to automatically increase the value of the TransCountThresh attribute. The new
options are:
Selects the option to automatically increase the value of the TransCountThresh
attribute
ThreshAutoIncrease
Specifies the limit at which the system will generate EMS messages when the
number of transactions approaches TransCountThresh
ThreshLowerLimit
Specifies the amount by which the TransCountThresh attribute is automatically
increased
ThreshIncrAmount
Specifies the number of times the threshold can be automatically increased
ThreshNumberOfIncr
OSS ODBC/MX Client Driver
The OSS ODBC/MX Client Driver enables applications developed for the OSS Open Database
Connectivity (ODBC) application programming interface (API) to access the SQL database on a
NonStop server through NonStop SQL/MX Connectivity Services (MXCS).
The OSS ODBC Client Driver supports:
• All ODBC/MX CLI calls on the NonStop operating system.
• Multiple concurrent connections.
• Data source configuration for OSS ODBC/MX Client Driver.
• Bulk operations.
• The interface between ODBC driver manager and the OSS ODBC/MX Client Driver through
a group of supported APIs.
16 Database and Transaction Processing Products