Getting the below error when java based application is making an entry into db2-db2 federated table.

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -30090, SQLSTATE: 25000, SQLERRMC: 18

Any idea?

Thanks
Shri

> db2 ? SQL30090N

...
18 An update request (or, a DDL operation that results in the
update of a system catalog table) has been issued that would
result in multiple data sources being updated when one or more
of the data sources in the unit of work only supports one-phase
commit. Possible causes are:
* An attempt was made to update a data source that only
supports one-phase commit, but a different data source has
already been updated in the same unit of work.
* An attempt was made to update a data source that supports
two-phase commit, but a different data source that only
supports one-phase commit has already been updated in the
same unit of work.
* An attempt was made to update a local federated server
table, but a data source that only supports one-phase commit
has already been updated in the same unit of work.
* An attempt was made to update a data source that only
supports one-phase commit when the application is operating
with a CONNECT type 2 connection setting.
...

For reason 18,
do one of the following steps:
* Submit a COMMIT or ROLLBACK before issuing an update to a
different data source.
* If multiple data sources need to be updated within a unit of
work, make sure the db2_two_phase_commit server option has
been set to 'Y' for all the data sources that need to be
updated. See the SQL Reference for information on setting
the value used for the db2_two_phase_commit setting.
* If the data source to be updated supports only one-phase
commit and the application is operating with a CONNECT type
2 connection setting, change the application to operate with
a CONNECT type 1 connection setting.

...