Resolving problems when using databases

This section describes solutions to the following common problems that can arise when using databases:

You get error message BIP2322 with SQL State 40001 when using Aggregation nodes

You get DB2 error message SQL0805N

You get DB2 error message SQL0998N

You get DB2 error message SQL1040N

You get DB2 error message SQL1224N when connecting to DB2

You get DB2 or ODBC error messages on z/OS

You do not know how many database connections a broker requires

You want to use XA with DB2

You get an XA coordination failure with DB2 V8 Fix Pack 2

You get error message BIP2322 when accessing DB2 on z/OS

On Oracle, a database operation fails to return any rows, even though the rows exist

You get a memory leak from the Oracle Client Interface on HP-UX 11

You get error message BIP2731 when using retained publications with a Sybase database

Database updates are not committed as expected