Gang,
Most of you know that the NAIUA website is an
aging repository for Ingres and OpenROAD information.
Caribou Lake has hosted the NAIUA website for

   When a connection is made to a database in my Ingres 2 installation I
see hundreds of shared page locks being taken on the iidbdb iidbpriv
catalog.   Connections are also quite slow taking between 0.5 and 2 seconds
to make.

When would you use destroy table over truncated and visa versa ?
We have a table with 20,000 rows and there is an application that
performs a destroy.  I would like to change that to a truncated so
other ingres accounts can empty out the table.

We have a C program with QUEL that starts up at the beginning of the
day and runs all day.  After a few hours of running we get the
following error:
ERlookup:  Error accessing message text:

Im trying to build up a string within a DBP and want add quotes to the
string.
I need to escape single quotes. Does anyone know how to do this?
I have tried \'string\' escape '\' and this doesnt work !

Gerhard,
This is HIGHLY UNADVISABLE.
Anyone who has network access to your servers can download Ingres, create a
vnode and connect as Ingres. Thus giving them the opportunity to cause

Yikes! I'm back on a project that had been put to sleep for a while,
and has now been woken up again....
converting a database and its ABF applications to run under Linux:
SUSE Linux Enterprise Server 9

Hi Colin,
Is it possible that you are connecting to an installation that does not have
an imadb?
The process of upgrading Ingres does not always create the imadb so

I'm trying to get Visual DBA to do what ipm / server list / sessions
does but sorted by database name so that if we have 300 different
transactions I don't have to eyeball the whole list looking for the
database I'm interested in

Here's some fun...
I have found the following problem on Ingres2006 +p11660.
If an sql terminal monitor session employs transcript logging with \script
[filename] and does not explicitly turn off the logging before the exit

News again - from Ingres Corp :-)
Press Releases
August 15, 2006
Ingres Introduces Project Icebreaker at Linuxworld San Francisco <http://www.ingres.com/news/2006-08-15_Icebreaker.html>  

how can I trace all queries that are sent to an Ingres II database ?
Thanks !

our customers run daily scheduled tasks or cron jobs to checkpoint their
databases.
The admin *should* control / ensure this every day:
1. have all databases been checkpointed?

We are trying ( using WebLogic ) to connection to ingres using JDBC
with a privileged user with the -u option.  The following connection
strings work but how/where can we insert the -u option so privileged
user 'joe' connects as 'jim' ?  jim has an ingres account but not an

in Ingres II, how can I know which temporary tables are currently existing
(name, session) ?
I create some temp tables with "DECLARE GLOBAL TEMPORARY TABLE"
and I want to make sure they disappear when my client crashes.