Re: Shared memory as default communic. protocol

meloi@my-deja.com wrote: > > We have Baan IVb2 > Porting set : 6.1c.04.02 > OS-release : AIX4.3.2.0 > IDS Version: 7.31.UC5 > Box:BULL RL > CPU: 4 > Memory: 2.5 GB > > I was told that in case of Host-Mode (1 box) we sould use shared memory > as default communication protocol. By who? The recommendation for Baan in host mode is stream pipes. This is mainly because stream pipes allows multiplexing and shared memory does not. > I've tried but it didn't work. > What should I do ? You should use stream pipes, not shared memory. > Is that the reason why run a script with 'dbaccess' and use baan_shm it > takes about 30 minutes (table with 20.000.000 records) and when I run > the same query in BaaN SQL it takes about 5 hours ? No, that is probably just the Baan code. ;-) > Current configuration: > (SQlHOSTS) > baan onsoctcp atl baan m=1 > baan_shm onipcshm atl baan Just add a stream pipe connection and make sure you have m=1. > (ONCONFIG) > # System Configuration > > SERVERNUM 0 # Unique id corresponding to > DBSERVERNAME baan # Name of default database server > DBSERVERALIASES baan_shm # List of alternate dbservernames > NETTYPE soctcp,3,100,CPU # Configure poll thread(s) for nettype To switch on multiplexing you also need an additional NETTYPE entry like so: NETTYPE sqlmux,,, Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+