Kill a Distributed Transaction

Home | Previous Page | Next Page Administrative Utilities > Changing Modes and Shared Memory with the onmode Utility >

Kill a Distributed Transaction

Kill a Distributed Transaction:
 
|-- -Z--address-------------------------------------------------|

Element	Purpose	Key Considerations
-Z address	Kills a distributed transaction associated with the shared-memory address address	Restrictions: This argument must be the address of an ongoing distributed transaction that has exceeded the amount of time that TXTIMEOUT specifies. The address must conform to the operating-system-specific rules for addressing shared-memory. (The address is available from onstat -x output.) Additional Information: This option is not valid until the amount of time that the ONCONFIG parameter TXTIMEOUT specifies has been exceeded. The -Z option should rarely be used and only by an administrator of a database server involved in distributed transactions. References: For information on initiating independent actions in a two-phase commit protocol, see the chapter on multiphase commit protocols in the IBM Informix Administrator's Guide.

Element

Purpose

Key Considerations

-Z address

Kills a distributed transaction associated with the shared-memory address address

Restrictions: This argument must be the address of an ongoing distributed transaction that has exceeded the amount of time that TXTIMEOUT specifies. The address must conform to the operating-system-specific rules for addressing shared-memory. (The address is available from onstat -x output.)

Additional Information: This option is not valid until the amount of time that the ONCONFIG parameter TXTIMEOUT specifies has been exceeded. The -Z option should rarely be used and only by an administrator of a database server involved in distributed transactions.

References: For information on initiating independent actions in a two-phase commit protocol, see the chapter on multiphase commit protocols in the IBM Informix Administrator's Guide.

Distributed transactions provide the ability to query data on different database servers.

Warning:

If applications are performing distributed transactions, killing one of the distributed transactions can leave your client/server database system in an inconsistent state. Try to avoid this situation.