asked on

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

AndyEastham

Try increasing the value of QUERYTIMEOUTINTERVAL in your db2cli.ini file

Andy

AndyEastham

Hi,

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

eg

[TEST]
DBALIAS=TEST
QUERYTIMEOUTINTERVAL=500

Senz79

ASKER

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

ASKER CERTIFIED SOLUTION

AndyEastham

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Senz79

ASKER

still facing issue but not frequently