Using aggregation with a DB2 database

If you are using DB2 for your broker database and your message flows include the aggregation nodes, you might see the error message:

BIP2322

with:

SQL State=40001

This is caused in stress conditions by multiple thread deadlocks. To resolve this:

  1. Disable the DB2 feature next key locking by issuing the following command in a DB2 command window:
    db2set DB2_RR_TO_RS=YES
  2. Restart the DB2 database manager.
For further information about this and other DB2 features, refer to the DB2 documentation.
Related concepts
Message flow aggregation
Related tasks
Creating a DB2 database on Windows
Creating a DB2 database on Linux and UNIX systems
Configuring access to databases
Authorizing access to the databases
Related reference
Supported databases