We have tables in our schema with columns of type VARCHAR, CHAR, TEXT
and C
If a join occurs between a column of type TEXT and a column of type
VARCHAR (or C and CHAR) does this mean casting occurs and indices may

Good morning,
Setup.
1/Unix server running Ingres 2.6. On solaris 9.
2/Image server running OpenROAD 4.1 on windows 2000. It uses a IngNet

Ingres SPARC SOLARIS Version II 2.6/0305 (su9.us5/00) login      
Has anyone had experience with this error...?
E_QE0258_ILLEGAL_XACT_STMT   A commit/abort/rollback was
attempted in a context where transaction

I am unable to kill two sessions that iimonitor marks them as:
cs_state: CS_COMPUTABLE cs_mask: CS_DEAD_MASK,CS_IRPENDING_MASK
I have tried:
- Kill them with ipm. After it, ipm informed that session was removed,

I was wondering what real-world uses there are for visual DBA?
I am thinking in terms of monitoring large, reasonably stable,
production systems, monitoring the dbms servers, acp, rcp processes
etc.

Gang,
For many years Caribou has hosted the NAIUA website.   The time
has come to renew the domain.
This puts Caribou at a crossroads.

Part of our batch work requires exclusive access to a livedb, so
we need a UNIX script to remove all user sessions from the database.
We currently have a script that runs iinamu to get the server id's
then iimonitor to get the session id's,

We have Ingres/Net running on a development server (HPUX 10.20) and we
need to access a production database running on a production server
(also HPUX 10.20) via ISQL.  However, the production server is behind
a firewall and we need to advise the security folks which port on the

Hi dudes,
I'm running IngresII2.6/0305 patch 9892 on a linux box.
A weekend process to modify tables in a database caused some
segmentation violations shown in the errlog. A subsequent attempt to

I'm getting an intermittent, non-reproduceable error when running the
copydb command. Example copydb command and error included below. An
integer overflow error is produced.
I have been able to show that this command can fail once, yet when the

Here's an interesting one.
Not being sure how Ingres handles LOBs, I started snooping around.
I noticed for long varchar, Ingres creates a catalog table to store
the actual data. Some cryptic table name i.e. iietab_77blabla.....

Hello World
I've recently installed Apache 2.0.54 and then installed ingres r3
3.0.2 using the ICE option. Has anyone managed to do this successfully?
Added the Include 'C:/ingres/r3/ingres/ice/bin/apache/ice.conf'

I am using Ingres R3 Open Source on W2K platform . My problem :
Boxes and Lines of Tables and Programs are not appearing
perfectly, Instead of some funny characters are appeared. I have
TERM_Ingres = IBMPC and IBMPCD also , but no use. Please help me

Does anyone know where I be able to view ukiua agenda? I've had
registration leter, but doing not know what will being happening.

If you set the connect_limit in CBF to 256 - do you really get 256
connections available to you, or are part of those used up by internal
system connections?  
Ii have Ingres II 2.0 patch 9599 on AIX.