I've had an web app running for about a year now. It's a C#, ASP.Net application that using the DB2 .NET data procvider to iSeries.
Starting yesterday, the following exception is being thrown:
SQL0666 SQL query exceeds specified time limit or storage limit.
When this statement is ran:
Select MenuAccounting.*, (CashAmount + ChargeAmount) as TotalSales From MenuAccounting Where OrderDate >= '5/15/2009' and OrderDate <= '5/15/2009' Order by OrderDate
The statement should only return 1 row of data base. It is ran over a view that has 220 records in it.
I can run the statement fine as a script through IBM System navigator. The system query timelimit is set to *NoMax.
Doesn't anyone know what the problem could be?