Ingres Version: All OS: All Q: Im trying to run a query but Im getting error, “E_QE0236 Transactions cannot contain more than 255 DMF temporary files”. What does this mean?
The DMF will often create temporary files when running a query. For example, when the QEF runs out of sort memory sorting rows, it will hand the query to the DMF to run on disk using temporary files. There is a hard limit of 255 of these files. Some common workarounds include increasing qef_sort_memory when the error occurs during a sort, or running commits more frequently.
Related Questions
- Ingres Version: All OS: All Q: Im trying to run a query but Im getting error, "E_QE0236 Transactions cannot contain more than 255 DMF temporary files". What does this mean?
- Ingres Version: All OS: All Q: How do you trace the SQL statements in JDBC (similar to printqry)?
- Ingres Version: All OS: All Q: How does an object get registered in star database?
