Solved

VB and DB2

Posted on 2002-04-29
7
550 Views
Last Modified: 2008-02-01
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
Comment
Question by:sridhar_PJ
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 43

Accepted Solution

by:
TimCottee earned 100 total points
ID: 6976668
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
 
LVL 2

Expert Comment

by:gallaghe
ID: 6977260
(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
 
LVL 3

Author Comment

by:sridhar_PJ
ID: 6977406
I am using winnt Version of DB2
0
Independent Software Vendors: 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!

 
LVL 2

Expert Comment

by:gallaghe
ID: 6977538
Do you have much free disk space? may be this is the problem.
0
 
LVL 3

Author Comment

by:sridhar_PJ
ID: 6979888
Ya,
I have nearly 6GB of free space
0
 
LVL 3

Author Comment

by:sridhar_PJ
ID: 6990802
Any more ideas,
Timcotte, i have already done,what you said. But no improvements.
Regards
Sridhar
0
 
LVL 3

Author Comment

by:sridhar_PJ
ID: 7005301
Still my problem has not solved.
Choosing nearest best answer.
Thanks for your help
Sridhar
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question