Resolving problems when using databases

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

DB2 error message SQL0443N is issued

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

Start of change

DB2 error message SQLSTATE=58005 is issued

End of change

DB2 or ODBC error messages are issued on z/OS

Start of change

Error message BIP1780 is issued on AIX

End of change

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

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

Start of change

Oracle error message ORA-12500 is issued on Solaris 8 with Oracle 9

End of change

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

The DataDirect trace system is unable to open the ODBC trace file