Hi All, Try this...and yes it may crash the server... createdb bowtest sql bowtest << SQL_END

Martin Bowes

01-19-2010 07:59 AM
Martin Bowes

Hi All, I'm running two installations, both using II9.2.0+p13556. Call the two installations A and B. I'm using incremental recovery to keep...

Martin Bowes

01-18-2010 12:27 PM
Ingres Forums

The Middle East government of Jordan had signed a deal with open source database specialist Ingres to promote the use of open source software in the...

toby

01-17-2010 06:45 PM
toby

Apologies for not sending this out earlier. I hope to have the machine back up and running in the next hour. regards grant

Grant Croker

01-16-2010 04:27 AM
Grant Croker

http://www.cio.com/article/426363/An_Earthshaking_Use_of_Open_Source?taxonomyId=3000 Hope this time nobody need to be registred to view this article...

Jean-Pierre Zuate, La Fage Conseil

01-15-2010 03:05 PM
toby

Hi All, I currently have an open Issue with Ingres Corp. where the performance of several queries has degraded significantly since upgrading to 9.2...

rthdavid

01-15-2010 10:18 AM
Roy Hann

This is probably a string folding bug. Does the problem reproduce against the latest open source download? -- hanal04

Ingres Forums

01-13-2010 05:01 AM
Ian Kirkham

We are currently trying to make our code 100% compatible with Ingres Enterprise access for possible ports to non-Ingres databases. I have used to...

Colin Hay

01-11-2010 02:47 PM
Ingres Forums

Hi all For your knowledge, I have a Ingres 9.1.2 installed on HP Tru64 with p13615, that suppose to address bug 122755, but on Dec 29 I experimented...

Martin Bowes

01-07-2010 12:33 PM
Oscar Carlés

Hi All, Running II 9.2.0 (a64.lnx/143)NPTL + p13556 I've just had a server mutex all its connections waiting for a ULH Sem...whatever that is.

Martin Bowes

12-22-2009 08:07 AM
Martin Bowes

-------------------------------------------------------------------------------- driver. The preferred method there is to use ADODB as in Jamesb's...

Patrick

12-20-2009 06:26 AM
Jamesb

Hi Paul, Thanks for that. If the Cart-Prod forms you'll see it without data or stats. This seems more and more like a Linux thing as 9.2.0 on...

Martin Bowes

12-17-2009 04:27 AM
Martin Bowes

Hi All, We have a host on which we run an api program. When run interactively its fine, but when its run as a daemon process (under the same...

Martin Bowes

12-15-2009 06:57 AM
Martin Bowes

On Dec 14, 2009, at 8:55 AM, McCulloch, Stephen wrote: It's only derived from qsf_guideline, which is probably set to medium. You can set...

Betty & Karl Schendel

12-14-2009 10:08 AM
Roy Hann

Hi all, I'd like to give our customers (mostly non-techies...) an easy way to check: 1. are all databases checkpointed? 2. are all databases...

Gerhard Hofmann

12-10-2009 11:42 AM
Ingres Forums

I will be out of the office now until Monday 14th December, and will respond to your e-mail as soon as I can upon my return. If the matter is...

Rob Leather

12-05-2009 12:46 AM
Rob Leather

Dear all, A major update has been released for the Ruby driver and Ruby on Rails adapter for Ingres. Ruby Driver * Update the documentation using...

Grant Croker

12-03-2009 06:55 AM
Grant Croker

Hello, The following SELECT statement return 0 rows instead of one on ingres Solaris version 13351 1 II 9.0.4 (a64.sol/105) What can be the...

Wi¶niewski, Piotr, (ProService AT)

12-02-2009 06:16 AM
Ingres Forums

I think part 1 is a great idea. Having to generate stats using a separate process outside of the database has always been a nuisance. The sooner we...

lin.a.bradbrook@uk.bnpparibas.com

11-26-2009 08:51 AM
lin.a.bradbrook@uk.bnpparibas.com

Hi Gang, Well, I've gone and done it. I've actually written to Santa and asked him for an enhancement to Ingres! I'm usually quite skeptical about...

rthdavid

11-26-2009 08:40 AM
Karl Schendel

Hi Jim, It was hand generated. Tenacious little bugger isn't he. Marty -----Original Message----- From: info-ingres-bounces (AT)...

Martin Bowes

11-25-2009 10:19 PM
Gorby

Hi All, Up until a few seconds ago I thought the only if then else statement available was used only within a database procedure. However I've...

Martin Bowes

11-25-2009 07:24 AM
Martin Bowes

"human intelligence" is a contradiction in terms :-) JC

Jürgen Cappel

11-23-2009 10:01 PM
Jürgen Cappel

http://books.google.com/books?id=n89QAAAAMAAJ&printsec=frontcover&dq=ingres&lr=&ei=TR0FS8vOG5u-zgTgm_2sDg&hl=fr#v=onepage&q=&f=false :) -- Jean-Pierr...

Jean-Pierre Zuate, La Fage Conseil

11-23-2009 09:00 PM
James K. Lowden

