Resolving problems when using databases

This topic contains advice for dealing with some common problems that can arise when using databases:

Error message BIP2322 is issued with SQL State 40001 when you use Aggregation nodes

DB2 error message SQL0805N is issued

DB2 error message SQL0998N is issued

DB2 error message SQL1040N is issued

DB2 error message SQL1224N is issued when you connect to DB2

DB2 or ODBC error messages are issued on z/OS

You do not know how many database connections a broker requires

You want to use XA with DB2

XA coordination fails with DB2 V8 Fix Pack 2

Error message BIP2322 is issued when you access DB2 on z/OS

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

There is a memory leak from the Oracle Client Interface on HP-UX 11

Error messages BIP2731, BIP2321, and BIP2322 are issued when you use retained publications with a Sybase database

Database updates are not committed as expected