Restrictions on federated updates with application savepoints
Federated systems impose some restrictions on savepoint operations.
Savepoint support for write operations on remote data in federated applications is limited to
Db2®. The
following restrictions apply to the data source object that the nickname is defined for (as the
target of a write operation):
- For Version 9.5, the data source object in a savepoint operation can be a nickname itself.
- For previous versions, the data source object in a savepoint operation cannot be a nickname.
You can activate savepoints in serial mode, the massively parallel processing (MPP) environment, and the federated one-phase commit or federated two-phase commit environments. Any restrictions that exist in these environments also apply to savepoints operations.