Transaction sharing allows multiple database sessions within a user session to share a single locking structure and recovery unit, thereby eliminating inter-session deadlocks.
Any access to a database from within an SQL-invoked external routine brings with it the potential for deadlocking if the same data is directly accessed from within the encompassing SQL session. By having both the SQL-invoked external routines and the encompassing SQL session all share a single transaction, the deadlock potential is eliminated.
Transaction sharing for SQL-invoked external routines is controlled by the TRANSACTION SHARING attribute of the SQL-invoked external routine definition. See the different SQL DDL statements for SQL-invoked external routines.
|
Copyright © 2014 CA.
All rights reserved.
|
|