A particular SELECT query in ISQL takes less than 1 second to return
the results.
However when the same query is used to insert some data into a session
table in an ABF frame it takes over ten seconds.

Can somebody tell me what the meaning is of this error ?
(Ingres 2006 version on Linux)
E_OP04C0_NEWENUMFAILURE    Enhanced enumeration technique failed to find
valid query plan. Reverting  to old technique

How do I tell what users are involved in this deadlock?  I see 0c3f4100
but what users is causing this ?
NYFIPROD::[32786             , 0c3f4100]: Mon Sep 11 14:59:20 2006
E_DM905A_ROW_DEADLOCK        Deadlock encountered locking page 19, row

as we do some CBF settings on any customer's DBMS server, I have written
a batch file that works fine on Windows machines:
iisetres ii.%computername%.dbms.*.max_tuple_length 0
iisetres ii.%computername%.dbms.*.cursor_limit 36

Sorry,  
ING_SYSTEM_SET

I want to establish
"set lockmode on systable where readlock=exclusive" for both ingres
clients and JDBC sessions.  It seems the BEA's Weblogic can only send
one connection string at intialization time and that is already taken

As a part of a college work about distributed databases, I'm needing
some informations about Ingres.
I need some data on these areas:
* Authorization/authentication of users, in remote servers, referenced

I've been running some Ingres DBMS configurations (2.6 SP2 on HP-UX
Itanium) with dbms stack_size set to 512000.
The default stack_size is 65536. Does it harm not to use a multiple of
512000 ?

Is it possible to do a sum in a sub-query which is grouped and then use
that to update a value in the main query?
Not sure if I have explained myself very well so.....
The table below has the column 'amount' which I want to update

I tried to build ingres2006 on Ubuntu Server 6.06.... I could get it
almost working....
I got one main problem
...failed Link

We've been battling a deadlock problem in II2.6 for two weeks now.  We
are seeing page deadlocks on the index ( there's only one ) as well as
deadlocks on rows.  The table has row level locking and I understand
that the indexes are page level locking.

Hi guys...
First, don't be aggressive in your replays please.
I'm very impressed with the rich feature and good reputation of Ingres
in fields of Reliability, Distributed Databases and maturity....

Hi Michel
Shutdown the installation, move the current cooked log and cooked
dual logs aside (ie. just rename them to something) then execute
mkrawlog and mkrawlog -dual.

We are using INGRES for a number of years. I hve NOW started getting
the message (as I searched in the group justnow)
Can anyone explain to me in very short words why we are being pestered
   with the following messages. They are spooled into my errlog every

I've a production Ingres 2.6 instance with two databases, one of which
is archival and only updated once per week. I've trying to do some work
on the archival database, and one of my sessions has become stuck in
state CS_EVENT_WAIT (LKEVENT).