Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!zaphod.mps.ohio-state.edu!wuarchive!uunet!trac2000!peb
From: peb@trac2000.ueci.com (Paul Begley)
Newsgroups: comp.databases
Subject: Informix OnLine ISQL error
Keywords: Informix malloc
Message-ID: <1024@trac2000.ueci.com>
Date: 23 May 91 11:39:23 GMT
Organization: UE&C - Catalytic in Philadelphia, PA
Lines: 32

I have been losing my mind moving our database and applications from a
DEC 3100 to a SUN.  

Here are the particulars:

SUN IPC - 24 Meg, SunOS 4.1.1, configured per release notes
Informix OnLine 4.00 UH1
Informix SQL 4.00 UH1

Problem:

Loading SQL command file to create database and tables (300+) causes
Error 208 - Memory allocation failed during query processing.

I have tried several ways of running the SQL program, but always
encounter the Error 208.  Once I get the error I can't execute any
more SQL commands (ISQL fails, too...).  Exiting ISQL and reentering
allows me to run SQL commands again.

We have Informix support, they did not have any insight into the
problem, but discussed system configuration as a probable cause of the
problem.

HOWEVER, we performed this exact task a month earlier on a
SPARCStation 2 and OnLine just a month or two earlier without ANY
problems.  Go figure.

Anyone else encounter this problem?  I have tried tweeking both the
Informix config (increased tables and buffers) and the SUN IPC config
(System Performance Tuning - Nutshell Handbook is a great reference).
I also tried running as console rather than within OpenWindows to
reduce system overhead - again no luck.