Re: Error -567

DirkM wrote: > > Hallo Everyone, > > Every now and then we get the following error message in some of our > reports - > > Error status -567. Cannot write sorted rows > > All I can think of is that our temporary sort space got full at the time > the report was run. Is this true and what are my options for fixing this ? > I have the following variable set in my onconfig file so that the engine > will be used for sorting and not Unix (/tmp) - > DBSPACETEMP tempdbs_w,tempdbs_x,tempdbs_y,tempdbs_z > > Each of these tempspaces have the same size. > I'll appreciate any help you can give me on this. You really must start trusting tech support Dirk. You pay for the service and even the phone call is free. :-) But anyway, it's possible that your temp tables are being fragmented across the temp dbspaces. If ANY one of these dbspaces fills during an operation, then that operation fails, even if you have temp space in the other dbspaces. The ISAM error would tell you more. You could monitor the dbspace usage during the report and determine if these dbspaces are too small. Check your environment variables, particularly: DBSPACETEMP PSORT_DBTEMP These will override the configuration parameters. Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+