Some information is missing from the Ingres entries for the Wikipedia article 'Comparison of relational database management...

Ingres Forums

11-23-2009 06:45 PM
Roy Hann

Hi Everyone, For those that might be interested, I did a talk at OSGeo's FOSS4G conference in Sydney last month. The video of my talk is posted...

2402

11-21-2009 01:39 PM
2402

On Nov 20, 2009, at 10:56 AM, Grant Croker wrote: That is TREMENDOUSLY clear. A wiki entry in the making. Thank you greatly, Mikey

Ingres Forums

11-20-2009 12:09 PM
Mike Leo

I did read that last week. But I've never trusted documentation. ;-) On Nov 20, 2009, at 3:23 AM, John Smedley wrote:

Mike Leo

11-20-2009 07:50 AM
Roy Hann

Hi, When I try to perform "duplicatedb" from igres visual DBA, I am getting the following error "No answer from RMCMD on the server. Please make...

Ingres Forums

11-20-2009 04:58 AM
Ingres Forums

for unloaddb: In Unix it is unload.ing / reload.ing In DOS is is unload.bat / reload.bat If you are copying from one database to another on the...

Ingres Forums

11-20-2009 04:53 AM
Ingres Forums

Suggest using unloaddb if an exact copy of the database is required (ie all user objects & system catalogs) On the source machine: c: md work cd...

David Stephens

11-19-2009 09:56 AM
David Stephens

Thanks Mike. From: info-ingres-bounces (AT) kettleriverconsulting (DOT) com On Behalf Of Michael Dyer Sent: 19 November 2009 12:55 To: Ingres...

Martin Bowes

11-19-2009 08:36 AM
Martin Bowes

Hi Marty, The release notes for the Ingres II 9.2.0 (int.w32) state: 2.0 Operating System Support The following operating systems are supported...

Michael Dyer

11-19-2009 07:55 AM
Michael Dyer

Hi All, But in ESD the only Ingres I can see for Windows is for windows-32.

Martin Bowes

11-19-2009 07:43 AM
Martin Bowes

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 10:35 AM
Mia

On Nov 18, 2009, at 9:42 AM, Paul White wrote: In the OP's situation, I am guessing that row compression will end up being the big win, in which...

Paul White

11-18-2009 10:05 AM
Karl Schendel

Hi All, I have a nice new virtaul host running Linux. I'm trying to install 9.2.0...I've done this many times before, but on this particular...

Martin Bowes

11-18-2009 09:27 AM
Martin Bowes

Add one more to the list. I've spent the last week and a half setting up Ingres 9.3. When I got to ABF and Report writer, I began to experience...

Roy Hann

11-16-2009 09:12 AM
Ingres Forums

Apart from hacking the scomplete flag in iistatistics is there a "respectable" way to clear the complete flag on an attribute? -- Roy UK Ingres...

Roy Hann

11-12-2009 09:39 AM
Roy Hann

Gang, There have been some problems with info-ingres the last few days. Turns out my "upstream" provider expanded their cluster and I had...

Mike Leo

11-10-2009 12:01 PM
Mike Leo

Hi everyone, The 451 Group is conducting an open source adoption survey. We’d like to ensure that the views of the Ingres community are...

Ingres Forums

11-10-2009 04:25 AM
Ingres Forums

I am looking at a problem with an ABF application that is being ported to 9.2/9.3 x86 64-bit Linux. There seems to be a problem with a couple of...

Roy Hann

11-09-2009 05:09 PM
Roy Hann

Hi Stephen The iimerge process is used for the Archiver, Recovery Server and DBMS Server(s). It's CPU usage will depend on the session activity you...

Ingres Forums

11-06-2009 04:12 AM
Ingres Forums

I feel a T-shirt coming on... http://rafaelperezillustration.com/2009/11/toad-and-ingres/ -- Roy UK Ingres User Association Conference 2010 will...

Roy Hann

11-06-2009 03:18 AM
Roy Hann

Ingres 9.2 with a new install sets opf_hash_join ON but if you upgrade the installation from Ingres 2.6 this setting is left off. Presumable to...

Robert Allely

11-06-2009 03:16 AM
Roy Hann

Hi All, The following query runs in 7 hours: insert into lab_result( sample_id, test_id, result, when_analysed, status, participant_id, visit_id

Martin Bowes

11-05-2009 09:54 AM
Martin Bowes

Here are some links with the same info and you don’t have to...

Paul White

11-05-2009 08:05 AM
Paul White

Hi All, Does anyone recognie this? In Ingres II 9.1.1 (a64.lnx/103)NPTL +p13001

Martin Bowes

11-05-2009 07:41 AM
Martin Bowes

http://www.ft.com/cms/s/0/653e8e88-c8ba-11de-8f9d-00144feabdc0.html?nclick_check=1 Français...

Jean-Pierre Zuate, La Fage Conseil

11-05-2009 07:31 AM
Jean-Pierre Zuate, La Fage Conseil

This is an actual problem in a manufacturing environment. An order goes to one and only one customer. An order will have products that are...

--CELKO--

10-29-2009 09:52 AM
--CELKO--