Re: Memory Allocation Problems using DBD::Informix and Perl

Mark Hewis wrote: > DBD::Informix ver 0.59 > DBI:: ver 0.93 > Perl version 5.004_04 built for sun4-solaris. Thanks for the version info. > The problem: > > After an initial database handle is created perl returns an out > of memory message if more than 11 MB of space is used by the script. Are you using olipcshm connections? (Answer: yes). Have you set INFORMIXSHMBASE environment variable? Answer: probably not. Diagnosis: INFORMIXSHMBASE is too low, so your shared memory connection is blocking further memory allocations by malloc(). Solution: set INFORMIXSHMBASE to a suitably large value -- you need how much space for memory allocation? 67 MB? The set INFORMIXSHMBASE to something like 72 or 96 or 128 MB. > ##EXAMPLE SCRIPT 1## > [...three examples which support my hypothesis omitted...] > Has anyone encountered this problem? It seems connect reduces the > maximum space that the script containing it can use. Any solutions? Set INFORMIXSHMBASE or use oltlitcp or olipcstr or anything except olipcshm connections. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>