I'm in the process of transferring a lot of STAR databases from an II2.6
platform on a physical host to an Ingres2006 platform on a virtual host.
Everything seemed to go very well but at the last hurdle my backup and
optimize scripts went nuts...A typical example being:

Does anyone know what the Relative Cost field in the statistics bar in
Visual SQL (Version 9.1.0) is reporting?  It doesn't seem to be the
server-side disk I/O cost because it doesn't agree with
dbmsinfo('_dio_cnt').  The on-line help leaves me none the wiser.

from OpenRoad applications, I know the possibility of running
 ingsetenv II_EMBED_SET printqry
to have all SQLs be written into a log file. Now I'm searching for a
similar method for JAVA/JDBC applications.

  How can I find the details of the connections to the database? I've
a server running and several users get connected through
programming... How can I know the IP address/host name of the client
machine connected to the server.

We have an intermittent problem in an overnight batch process, whereby
we can see an AMBIGUOUS REPLACE failure in a module that doesn't use
UPDATE FROM (or any aggregates).  It's an ABF procedure performing a
SELECT LOOP around a Session Temporary table, updating a different row

I was wondering if somebody had tried using ModPerl and IngresDBD or
Apache and IngresDBD in a Perl script. I keep getting this error in my
Apache error_log:
FEadfcb: II_SYSTEM IS NOT SET

I'm running a set of copydb commands to transfer databases from an old
installation to a new installation on a virtual host.
Generally this works perfectly fine. However, there is a small set of
databases which consistently refuse to copydb. A typical example is:

take 3
from www.jobserve.com, contract/perm, last 7 days (from 20/10/2007)
oracle          3202
"sql server"   3191

in the chktmp.def - the "universe" of values that can be substituted
for %B - how can it be known?
in the chktmpl.def (inherited) we have:
PSDD:   /bin/echo executing checkpoint to disk

is there any way to
SET NOLOGGING;
in a JDBC url like I can do in an isql session?
Regards

Is anyone familar with the 8GB limit of the checkpoint process? Is
this limited to HPUX?
is it limited to Ingres II (and corrected in Ingres 2006)?
in the event the checkpoint fails due to 8GB database limit/tar issue,

is it possible to change a nullable column to not-nullable with Ingres
2006's ALTER TABLE... ALTER COLUMN... command?
If yes, how would this look like?
Regards

Seen on Slashdot:
http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
That one, I didn't expect.  Dunno that it really
matters to the Ingres world, but it's interesting.

Today is a good day to remind yourself about your disaster recovery
procedures.
- where's last nights backup
- do the backup messages get checked every day

There is no problem with tar on solaris.
Problem lies in tar file specification, which ends on 8GB file.
You have to give additional flag to tar on solaris ('E') that makes it write
"extended headers" without size limit.