Hi Gary, I suspect that a lot of the constraints (part, UNIQUE and PRIMARY KEY) have to be seen as an implementation requirement by CA for Ingres to...

martin.bowes@ctsu.ox.ac.uk

03-21-2005 10:54 AM
martin.bowes@ctsu.ox.ac.uk

Ingres 2.6 on SunOS There is a SELECT statement of type SELECT.... UNION ALL SELECT.... UNION ALL SELECT.... UNION ALL SELECT...

Piotr.Wisniewski@breat.com.pl

03-21-2005 10:13 AM
Piotr.Wisniewski@breat.com.pl

Hi Frank, May not be necessary. Check to see what exactly failed - that should be the next line in the errlog. I may just be a single component that...

martin.bowes@ctsu.ox.ac.uk

03-21-2005 09:38 AM
martin.bowes@ctsu.ox.ac.uk

Linux: Fedora Core release 3 (Heidelberg) Kernel 2.6.10-1.770_FC3 on an i686 Ingres: II 3.0.1 (int.lnx/109) Apache: 2.0 Perl: v5.8.5 This isn't...

Dennis Roesler

03-21-2005 09:35 AM
Dennis Roesler

You can use COPYDB to extract the SQL statements to create tables or views, but not, apparently to extract the SQL statements to create just the...

Tim Ellis

03-21-2005 09:29 AM
Tim Ellis

Hi all, There are some error messages in errlog.log : Sun Mar 20 23:22:09 2005 E_DMA469_PROC ESS_HAS_DIED Process (0000198D) has died. A process...

Frank Fan

03-21-2005 07:23 AM
Frank Fan

Hi Dudes, Given that I have 4k cache configured. and that the max_tuple_length is set to zero. Why can't I set the width of a not null not default...

martin.bowes@ctsu.ox.ac.uk

03-21-2005 04:00 AM
martin.bowes@ctsu.ox.ac.uk

You cannot do this on 2.5 (at least that I can see). You can do it on R3. I don't know about 2.6. You could check the manual if you need to...

Simon Lovell

03-20-2005 08:29 PM
Simon Lovell

I would suggest exporting II_SYSTEM, PATH and LD_LIBRARY_PATH in apachetl script from the bin directory of your Apache installation. In httpd.conf...

Armand Pirvu \(yahoo\)

03-18-2005 06:25 PM
Armand Pirvu \(yahoo\)

Hey all, I've heard through the grapevine that a varchar is not an appropriate data type for a column that is a key column, or one that is heavily...

Grant Wolcott

03-18-2005 12:13 PM
Roy Hann

Thanks for all those who replied. As Roy suggested it's the different column types (bug 109134, problem INGSRV 2001) I'm going to be setting all...

Gareth Williams

03-18-2005 11:28 AM
Gareth Williams

II 2.6/0305 (su9.us5/00) 10626 ok... can someone explain this to me... select * from clinic_diary a, clinic_look_up b where b.master_clinic_code =...

Gareth Williams

03-18-2005 09:13 AM
Peter Gale

Hi Dudes, I've been asked the following question by one of our programmers. And not knowing anything about it - I thought I'd share... Martin...

martin.bowes@ctsu.ox.ac.uk

03-18-2005 05:58 AM
martin.bowes@ctsu.ox.ac.uk

Hi Frank, By default, ingstop will detect that users are still connected to the DBMS Server and pause, wait a bit, then if they are still...

martin.bowes@ctsu.ox.ac.uk

03-18-2005 05:26 AM
martin.bowes@ctsu.ox.ac.uk

Hi all What will happen when you run ingstop if some sessions was still exist? There are error messge below when I run ingtop, I guess some ingres...

Frank Fan

03-18-2005 04:31 AM
Frank Fan

We are looking at upgrading our version of Ingres from 2.0 to 2.6 on Solaris (due to the drop of support). Does anybody know of any issues...

Wilding, Gregory

03-17-2005 08:52 PM
Paul White

Gang, Working with one of our clients, we have discovered that Ingres r3 online checkpoints on Linux (RH Enterprise 3.0, supported) can occasionally...

Michael Leo

03-16-2005 08:40 PM
Karl & Betty Schendel

I am looking for something like Upfront. I found it on the net - I wasn't sure if it was still around, and have downloaded the trial. My question...

Rob McKenzie

03-16-2005 11:35 AM
Rob McKenzie

I've been trying to use the IMA objects to immediately identify who's holding locks other need. It's seems the example in the 2.6 manual entitled...

Gareth Williams

03-16-2005 10:18 AM
Armand Pirvu

Anyone know how to retrieve a query execution plan without actually executing the query? Cheers Gareth Cymraeg:- Mae'r neges hon yn gyfrinachol.Os...

Gareth Williams

03-16-2005 09:34 AM
Victor Godgelf

Hi Gareth, Set optimizeonly; Set qep; <Query statement>; HTH. Leandro Fava DBA

Leandro Pinto Fava

03-16-2005 09:32 AM
Leandro Pinto Fava

Hi Dudes, II2.5/0011 patch 9563. Can anyone explain the significance of the following messages from iircp.log: !Tue Mar 15 20:45:24 2005 Reducing...

martin.bowes@ctsu.ox.ac.uk

03-16-2005 07:33 AM
martin.bowes@ctsu.ox.ac.uk

Hello. We use old 6.4 Windows client for our Vision application. Works fine, but we would like to move clients to R3. Problem is that aplication...

Zdenko Rohac

03-15-2005 04:45 AM
Zdenko Rohac

Hi all, which patch level do you use for this Ingres release? According to CA's FTP site, 9053 is the latest "offical" one. We have deployed p9053...

