The system administrator can also specify a server-wide interval after which Adaptive Server automatically rolls back transactions that are in the detached state. dtm detach timeout period sets the amount of time, in minutes, that a distributed transaction branch can remain in the detached state. After this time has passed, Adaptive Server rolls back the detached transaction.
For example, to automatically rollback detached after 30 minutes, use the command:
sp_configure 'dtm detach timeout period', 30
