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.