I have a weird situation.  Three times in the past week the
sub-directories of the journal directory gets corrupted in some way -
causing the archiver to fail.
My journal directory is /jnl/ingres/jnl/default/dbnames

We have an Ingres 2.6 installation on a machine with a Solaris 5.8  OS. We
have developed some J2EE applications (deployed on another Solaris server)
which execute SQL statements directed to this database through Caribou
Lake's JDBC (JSQL). In some cases, the result of the SQL ...

I am using Ingres II on Solaris 2.6
I have increased my transaction log file from 1 Gb to 1.5 GB and since
then(what i can track down) the system is running running quite slow when
any inserts or updates are being done. The copy command is quite fast but

Hi. I'm putting together a stored procedure, and Ingres complains about
the line with the EXISTS clause. Is there a way to rewrite this, or is
this not possible in Ingres? I'm using R3beta BTW.
CREATE PROCEDURE P_Reserve_asset (username VARCHAR(20) NOT NULL, asset

I am trying to determine what the latest patch was for this Ingre
release.  A newsletter indicated PATCH 9601.  I cannot get to th
supportconnect site anymore.  Is there anyone else out there with thi
patch?

Just had a new installation and was looking into how it's performing - so I
thought Rational Commerce 30 second health check.
I run the script in sql to get the stats - but nothing gets produced, the
trace file is empty.

    I would like use integer typ for primary key.
What can I do automatically inserting sequence value when new row is
inserting ???
Thanks for help

When I run a 'ps -ef' command  or when I run a 'top' (Solaris 5.8), I always
see one 'iimerge' process (or more) that is loading the CPU too much. I
would like to know if exists some software, command, script, method, etc. to
know which SQL statements (or 4GL code) are included into ...

Can anyone please tell me how i can maximize a minimized window in openroad
The window is a child frame, that i have called with an OPENFRAME procedure

Ingres 4.6  on  HPUX 10.20
It have been working for a long time and don't have any problem before
today. Besides, We don't change any configurations recently.
I found one database couldn't be accessed and other databases works fine

I couldn't find an OS/Ingres compatibility matrix.
However, ftp://ftp.ca.com/caproducts/ingres/patch_by_platform.htm 
Should give you an idea of what version of Ingres runs on what OS.
************************************************************************

We have one Ingres 2.6 installation on a server which have the Caribou Lake
JDBC installed too. This server is having some throughput problems last days
because the ingres/Net service is hanging and I'm examining different
elements which are susceptible to hang the machine.

Is there a way to implement ON DELETE SET NULL (as I have seen in
Firebird), where if the row my FK points to is deleted the referring
row is not also deleted but the FK set to NULL instead? Can this be
done in a rule?

I'm looking to install Ingres 2.6 on AIX 5.1. We currently run on AIX 4.3.3
with a 32bit kernel. The new installation will require OpenROAD 4.1 to be
installed in the same installation so we are limited to the 32bit version of
Ingres 2.6 (there is no 64bit version of OpenROAD).