Print Page - SQL scrollbulkfetch status =-9. Application heap memory problem.

Title: SQL scrollbulkfetch status =-9. Application heap memory problem.
Post by: johnpenna on 31 Aug 2005 09:36:33 AM

Hi Guys,
We use Reportnet 1.1 MR2 413.8 running on solaris on unix using a DB2 7.2 database.

I am currently experiencing a problem with the appliation heap size. After takin advice from cognos (e.g document 1004876) on their site.

I am still having this problem.The memory size has been used on the DB. It is now at 800mb!!!which is massive and is still occuring , does anyone know how to release the resources??

The DBAs have Increased the database configuration parameter (applheapsz) to allow a larger memory.

Any help would be appreciated.

Once the

Title: Re: SQL scrollbulkfetch status =-9. Application heap memory problem.
Post by: johnpenna on 01 Sep 2005 10:00:22 AM

Seems that you must using the latest version of db 8.2. The cursor stays open and does not close.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: johnpenna on 31 Aug 2005 09:36:33 AM