I went thru old subjects but cannot find any or helpful answers.
We a a unix server with Ingres installed. That server is only used for
php application, or batch using Ingres thru network (Via GCC) (There is
no database on that server).

It has been almost two weeks since this was posted to this list. Has anyone had time to look at that problem with segfault. IMHO this seems to be a serious bug in ingres
Rgrds
Kaspar Hioväin
-----Original Message-----

Take this sql...
Select id, surname, forename1, forename2

Where surname like 'SMITH%'

I have a problem that i'd like to solve more elegantly than calling an
external shell script.
We have a table that has the following: grouping_key,table_name
Each table in table_name has the same key associated with it, call it

Hi, Gurus.
(Our configuration: Ingres 2006 Version II 9.0.4 (int.w32/10500) on Windows Server 2003 R2 SP1)
After a crash, it seems that a lot of transactions were lost and that our main database comes back to its state at the moment of the last CP.
On restart, we find in the iircp ...

I need to include the DBA name as part of an SQL query in a report
in the query below I want to automatically insert the DBA name instead of
'$rel_owner'  ( is there a way of looking this up in a system table)
      select a.attname  , a.attid

What is the status of the Ingres Clustering Solution (or Grid Option,
as it seems to be called somewhere) on Linux?
In the Linux manual for 2006, they say that clustering is supported,
but that "iiquorumd" is required and "can be obtained from the Ingres

We are (still) running Ingres 2.5/0011 patch 7652 on HP-UX 11. Noticed some
time ago that the cache parameters are the default ones:
  .dmf_cache_size      .1688            
  .dmf_free_limit      .53              

We are logging the table level lock escalations in the errlog.log of
our Ingres DBMS systems.
This is without doubt a usefull source for debugging performance and
locking issues.

While doing unloaddb in Ingres2006 (9.0.1-116 ComEd) to get data from
Ingres 2.6sp2 I get:
E_US10E0 Configuration parameter DATE_TYPE_ALIAS is not found. Date
cannot be used as a valid data type name in this installation. Please

We are running Ingres 2.6/0305 p11013 on HP-UX 11i,
Currently all our systems run with II_THREAD_TYPE=INTERNAL
& iislave's because of stability issues in running Ingres in OS
Thread mode when we first upgraded to 2.6 a couple of years ago.

I'm looking some help on what would appear to be a trivial formatting
issue in report writer but has been bugging me for the last couple of
hours.  I looking to produce a report that has large numeric values.  By
default, Report Writer (RW) is converting these values into scientific

Ingres  Community Notice
<http://images.postsnet.com/729663988/ingr1157136539081.gif>    
Ingres Corporation  releases Ingres 2006 rls 2 Beta  
for the Windows x86 platform.

We are using Ingres2006 server and on the client a java applikation.
I want to handle the commit by myself. Is there a possibility to switch
off the autocmomit of the java application.
Does the connection parameter 'dbms' this?

Is there an Ingres adapter for Ruby on Rails?
I take it the answer is 'no'.  It is is not currently available for download
on the Ingres web site (see
http://www.ingres.com/products/Prod_Download_Drivers.html).