Re: Informix OnLine ISQL error

Path: emory!swrinde!cs.utexas.edu!sun-barr!cronkite!newstop!sun!amdcad!jetsun!pyramid!infmx!aland From: aland@informix.com (Colonel Panic) Newsgroups: comp.databases 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 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."