Gerhard Hofmann

03-11-2005 08:51 AM
Gerhard Hofmann

Hi all, can anybody here share his or her experiences with clustered Ingres installations on Linux? One of our customers wants to setup an...

Gerhard Hofmann

03-11-2005 05:02 AM
Gerhard Hofmann

P.S The above occurs at the following configuration - as propted by Ingres: INGRES TERMINAL MONITOR Copyright (c) 1981, 2000 Computer Associates...

Hillel Eilat

03-10-2005 12:35 PM
Hillel Eilat

Hello Everybody My application uses OPENapi interface to interact with OpenIngres. First it does some internal settings and connects, involving...

Hillel Eilat

03-10-2005 12:30 PM
Hillel Eilat

Version: II 2.6/0305 (hpb.us5/00) OS: HP-UX 11.11 We have an abf application that does session switching through an esqlc procedure. When it tries...

Dennis Roesler

03-10-2005 11:24 AM
Dennis Roesler

John, system had been running ok till this morning when it crashed again. same set of errors though on a different table this time. While the...

Goodchild, Zoe

03-09-2005 09:19 AM
Goodchild, Zoe

Hi Dudes, II2.5/0011 patch9563 on axp.osf/00 I've tried to unload a STAR Distributed database with: unloaddb -c -ulust test_ldb1_ddb/star and...

martin.bowes@ctsu.ox.ac.uk

03-09-2005 04:52 AM
martin.bowes@ctsu.ox.ac.uk

I have raised an internal support call to get this resolved I cannot promise when it will be running "normally" again. Regards, grant

Croker, Grant

03-09-2005 04:49 AM
Croker, Grant

Hi Frank, There are a couple of possibilities. 1. Ensure the user environment does not have a variable II_DBMS_SERVER defined. 2. Ensure the...

martin.bowes@ctsu.ox.ac.uk

03-09-2005 04:07 AM
Frank Fan

Hi all There is a table called std_info which get data from a session temporary table and was created successfully , while it has a error...

Frank Fan

03-09-2005 04:05 AM
Frank Fan

Anyone else having problems??

Rainman

03-09-2005 03:01 AM
Zdenko Rohac

At 5:47 PM -0400 3/8/2005, David G. Brooks wrote: This is usually an LD_LIBRARY_PATH foul-up. The Solaris build for r3 is a hybrid; it has both...

Karl & Betty Schendel

03-08-2005 05:07 PM
Karl & Betty Schendel

Hi all, Ingres 2.6 HP 11.11 Ingres is the DBA account and it could run 'sql db1' successfully. Another ingres user called testuser has the same...

Frank Fan

03-08-2005 03:51 AM
Frank Fan

Hi Dudes, Its a little off topic, but.... This Saturday, my Tigers are playing the Lions at Octupus Oval. And I'm stuck in Oxford....My stiff...

martin.bowes@ctsu.ox.ac.uk

03-08-2005 03:44 AM
martin.bowes@ctsu.ox.ac.uk

I read a article which was attached below and wonder if I should configure number of log writers while I don't find the parameter in CBF. BTW,...

Frank Fan

03-08-2005 03:43 AM
Frank Fan

Hi All, We have a ABF application which works fine in ingres 6.4 on HP 10.20. The application include esqlc scripts. We run imageapp to produce a...

Frank Fan

03-08-2005 12:35 AM
Frank Fan

Below is a iiprtqry.log fragment from eod processing: Log file: Query Response Time: Thu Mar 3 21:27:29 2005 time=54 seconds Query...

Piotr.Wisniewski@breat.com.pl

03-07-2005 12:02 PM
Artur Fajok

Jim, Agreed that Java has some good points which are not present in OpenROAD. Probably the best ones are parameters which are validated at compile...

Simon Lovell

03-07-2005 05:24 AM
Neil Warnock

Hi all, ingres 2.6 /0305 HP 11.11 There are some error messages below in errlog.log when I start ingres. ingres was not start successfully. I...

Frank Fan

03-06-2005 09:53 PM
Frank Fan

I wrote some stuff for Ingres using MS .NET. And it was a nice and smooth ride. There are wizards in .NET. For the Ingres .NET adapter , you have to...

Armand Pirvu \(yahoo\)

03-05-2005 02:19 PM
Armand Pirvu \(yahoo\)

If anyone has tried to develop some aplication in ingres using Ms .net platform?? My boss wants me to do it but I have to first gather...

deemer

03-05-2005 01:49 PM
Emiliano

Gang, A few users have reported this to me. It is very odd that only a few users have seen these old messages come through. There was a change to...

Michael Leo

03-04-2005 02:03 PM
Winkler, Teisha

Simon, I found this interesting as I'm starting to do a bit of Java myself. From what I've found so far it has good and bad points, just like any...

Antill, Jim

03-04-2005 01:02 PM
Dennis Adams

Folks, Any idea why each message is coming in the mail at least 4 times ? Thanks, Armand

Armand Pirvu

03-04-2005 01:18 AM
Peter Gale

Sorry gang, Wojtek's email was an old one. Looks like the ingres news server has gone crazy transmitting old emails. Michael Leo is working on...

Paul White

03-03-2005 06:43 PM
Paul White

Is anyone else on the list getting these old emails? They're all dated Nov 2003! I've gotten a few dozen so far, one of which was originally my...

Michael Kiely

03-03-2005 05:05 PM
Michael Kiely

Ingres doesnt run on xp home, windows ME or 98. You can have ingres net, openroad, etc but not the database. Paul -----Original Message----- From:...

Paul White

03-03-2005 04:32 PM
Paul White