Problem:

When a CURSOR WITH HOLD is used within a Enterprise Server Environment under the control of the DB2 XA Switch module a SQLCODE -30090 is returned.

Resolution:

This is the default behaviour from DB2 with XA Transaction Control.

IBM have a setting to enable this funtionality under XA.

If you add HOLD_CURSOR=T to the XA Open string within Enterprise Server then it will enable this functionality.