Re: UPDATE STATISTICS Problem

At 03:57 PM 6/29/98 -0400, you wrote: >Rajendra Singh wrote: >> >> We're having many problems with "update statistics" on our Informix SE database >> v 7.24. One of the problems we're having is that whenever we do an "update >> statistics high for table x", we get error -567 (cannot write sorted rows), with >> ISAM code 24 (too many open files). >> >> I tried increasing the "nfiles" (max number of open files) parameter in the >> (HP-UX, v10.20 on a G50) Kernel by 1400, but that didn't help either. There is >> alot of free disk space, and usually there is only one or two users on the >> machine. We've also tried rebooting. >> >> Does anyone know of a solution to this? I've checked the FAQ, searched Usenet, >> and the web but didn't come up with anything. > >I believe that the NFILES kernel parameter is the maximum number of >open files per system. There is another parameter which controls the >maximum number of open files per process. > >Art S. Kagel > Check out the NOFILES kernel parameter. At least, that's the name in SCO. Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+