I'm trying to upgrade a set of II2.0 and II2.5 installations to II2.6.
Fortunatly, I'm doing this on a test installation first....
I have found that the upgrade process clobbers all the netutil entries.
I suspect that that is why upgradedb cant manage to upgrade the

Kay/Martin,
The 'audstat' shell script from DBHygiene (a downloadable tool @ NAIUA) does
some nice reporting on the output from auditdb (including usage and hit
rates etc).

is it possible to run a semicolon-separated list of (non select)
statements against the JDBC driver? For example:
  alter table mytable addcol mycol1 varchar(1); alter table mytable
mycol2 varchar(1);

Gurus...  Is there any way (other than auditdb) to find what tables had
the highest activity on them from time a to time b?  I have been asked
to find this information and my database has been checkpointed 4 times
since the time period that is being requested.

trying to create a db procedure that will allow me to rename an existing
table.
Any idea what's wrong here?
Regards

I loaded data into a new database and during the optimizedb (-zk -zs20)
I get the following error:
E_OP094C Could not create table for sample data (sqlcode: -30200,
sqlerrd[0]: 2010).

Hi,
Simple question for Ingres-people, how to find rows from table where data contains linefeeds?
-Jouko

Even though I risk showing myself up as a dummy, I am encouraged by
those who I see have been helped by this group!
Hopefully you can help me too.
The story so far...

Hi Nagsy
Perhaps, as Paul warned yesterday, some ranges overlap?  That is, any one
number might belong to more than one range.
If that is the case, then one way around it is to get a distinct clause in

Nagsy,
Does this do the job?
select count (*)
from range r, numbers n

Hello fellow ingresers,
I missed this year's spring UKIUA, but I did get to hear about Ingres r4's
features from colleagues who did attend.
Ingres r4 features:-

You can use the +U flag when copying out the data.
sql +U fails if there are any sessions in the database:
E_US0014 Database not available at this time.
o The database may be marked inoperable.  This can occur if CREATEDB

I have a problem, hoping to get any ideas/help I can.  Let
me know what you think.  Thanks.
My problem is identifing non duplicate data, not based on a
specific row, but based on specific "sets" of rows (in this

Is there a procedure to create safe, transportable online backups? I
don't need cross-platform transportability (we're windows-only), but I
do need a backup snapshot that can easily be loaded in another Ingres
installation easily without much user interaction.

It sounds like the path is not pointing to your Ingres path or some
other path (maybe SQL Server), precedes the Ingres path where the
command 'sql' should be found. Place the Ingres paths as the first path
to be searched.