208 error solved
> After doing a fair percentage of these statements the prepares > start failing with sqlca.sqlcode = -208 (Memory allocation failed during > query processing. Reduce the complexity of your query or program). > My questions are: > > 1. Has anyone out there had a similar problem? > 2. Is there some rule of thumb for how many prepares, cursor declares are too > many? > 3. Any suggestions on work-arounds (I'd rather not break my daemon > into separate smaller daemons or do frees and re-prepares but if > that is all there is???) > 4. Will my idea of doing all prepares and declares at initialization time > guarantee that either I get the 208 or I don't or might something > later overflow this resource? >>The bottom line is you need to change your Informix tbconfig shared memory >>base address from 0x100000 to 0x400000 (between 0x400000 and 0x800000). >>Your process is running out of memory, this will let your SQL process >>allocate more memory and resolve the problem. >> >>This is not addressed anywhere in the SUN Informix docs. I called Tech >>support and eventually resolved the problem with pointers in the right >>direction from comp.databases newsgroup. >> >>As always "Hope this helps". >> >>+-------------------------------------------------------------------------+ >>| P.E. Begley | >>| Computer Automated Engineering Systems | >>| United Engineers & Constructors Internet: peb@scdipc0.ueci.com | >>| 30 South 17th Street UUCP: uunet!trac2000!scdipc0!peb | >>| Philadelphia, PA 19101 USA Voice: +1 215 422 4331 | >>+-------------------------------------------------------------------------+ I just wanted to thank everybody who responded to my 208 problem with special thanks to P.E. Begley who came up with the correct solution to my problem. I changed my shared memory base address as he suggested and all works fine now! +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Jim Laur jel@lzatt.att.com Work Phone: (908)576-4309 AT&T Bell Labs, Rm 3M-317, 307 Middletown-Lincroft Rd, Lincroft, NJ 07738 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++