Re: UPDATE STATISTICS Problem

Rajendra Singh (rajsingh@hotmail.com) 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. : -- : Mr. Rajendra Singh, B. Sc. (rajsingh@hotmail.com) : "What is understood need not be discussed." - Loren Adams Increase maxfiles, the max files open per process. -- Dan Mercer Reply To: damercer@mmm.com Opinions expressed herein are my own and may not represent those of my employer.