IBM Informix on limited memory device

Hi, I'm considering IBM Informix on a limilted memory device (IoT-gateway-device) having 256 MB RAM and running (Debian) Linux. - What are the minimum (memory) requirements for running IBM Informix in an acceptable way (is 64 MB acceptable)? An IoT gateway is mainly meant to gather sensor-data. I saw there are ARM 6-7 based ports (meant for memory constrained devices like RPi) of the Informix Developer Edition. - So I suppose the regular Linux 32-bit versions (Developer Edition, Innovator-C Edition), will run on my AMD based processor IoT-gateway device? Thanks. Guy

64MB is definitely possible: cheetah@pacman.onlinedomus.net:fnunes-> onstat -g seg IBM Informix Dynamic Server Version 11.50.UC9W2X1 -- On-Line -- Up 00:00:15 -- 42016 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 1179666 52574801 44000000 27664384 385252 R 6752 2 1212435 52574802 45a62000 15360000 91064 V 3376 374 Total: - - 43024384 - - 10128 376 (* segment locked in memory) No reserve memory is allocated cheetah@pacman.onlinedomus.net:fnunes-> 42MB in this case... But don't expect to run a home banking application on it :) If your gateway runs AMD and a compatible OS it should run Informix. Regards On Sat, Feb 14, 2015 at 12:04 PM, GUY DILLEN <guy.dillen@hotmail.com> wrote: > Hi, > > I'm considering IBM Informix on a limilted memory device > (IoT-gateway-device) > having 256 MB RAM and running (Debian) Linux. > - What are the minimum (memory) requirements for running IBM Informix in an > acceptable way (is 64 MB acceptable)? An IoT gateway is mainly meant to > gather > sensor-data. I saw there are ARM 6-7 based ports (meant for memory > constrained > devices like RPi) of the Informix Developer Edition. > - So I suppose the regular Linux 32-bit versions (Developer Edition, > Innovator-C Edition), will run on my AMD based processor IoT-gateway > device? > > Thanks. > Guy > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11c2fb4ca58402050f0f20bf

I can't speak to minimum memory requirements running on ARM, but you cannot use the Intel Linux release of Innovator-C on ARM. You will have to contact an IBM salesperson to get the Innovator-C Edition for ARM and to talk about licensing it for distribution (it is free for you own use, but if you want to distribute the devices you build you will need to work out an OEM distribution agreement with IBM. EMail me directly if you need a contact. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Feb 14, 2015 at 7:04 AM, GUY DILLEN <guy.dillen@hotmail.com> wrote: > Hi, > > I'm considering IBM Informix on a limilted memory device > (IoT-gateway-device) > having 256 MB RAM and running (Debian) Linux. > - What are the minimum (memory) requirements for running IBM Informix in an > acceptable way (is 64 MB acceptable)? An IoT gateway is mainly meant to > gather > sensor-data. I saw there are ARM 6-7 based ports (meant for memory > constrained > devices like RPi) of the Informix Developer Edition. > - So I suppose the regular Linux 32-bit versions (Developer Edition, > Innovator-C Edition), will run on my AMD based processor IoT-gateway > device? > > Thanks. > Guy > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013c6af02f8145050f167c9e

Hi, Thanks for the info. @Art My sentence was maybe confusing: my gateway has an AMD 32-bit processor not ARM. I only mentioned ARM since these are also memory constrained devices, meaning IDS probably also runs fine on an AMD with 256 MB RAM. Regards, Guy

Hi, On Saturday, February 14, 2015 01:04:29 pm you wrote: > Hi, > > I'm considering IBM Informix on a limilted memory device (IoT-gateway-device) > having 256 MB RAM and running (Debian) Linux. > - What are the minimum (memory) requirements for running IBM Informix in an > acceptable way (is 64 MB acceptable)? An IoT gateway is mainly meant to > gather sensor-data. I saw there are ARM 6-7 based ports (meant for memory > constrained devices like RPi) of the Informix Developer Edition. 256 MB RAM can be enough if no other memory consuming processes are running. In addition the Informix configuration requires some tuning for low memory devices. You can try the onconfig default values we changed for the Raspberry Pi port: BUFFERPOOL default,memory=auto LOW_MEMORY_MGR 1 SHMVIRTSIZE 16384 SHMADD 16384 AUTO_TUNE 1 NUMFDSERVERS 1 VP_MEMORY_CACHE_KB 0,static NETTYPE ipcshm,1,10,CPU > - So I suppose the regular Linux 32-bit versions (Developer Edition, > Innovator-C Edition), will run on my AMD based processor IoT-gateway device? Yes, the latest Informix Version 12.10.UC4W1 should run if the AMD CPU supports i586 or higher instruction sets. Thanks, Andreas > > Thanks. > Guy > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Andreas Breitfeld; Informix Development Munich IBM Deutschland Research & Development GmbH; Vorsitzende des Aufsichtsrats: Martina Koederitz; Geschaeftsfuehrung: Dirk Wittkopp; Sitz der Gesellschaft: Boeblingen; Registergericht: Amtsgericht Stuttgart, HRB 243294