Re: initialization problem

Savio Mario Bartholomeo Pereira wrote: > > Hello everybody! > > I gotta problem. > I get an error while initializing informix. > oninit: Fatal error in shared memory creation. > > Version; IDS 2000 on SCO 7.1.0 > > I undrestand that the total memory (i:e memory segments) that informix > intends to grab is exceding the maximum OS limit for a single process. But I > could not understand the problem with CPU poll threads exceeding the > NUMCPUVPS. Also where should I check for the memory parameters in unix. > Virtual memory allocated: 1024 Kb > Resident memory allocated: 1500 Kb. > Add virtual memory segment: 1024 Kb. > > The contents of the lmessage log file are as follows: > > 14:28:21 The number of configured CPU poll threads exceeds 'NUMCPUVPS'.> NETTYPE '' poll threads started on NET VPs. This is non-fatal. Looks like you have N CPU VPs and more than N CPU poll threads configured. Poll threads are configured in the ONCONFIG file with the NETTYPE parameters. They look like this: NETTYPE ipcshm,4,300,CPU NETTYPE tlitcp,2,600,NET Multiply the second field (4 or 2 in the records above) times the number of connections listed in DBSERVERALIASES plus one for the connection listed in DBSERVERNAME that are described in the sqlhosts file to use the protocol in the first field of that record (here ipcshm or tlitcp). The product is the number of poll threads of each type (CPU or NET from field 4) that you are asking the engine to configure. So with the NETTYPEs above and: DBSERVERNAME fred DBSERVERALIAS wilma_mate,barney_friend,pebbles_dad and with sqlhosts: fred onipcshm house.bedrock.com sqlshm wilma_mate onipcshm house.bedrock.com sqlshm2 barney_friend ontlitcp house.bedrock.com sqltcp1 pebbles_dad ontlitcp house.bedrock.com sqltcp2 There are two shared memory connections asking for 4 CPU listeners threads each. If you do not have 8 CPU VPs the engine will have to start NET VPs instead. That is all that the message is saying. Art S. Kagel > Mon Jun 26 14:28:21 2000 > > 14:28:21 shmat: [EMFILE][24]: out of shared memory segments, check system> SHMSEG > > 14:28:21 out of virtual shared memory > > 14:28:21 Assert Failed: Unable to allocate a user thread for user id 102 > > 14:28:21 Informix Dynamic Server 2000 Version 9.20.UC3 > 14:28:21 Who: Session(0, @, 0, 0) > Thread(1, main_thread, 0, 1) > File: rsshmem.c Line: 727 > 14:28:21 Results: Memory allocation error. > > 14:28:21 Action: Make more virtual memory available to Dynamic Server 2000 > 14:28:21 stack trace for pid 1740 written to /tmp/af.3e9aed5 > 14:28:21 See Also: /tmp/af.3e9aed5> > Savio > reply at saviop75@hotmail.com