Re: User Threads

antaya@io.org (J. Cameron Antaya) wrote: >Does anybody know much about the number of concurrent user threads variable in >the /usr/informix/etc/onconfig.std file? >We're running an application, and receiving the message "You have >exceeded the maximum number of user threads" >Can I just up the number of threads in the config file, or does this have >something to do with concurrent licensed user? > >Any help would be greatly appreciated. > >Thanks. The USERTHREADS value means the total number of USERTHREADS available in the engine. This doesn't match to your licensed number of users because in PDQ you might have 10 threads spawned for one user for a large query. So long as the number of unique users doesn't exceed the number you are licensed for you will be fine. Don't change the onconfig.std file though because the engine only looks at that if there is no other onconfig file in the $INFORMIXDIR/etc directory. In future versions of DSA, 7.10.UD2 and above, the USERTHREADS parameter is no longer part of the configuration file. If you need more users the database engine will automatically increase the number of USERTHREADS available. You will get a message in the online.log file notifying you of the increase. Mike