I want to create a 2.6 database from my Windows PC, residing on the
office network (the H: drive)
I create the location in accessdb
ii_cmt   H:\IngresII

I'm evaluating the Ingres DB (ingres2006-9.1.0) for a project where we
are planning to use it with Hibernate 3.2. I installed the server
software locally on my Windows XP system and I'm using the Jdbc Driver
V-9.1.0. Now I'm just trying to see how good this system works with

Is any free version of Ingres, which can be installed on Solaris 5.6
sparc ?
I had no problem with installation on Solaris newer than this (8, 9,
10), but this one crashes due to librt.so. This is a library delivered

I have a situation where every now and then tables with names like
'z496882808' get created in my STAR Co-ordinator databases. From
what I can tell these tables are being created on II2.6, IIR3 and
Ingres2006 installations at my site.

I asked a similar question can be seen here:
http://groups.google.com.au/group/comp.databases.ingres/browse_thread/thread/2e2
f9f85acde6b95/115b77cddc1866a6?hl=en#115b77cddc1866a6
I learned that "The ability to use a subquery in the FROM clause was
introduced in Ingres 2006 Release ...

Bulk Load Stratagies
Ok ok... I'm having a brain fart here.   (normal I know...)
One of the DBA's I work with is trying to reload about 1.2 mil rows
into a new table under VMS Ingres 2.0 and is encountering "force

The Danish version of ComputerWorld had an article about Open Source Alternatives with a link to
This Home Page "Open Source Alternative" www.osalt.com <http://www.osalt.com/>  so hurry and rate Ingres as the best Open Source Alternative,
And remember to rate Ingres with highest ...

Hi, is there any way to know which transactions, query, process, whatever..
is consuming all the resources of CPU?
Thank you in advance!

I have a query issue that is driving me crazy.
We are running II 2.6/0604 (su4.us5/00) on solaris 5.7.
We have a report that has run very quickly in the past. However it has
begun to stall in the CS_COMPUTIBLE state with no results. At first we

hey all
I,ve herited a company running all kind of databases. Now I need to
connect to a couple of then for some data retrieval. most of them have
OBDC or JDBc interfaces.

II 9.2.0 (int.lnx/108)NPTL
I created a table as a select * from another table and I noticed the new
table didn't have as many rows as the original table as shown in isql
help table or qbf table info.  If I do a select count(*) from the

I am facing a problem while fixing a table which is corrupted.
Before try to fix the problem (through verifydb), I want to secure the
data
by means either copydb -c option or create table as select * from option.

I have a strange performance problem with views.
The -relevant parts of the- used tables are:
################################################################################
Name:                 tableA

I a previous job I had at an Ingres site, in the 4GL code we use to put one
line macro labels that were expanded out to several lines of common code,
that would be visible in the final object code.
Being a raw graduate at the time, I didn't take much notice, but I am now