I am wondering if it is possible to use the 'DuplicateDB' tool in
VisualDBA on a database that you do not own.  I have tried without l
luck.
TIA, Ken

I'm running II 9.0.4 (a64.lnx/105)NPTL +patch12125
I created a new database the other day, no problems with the create
but a subsequent checkpoint of the database (its first) gave the errors...
   E_SC010D_DB_LOCATION Database Location Name: $default Physical

Is there any supported way to get the JDBC driver from Ingres 2006
working against the Ingres 2.6 DBMS. We'd quite like to use some of
the 3.0 features in our next release, but don't want the testing
overhead of upgrading the DBMS if we can help it.

When a table is partitioned using partitions hashed on a given column,
does that column have to be the only column in a where clause for the
optimizer to know which partition the data is stored in?  Or does the
optimizer scan the query looking for any column in the where clause ...

Using II 9.0.4 (hp2.us5/105)
What is the most efficient way to do the following?  TableA is btree
with col1, col2, col3 being the compound key and has about 12.5M rows of
data.  TableA is also compressed and stored across 3 locations if it

Tbl A contains the following distinct rows:
A|A1|A2|O
A|A1|A2|S
B|B1|B2|O

After upgrading from Ingres 2.6/0305 to Ingres 2.6/0604 SP5 for
Solaris 9 (after Jul 3 2007)
Ingres started crashing with SIGBUS and once with SIGBUS & SIGSEGV
errors on DMF.

Rational Commerce is rapidly expanding its Remote DBA and Managed Services
operation. We urgently require two highly experienced consultants with
strong Ingres DBA and Ingres system administration skills. Familiarity with
key Ingres-related technologies such as OpenROAD and ABF ...

Has anyone had experience of using SQLServer Reporting Services and
Ingres databases.  We have traditionally used Ingres (just completed the
upgrade to Ingres 2006), but a few years ago SQLServer was introduced
because we couldn't run some third party software on Ingres.

We were running on 6.4 for quite a while and then upgraded directly to
2.6.
In 6.4 ingres we could use the TZ env variable to determine what TZ
offset to apply to date types with time in them when displayed.  This

We're running 2006/Solaris. Is 2006r2 different to any real extent (backward compatible)?
Also, what's the POU (Pain Of Upgrade) factor?
Regards,

I have a "little" problem.
I have a directory containing all the files of a backup of an ingres
database in an older version but I've no running servers with that
version of ingres.

I'm using IMA to return various session information to generally keep an
eye on how well the system is running.
I was wondering if any one has used it to dump out info when a deadlock
is detected and what syntax you used e.g. select * from

I have an OSQ which has various fields and a table within it.  When
accessed the OSQ is opened as
SET_FORMS FIELD '' (mode(tbl)='READ');
- At this point 'before' and 'after' field activations on the