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

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

LVL 4
Senz79Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
AndyEasthamConnect With a Mentor Commented:
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
 
AndyEasthamCommented:
Try increasing the value of QUERYTIMEOUTINTERVAL in your db2cli.ini file

Andy
0
 
AndyEasthamCommented:
Hi,

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

eg

[TEST]
DBALIAS=TEST
QUERYTIMEOUTINTERVAL=500
0
 
Senz79Author Commented:
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
 
Senz79Author Commented:
still facing issue but not frequently
0
All Courses

From novice to tech pro — start learning today.