Re: Online Workgroup Server on SCO 5.0.4 with onipcshm

1. Have you set the SCO kernel parameters as stated in release notes ? 2. Try to update statistics for you database(s) in Workgroup Server for better performance. Kind Regards, Octav Ralph wrote: >Hi, > >thanks for the reply > >attached you find the sqlhosts and the onconfig >The settings are mostly default. >>From the moment the shared memory server alias is added in both files, >I get the error message. > >Any hints ? > >PS : the SE installation keeps being faster than this Workgroup server, for > the same database. That's why I would like to try the shared memory >option > as the major 'volume' transactions are local to the server. >> >>FAIK shared memory should work on ALL UNIX platforms. Post your >>ONCONFIG file and the appropriate lines from sqlhosts. >> >>Art S. Kagel > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com

Octav, thank you for answering. It definitely had something to do with my kernel. The online.log file states I ran out of semaphores. Now when I read the installation notes, I did notice the kernel parameters. I tried at first to set these to the indicated values with scoadmin But 1) not all suggested kernel parameters were to be reached by scoadmin 2) the ones that were to be reached stated that I went out of the normal reach for these parameters (for example some were expected to be within 10 - 100 and had to be set to 8192.) After your remark I started digging into this and found mtune, stune and idtune in SCO5 so I could alter the Kernelparameters as required. Problem solved. Thanks. Performance stays behind, though. Performance gain by switching from SE to OWS is not evident, so it seems. Ralph