Fixing DB2 SQLCODE -444 error when routing polymorphic documents

Depending on your DB2 UDB configuration you may see SQLCODE -444 error messages when routing polymorphic (map chain) documents. These error messages would be located in the file {INSTALL DIR}\was\profiles\bcgdocmgr\logs
\bcgdocmgr\bcg_router.log as well as <DB2Home>\SQLLIB\bin\db2diag.log. If you see this message you should increase the value of the DB2 Database Manager parameter SHEAPTHRES. This parameter should be at least two times the largest sortheap value defined for any database within the DB2 instance. A sample command is given below:

db2 UPDATE DBM CFG USING SHEAPTHRES xxxxx IMMEDIATE

If the SQLCODE -444 persists after changing the value of SHEAPTHRES, you may also need to decrease the values of STMTHEAP and APPLHEAPSZ for your WPG database. A sample command is given below:

db2 UPDATE DB CFG FOR <dbname> USING STMTHEAP xxxxx

db2 UPDATE DB CFG FOR <dbname> USING APPLHEAPSZ xxxxx

Please consult your DBA or refer to your DB2 Administrator's Guide before changing any settings.

Copyright IBM Corp. 2003, 2005