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

[johnpenna]

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

[johnpenna]

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