I'm using ingres 9.2.0.
As explained on
http://docs.ingres.com/sqlref/ExecuteProcedure#o1541
"Database procedures can be executed from interactive SQL (the

Has anyone had any joy getting data out of ima_cssampler_stats in imadb?  I
notice there's an ima_start_sampler procedure but neither that nor starting
sampling manually with iimonitor seems to produce any results in
ima_cssampler_stats.

I'm writting an small article in my high school, and the question of
the teacher is if Ingres have domains, like Firebird (create domain
integer... ).
Anyone can help me? I'm searching the Ingres docs, but I can't

Ok, Martin's reply regarding sc924 for tracing lock queries throwing
specific errors was news to me....
Does there exist a comprehensive listing of trace points and their
functions?  The only one I've found appears to have not been updated

Yes, you did read this post correctly! We have a system still running
Ingres 6.4(07).
Over the last couple of day we've seen the following messages in the
Ingres error log.

Does anyone know if there are any plans to introduce data encryption
into the database? I'm not talking about encryption on data in flight,
Ingres/Net can handle that quite adequately. What I want is to be able
to encrypt data when stored in the database and ensure that unless the

I have the following lock escalation in the errlog
E_DM9063_LK_TABLE_MAXLOCKS   Current logical lock count ( 101 ) on
resource big_bananas in database banana exceeds the specified maximum (
100 ). Escalating to table level lock.

Hi Gareth
How hot does the standby machine need to be?
Can it lag behind the primary server by a couple of minutes?
If so, log shipping may be the answer.

Hi group,
I am looking for an ABF debugger, and can see that NAIUA has this listed
under their membership area.
Does anybody know if  the group is still active (unable to open the

I was buying some odds and ends in an electronics store over the weekend and
noticed some deeply discounted ultra-small USB flash drives on sale, in 1Gb
and 2Gb capacity.  I couldn't resist.  I've also been playing around with
MojoPac recently.  All I needed to complete what I ...

Just a note to the group for anyone in Scotland or surrounding
locales ... there will be a meeting of the Scottish Ingres Users
Association in the Radisson SAS Hotel in Glasgow on Tuesday, the 4th
of December 2007. With a fortnight to go, we've almost completed the

Here's an oddity.  It doesn't look like overflow/wraparound.  I shall raise
it with tech support but the system hasn't misbehaved at all.
bigco-prod::ingres# sql bchd
INGRES TERMINAL MONITOR Copyright 2003 Ingres Corporation

I'm running II 9.0.4 (a64.lnx/105)NPTL +patch12343
I just got the following in the errlog....
E_OP0685_RESOLVE consistency check    - error resolving query tree node
ULE_FORMAT: Couldn't look up message b5e (reason: ER error 10903)

Weren't computers supposed to look like this:
http://www.vivisjournal.com/vivis_wine_notes/big_computer.gif
nowadays ?
-------- Original Message --------

We are migrating our apps from AIX to linux and need to use the same function
keys for the users. For some reason when setting TERM_INGRES to vt220 it does
not recognise F1 to F4 when running the ABF applications.
I don't wish to use another term setting like vt100f as I need the ...