asked on

VB and DB2

Dear Experts,
I have developed a program that majorly uses DB2 Database. In the past it worked fine. Now for last one week i am facing problem. It has been giving the following error.

[IBM][CLI Driver][DB2/NT] SQL0973N Not enough storage is available in the "QUERY_HEAP" heap to process the statement. SQLSTATE=57011

I have seached in the web to solve the problem. But i could't found a solution.
I increased the DRDA Heap size in client and Application Heap size in server, But the problem still persist.
FYI: I have not changed the code recently.
Can any one give nice solution for this.
Regards
Sridhar

ASKER CERTIFIED SOLUTION

TimCottee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gallaghe

(if you are not using an AS400 then ignore this)

I work with VB/DB2 and the only time we have problems is when the AS400 gets some update to the OS which sometimes causes code to fail. So what I suggest is talking with whomever is in charge of the AS400/DB2 and ask if there have been updates since your problem started.

sridhar_PJ

ASKER

I am using winnt Version of DB2

gallaghe

Do you have much free disk space? may be this is the problem.

sridhar_PJ

ASKER

Ya,
I have nearly 6GB of free space

sridhar_PJ

ASKER

Any more ideas,
Timcotte, i have already done,what you said. But no improvements.
Regards
Sridhar

sridhar_PJ

ASKER

Still my problem has not solved.
Choosing nearest best answer.
Thanks for your help
Sridhar