• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • Last Modified:

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

0
sridhar_PJ
Asked:
sridhar_PJ
  • 4
  • 2
1 Solution
 
TimCotteeCommented:
This is the only solution that I have found:

DB2 UPDATE DBM CFG USING QUERY_HEAP_SZ 2000

I have no real experience here, just reporting what I found. Apparently you have to restart the DB2 server after doing this otherwise it will have no effect.

Source : http://www.lsc-group.phys.uwm.edu/pipermail/lal-discuss/2002q1/000461.html
0
 
gallagheCommented:
(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.

0
 
sridhar_PJAuthor Commented:
I am using winnt Version of DB2
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
gallagheCommented:
Do you have much free disk space? may be this is the problem.
0
 
sridhar_PJAuthor Commented:
Ya,
I have nearly 6GB of free space
0
 
sridhar_PJAuthor Commented:
Any more ideas,
Timcotte, i have already done,what you said. But no improvements.
Regards
Sridhar
0
 
sridhar_PJAuthor Commented:
Still my problem has not solved.
Choosing nearest best answer.
Thanks for your help
Sridhar
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now