Ingres + Dec Alpha

On May 28, 17:20, uunet!aqmd.gov!patw wrote:
> Subject: Re: Who is using Ingres and DEC Alpha UNIX 3.2D
> I don't think One Week is going to do it.  We had problem with DEC C
> compiler not able to Optimize the ABF applications,

use -O1 not -O2.

> SQL being too large crashing the server,
> Not being able to Optimizedb the database within 24 hours on a DEC alpha
> 8400 4 ways (~ 900 Tables),
> iitree locking problems with Power Builder,
> Rules and procedure running out of OPF memory,
> Unalign process with Ingres,
> Ingres Net going down with no errors,

haven't run into these except the iitree (and iistatistics) locking issues
which i think are general 6.4/05 problems, not Alpha specific.

> update with sub select in where clause never coming back on a table with
> over ~100,000 rows.

set trace point op133, or use the -flatten option to the server.
It's probably doing an SE-join.  It's real annoying.  (This one is
not Alpha specific either, it happens on several platforms.)

Another Alpha gotcha:  you'll probably need to increase -qef.qep_size
substantially, the default of 2560 (? i think) is way too small.  Our Alpha
sites run it at 9000.  You also need a larger -opf.memory and a smaller
-opf.active (our sites run something like 8 meg and 3 active, and i've
never seen a session blocked waiting for opf).

There's also an lseek/close error 9 bug that crashes ingres and/or
corrupts tables, i think the latest patch coming out now will fix that.


-- 
Karl Schendel            Phone: (412) 963-8844
Telesis Computer Corp      Fax: (412) 963-1373
wiz@telesis.com
Ingres Q & A
To William's Home Page
Email William