Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!cronkite!newstop!sun!amdcad!jetsun!pyramid!infmx!aland
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases
Subject: Re: Informix OnLine ISQL error
Keywords: Informix malloc
Message-ID: <1991Jun22.020958.21215@informix.com>
Date: 22 Jun 91 02:09:58 GMT
References: <1024@trac2000.ueci.com>
Sender: news@informix.com (Usenet News)
Organization: International Brotherhood of Geeks, Local 619
Lines: 49

In article <1024@trac2000.ueci.com> peb@trac2000.ueci.com (Paul Begley) writes:
>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.
>...


It's a longshot, but try boosting SHMBASE to a higher starting address.
(SHMBASE is a tbconfig parameter that controls the shared memory
base address.)

The default is 1MB, e.g. 

SHMBASE         0x100000          # Shared memory base address

My workstation is an IPC with 12MB, and I was having some strange
problems on 4.10 until I boosted SHMBASE to 4MB:

SHMBASE         0x400000          # Shared memory base address

I'd suggest saving the current contents of tbconfig.std under another
name, then changing tbconfig.std plus your "real" tbconfig's SHMBASEs
to 0x400000, and see if that helps.


--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

"In the cafeteria just after lunch, (well, not *just* after, more like
 *during* lunch, about 12:28; say 12:30, give or take a few minutes),
 I leaned back in my chair (it was one of those aluminum chairs, good
 strength-to-weight, like titanium but not quite; but then of course
 titanium would be a bit of an overkill).  Anyway, I heard one of the
 girls talking about how boring she thought engineers could be."