Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ERROR [57014] [IBM][DB2/LINUX] SQL0952N  Processing was cancelled due to an interrupt.  SQLSTATE=57014

Posted on 2010-09-06
5
Medium Priority
?
1,892 Views
Last Modified: 2012-06-21
Hello
Kindly look into the code and please tell me where i am missing, thus i am getting the above error
objClsDB.conDB2.ConnectionTimeout = 0;
                    
                    objClsDB.conDB2.Open();

                    
                    
                    objClsDB.cmdDB2.CommandText = Query;
                    

                    

                    
                    DB2DataAdapter da = new DB2DataAdapter(objClsDB.cmdDB2.CommandText, objClsDB.conDB2);
                    DB2CommandBuilder cBuilder = new DB2CommandBuilder(da);
                    

                    DataTable QTable = new DataTable();
                    QTable.Locale = System.Globalization.CultureInfo.InvariantCulture;
                    
                                        da.Fill(dsTable, "RCCM");// Error in this line
                                       
                   

                    objClsDB.cmdDB2.Dispose();
                    objClsDB.conDB2.Close();
                    objClsDB.conDB2.Dispose();

Open in new window

0
Comment
Question by:Senz79
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:AndyEastham
ID: 33615785
Try increasing the value of QUERYTIMEOUTINTERVAL in your db2cli.ini file

Andy
0
 
LVL 3

Expert Comment

by:AndyEastham
ID: 33615800
Hi,

By the way, if there is no setting, try QUERYTIMEOUTINTERVAL=500

eg

[TEST]
DBALIAS=TEST
QUERYTIMEOUTINTERVAL=500
0
 
LVL 4

Author Comment

by:Senz79
ID: 33615997
After Increasing that i am getting

ERROR [57011] [IBM][DB2/LINUX] SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011
i have set QUERYTIMEOUTINTERVAL=0 in db2cli.ini
 
anything i can do at application level


 
0
 
LVL 3

Accepted Solution

by:
AndyEastham earned 1500 total points
ID: 33616695
I think th eparameter you need to change is applheapsz

To get the current value:

db2 get database configuration for dbname

To update it eg to 1024 (4kb pages):

db2 update database configuration for dbname using applheapsz 1024

You could try increasing it until the problem goes away but obviously setting this too large may have side effects.

Andy




0
 
LVL 4

Author Closing Comment

by:Senz79
ID: 33740767
still facing issue but not frequently
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

926 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