Restrictions on transaction management are as follows:
If nested begin transaction and commit transaction statements are included in a transaction that involves remote servers, only the outermost set of statements is processed. The innermost set, containing the begin transaction and commit transaction statements, is not transmitted to remote servers.
The transaction model described in “Pre-12.x servers” is not supported in server class db2. It is also not supported in server class sql_server when the remote server is a pre-release 10.0 SQL Server or a Microsoft SQL Server. In these cases, the transactions are committed after each statement is completed.