Re: NUMCPUVPS

Edward Bidinotto <edbid@cobe.com> wrote: >I've been getting some wierd errors when running oncheck -cI against a >17mil row table. >I've dropped, recreated the table/indexes but continue to get the >following errors. >"could not check rowids and perform data <=> index check >"unknown error message 0" >We are running 7.11uc1 on HP 9.04 on a T500 with 4 cpus and 1.6 gig mem. >In talking with Informix, they told me to try reducing the NUMCPUVPS to >1 instead of 4. When I did this - everything was dog slow however the >oncheck -cI worked correctly. >In either case all other oncheck commands work fine!! >In the Informix admin book Informix recommends setting this value to one >less than the number of CPU's in the computer. >They also talk about running onstat -g glo and looking at the usercpu >and syscpu times together approaching 100% of the elapsed time while >running this command and looking at performance. >Can anyone give me some other guidelines for setting NUMCPUVPS and in >how to evaluate the onstat -g glo command... >P.S. We are also running on MTI Raid 5 Had a somewhat similar problem with 7.13uc2 on Solaris 2.4. We would get similar error message after building an index on a 50 million row table. Informix tech support told us to build the index with NUMCPUVPS=1. Normally we set it to 9 seeing we have 10 cpu's. At the lower setting the error message went away. Tech support said it was a bug with large tables. They weren't specific if the bug was with the create index or the oncheck -cI. They seemed to feel it was with theoncheck. We stopped pursuing it because we found a work around. We don't drop the index anymore. Barry Leb National Linen Service 1420 Peachtree Street MS #230 Atlanta, GA 30309 e-mail: barryleb@mindspring.com