Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's ReferenceThe HCL OneDB™ Administrator's Reference includes comprehensive descriptions of HCL OneDB™ configuration parameters, the system-monitoring interface (SMI) tables in the sysmaster database, the syntax of database server utilities such as onmode and onstat, logical-log records, disk structures, event alarms, and unnumbered error messages.
Configuring and monitoring HCL OneDB™
Database configuration parametersThe HCL OneDB™ database server uses a configuration file, which is called the onconfig file, during initialization. This file contains default configuration parameter values. You can modify the parameter values to improve performance and other characteristics of the instance or database.
DISABLE_B162428_XA_FIX configuration parameterUse the DISABLE_B162428_XA_FIX configuration parameter to specify when transactions are freed.

DISABLE_B162428_XA_FIX configuration parameter

Use the DISABLE_B162428_XA_FIX configuration parameter to specify when transactions are freed.

onconfig.std value: Not in the onconfig.std file.
values: 0 = (Default) Frees transactions only when an xa_rollback is called.
1 = Frees transactions if transaction rollback for other than an xa_rollback.
units: Integer
takes effect: After you edit your onconfig file and restart the database server.

Usage

Set DISABLE_B162428_XA_FIX to 1 to immediately free all global transactions after a transaction rollback, which is the default for HCL OneDB™ 9.40 and earlier versions. The default behavior for HCL OneDB 10.0 is to free global transactions after an xa_rollback is called, and this behavior is required to confirm to the XA state table that a transaction can be freed only after xa_rollback is called. Setting DISABLE_B162428_XA_FIX to 1 ensures that applications written for the earlier version of HCL OneDB work properly.

You can override the DISABLE_B162428_XA_FIX configuration parameter for a client session with the IFX_XASTDCOMPLIANCE_XAEND environment variable. Setting IFX_XASTDCOMPLIANCE_XAEND to 1 will free transactions only when an xa_rollback is called. Setting IFX_XASTDCOMPLIANCE_XAEND to 0 will free transactions if the transaction rollback is for other than an xa_rollback.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.