1741
Report Indexing / Re: Intermittent Index and Load Failures arsadmin.c
« on: February 09, 2012, 08:48:24 AM »
As usual, Alessandro is right. You need to increase the amount of RAM allocated to the CMOD 'applications' that connect to DB.
Since you're (severely) backleveled on DB2, the parameter you want to check for is APPLHEAPSZ.
To update this parameter in DB2, use this command:
db2 update db cfg for archive using applheapsz <new size in pages>
Your friendly neighbourhood DBA should be able to recommend a value based on the rest of your DB2 configuration. In the (distant) past, I've set this value to 1024 (in combination with other changes to other parameters like DBHEAP) to resolve similar issues with failed queries. Of course, always make a note of your current values so you can go back to them if the change doesn't have the desired effect.
-JD.
Since you're (severely) backleveled on DB2, the parameter you want to check for is APPLHEAPSZ.
To update this parameter in DB2, use this command:
db2 update db cfg for archive using applheapsz <new size in pages>
Your friendly neighbourhood DBA should be able to recommend a value based on the rest of your DB2 configuration. In the (distant) past, I've set this value to 1024 (in combination with other changes to other parameters like DBHEAP) to resolve similar issues with failed queries. Of course, always make a note of your current values so you can go back to them if the change doesn't have the desired effect.
-JD.