Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    47

    Unanswered: Sqlcode: -30090, sqlstate: 25000

    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
    p.srinivasarao

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    > 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.

    ...


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •