Restrictions on DB2 WebSphere MQ user-defined functions

Federated systems impose some restrictions on DB2® WebSphere® MQ functions.

The following restrictions apply to DB2 WebSphere MQ functions:
  • DB2 WebSphere MQ functions do not support two-phase commit. When using DB2 WebSphere MQ functions in a two-phase commit environment, with the DB2MQ or DB2MQ1C schema, SQL30090N reason code 18 is issued.
  • DB2 WebSphere MQ functions only support single thread applications. Set the value of the MQ wrapper option DB2_THREADSAFE to N if you want to invoke DB2 WebSphere MQ functions in a multiple threaded application. For example: db2 "alter wrapper MQ options(set db2_threadsafe 'N')"
  • DB2 WebSphere MQ functions do not support savepoints and WITH HOLD cursors.