Thanks for your valuable input. Yes, you are right this turned out to be a DB server problem. We are not seeing this error anymore after increasing the DS_TOTAL_MEM parameter in the Informix server to 1024 KB (from its default 256 KB).
Appreciate your help. Thanks. Ram From: Jonathan Leffler [mailto:jonathan.leff...@gmail.com] Sent: Tuesday, July 02, 2013 5:39 PM To: KOTAGIRI, RAMPRASAD Cc: dbi-users@perl.org Subject: Re: SQL: -208: Memory allocation failed during query processing AFAICR, the DBD::Informix driver does not report error -208 when client-side memory allocation fails in DBD::Informix code, so the problem is almost certainly in the server, not in Perl, DBI or DBD::Informix. It might conceivably be in the ESQL/C code. You say it works in another environment; please can you provide details of that other environment? That is, is it the same database server (the same Informix instance) or a different one? And which tools are you using in that other environment. If the second environment is access the same database server, then there are lots of questions to ask, such as: What exactly is the query? What size are the tables (row size, number of rows)? What are the table schemas? What is the version of Informix that you're using? Which version of ESQL/C or CSDK? Are you hacking the system's copy of Perl? Or are you installing the extra software in your own directory? Is there a reason you can't move to, say, Perl 5.8.9 (or even 5.16.2 or 5.18.0)? Did this query ever work on this machine, or is this new development work? Andrew Snyder asked a salient question: are you reading all the rows at once ($sth->fetchall_arrayref() or something similar)? If so, your comparison environment must also be Perl + DBI + DBD::Informix to be of much relevance. Are you using a 32-bit or 64-bit version of Perl? As you can tell from the sheer number of questions, you've not really characterized your problem very clearly yet, so no-one can really help you with solving it. On Mon, Jul 1, 2013 at 3:20 PM, KOTAGIRI, RAMPRASAD <rp5...@att.com<mailto:rp5...@att.com>> wrote: Environment: Perl v5.8.4 built for sun4-solaris-64int [SunOS 5.10] Perl DBI uses Informix DBD, DBI connect and prepare statement are successful, execute routine returns error: SQL: -208: Memory allocation failed during query processing The same SQL query works fine and returns results in other environment. Can you please suggest if the issue is with DB engine or Informix driver in Perl? Thanks, Ram -- Jonathan Leffler <jonathan.leff...@gmail.com<mailto:jonathan.leff...@gmail.com>> #include <disclaimer.h> Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."
