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
Solved

VB and DB2

Posted on 2002-04-29
7
545 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
  • 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
using Access 8 75
Add a task in Outlook from access 11 42
Child Form in front 4 49
VB 6 error 5 in windows 10 but not in XP 7 63
Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

808 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