Distributed unit of work

 

Distributed unit of work (DUW) allows access to multiple application servers within the same unit of work. Each SQL statement can access only one application server. Using distributed unit of work allows changes at multiple application servers to be committed or rolled back within a single unit of work.

• Managing distributed unit of work connections
  You can use the CONNECT, SET CONNECTION, DISCONNECT, and RELEASE statements to manage connections in the distributed unit of work (DUW) environment.

• Checking the connection status
  When it is possible to have a read-only connection, your program should check the status of the connection before doing any committable updates. This prevents the unit of work from entering the rollback required state.

• Cursors and prepared statements
  Cursors and prepared statements are scoped to the compilation unit and also to the connection.

 

Parent topic:

Distributed relational database function and SQL