Hi all!



Recently we have upgraded from Ingres II 2.6 to Ingres 9.1.2 sp2 on a Tru64
5.1B pk4 platform.

Until now, we are experimenting so many problems, since optimizer issues til
random DBMS crash (consistency check follow with SIGSEV).

By now, we’re working with Ingres Corp people in order to solve all those
issues, but the path is very winding for us.



On the other hand, we’re working on the process of search and change our
tru64 primary platform, like as you know it will be an obsolete platform
soon.



Taking in hand our very bad experience with Tru64 and Ingres 9.1.2, I will
appreciate very much your comments about other robust platform that we can
consider (AIX, solaris, HP-UX, Linux …) to have a more smooth Ingres
experience.



Thank you very much for your help



Regards



Oscar





Lic. Oscar Carlés Barriocanal

ITIL V3 Certified

Director de Servicios

Íntegra SRL

(59521) 424473 RA

Asunción - Paraguay

On Aug 11, 2009, at 6:36 PM, Oscar Carlés wrote:

My personal order of preference is Solaris, Linux, AIX, HP-UX.
I do have to admit that I haven't had hands-on with an HP-UX
box for ages, so my opinion there is quite out of date.

I like Solaris SPARC the best; I haven't had much experience
with Solaris x86 but it ought to be solid as well. Linux is
another extremely stable Ingres platform; the only real issue
with Ingres on Linux (in my opinion) is choosing a filesystem
(I'd use XFS, or possibly a modified JFS. Ext3 is just OK.
I've not tried ext4 which is still very new. Unmodified
stock JFS is a disaster.)

AIX runs Ingres well and the ibm boxes are rock solid. I've
never been totally comfortable with AIX itself but that is a
personal preference. HP-UX used to be an internal threads
only platform but it's OS threads these days. I've never had
hands on with an OS threads HP-UX. I don't know how much of
a future HP-UX has, compared to the others.

This is all personal opinion, I don't have any numbers to back it
up with. All of these platforms are probably going to be more
stable than the tru64 port; Ingres seems to have a long history
of glitches on tru64. Not sure if it's the compiler or what.

Karl

Hi Oscar,

There are many users who have good experience of both Solaris and Linux.

I am aware that HP have provided one user in particular with hardware for Linux which is giving good service.



I will leave AIX and HP-UX users to sing the praises of those platforms, which I do not doubt they will do.

Cheers,

Michael



________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Oscar Carlés
Sent: 11 August 2009 23:36
To: 'Ingres and related product discussion forum'
Subject: [Info-Ingres] Ingres 9.x and migrating from Tru64



Hi all!



Recently we have upgraded from Ingres II 2.6 to Ingres 9.1.2 sp2 on a Tru64 5.1B pk4 platform.

Until now, we are experimenting so many problems, since optimizer issues til random DBMS crash (consistency check follow with SIGSEV).

By now, we're working with Ingres Corp people in order to solve all those issues, but the path is very winding for us.



On the other hand, we're working on the process of search and change our tru64 primary platform, like as you know it will be an obsolete platform soon.



Taking in hand our very bad experience with Tru64 and Ingres 9.1.2, I will appreciate very much your comments about other robust platform that we can consider (AIX, solaris, HP-UX, Linux ...) to have a more smooth Ingres experience.



Thank you very much for your help



Regards



Oscar





Lic. Oscar Carlés Barriocanal

ITIL V3 Certified

Director de Servicios

Íntegra SRL

(59521) 424473 RA

Asunción - Paraguay

Hi Oscar,



I have the same feeling than Karl and Michael about their preferred Unix platforms, except that I have also very good experiences with TRU64 on large installations 24/265.

This requires to configure accurately both the kernel and Ingres according to the available system resource and Ingres usage. Then it works over expectation !

The PK6 on 5.1.B is reliable and strongly recommended. I don't have enough feedback on PK7 to recommend it yet.



TRU64 stays one of the best UNIX from my point of view.

This is in no way intended to imply that I don't appreciate the other Unix flavours.



Cheers,

Oncle JL





From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Oscar Carlés
Sent: mercredi 12 août 2009 00:36
To: 'Ingres and related product discussion forum'
Subject: [Info-Ingres] Ingres 9.x and migrating from Tru64



Hi all!



Recently we have upgraded from Ingres II 2.6 to Ingres 9.1.2 sp2 on a Tru64 5.1B pk4 platform.

Until now, we are experimenting so many problems, since optimizer issues til random DBMS crash (consistency check follow with SIGSEV).

By now, we're working with Ingres Corp people in order to solve all those issues, but the path is very winding for us.



On the other hand, we're working on the process of search and change our tru64 primary platform, like as you know it will be an obsolete platform soon.



Taking in hand our very bad experience with Tru64 and Ingres 9.1.2, I will appreciate very much your comments about other robust platform that we can consider (AIX, solaris, HP-UX, Linux ...) to have a more smooth Ingres experience.



Thank you very much for your help



Regards



Oscar





Lic. Oscar Carlés Barriocanal

ITIL V3 Certified

Director de Servicios

Íntegra SRL

(59521) 424473 RA

Asunción - Paraguay

I meant 24/365

Thanks Michael

Cheers

JL



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Jean-Luc Hampton
Sent: mercredi 12 août 2009 10:44
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Ingres 9.x and migrating from Tru64



Hi Oscar,



I have the same feeling than Karl and Michael about their preferred Unix platforms, except that I have also very good experiences with TRU64 on large installations 24/265.

This requires to configure accurately both the kernel and Ingres according to the available system resource and Ingres usage. Then it works over expectation !

The PK6 on 5.1.B is reliable and strongly recommended. I don't have enough feedback on PK7 to recommend it yet.



TRU64 stays one of the best UNIX from my point of view.

This is in no way intended to imply that I don't appreciate the other Unix flavours.



Cheers,

Oncle JL





From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Oscar Carlés
Sent: mercredi 12 août 2009 00:36
To: 'Ingres and related product discussion forum'
Subject: [Info-Ingres] Ingres 9.x and migrating from Tru64



Hi all!



Recently we have upgraded from Ingres II 2.6 to Ingres 9.1.2 sp2 on a Tru64 5.1B pk4 platform.

Until now, we are experimenting so many problems, since optimizer issues til random DBMS crash (consistency check follow with SIGSEV).

By now, we're working with Ingres Corp people in order to solve all those issues, but the path is very winding for us.



On the other hand, we're working on the process of search and change our tru64 primary platform, like as you know it will be an obsolete platform soon.



Taking in hand our very bad experience with Tru64 and Ingres 9.1.2, I will appreciate very much your comments about other robust platform that we can consider (AIX, solaris, HP-UX, Linux ...) to have a more smooth Ingres experience.



Thank you very much for your help



Regards



Oscar





Lic. Oscar Carlés Barriocanal

ITIL V3 Certified

Director de Servicios

Íntegra SRL

(59521) 424473 RA

Asunción - Paraguay

I concur with Karl's recommendation. All the systems are good but I
find Solaris and Linux are also the most standards compatible. I have
always had the opinion that AIX and HP-UX have many gratuitous changes
to the OS that makes administration more difficult and limit the number
of useful available tools.


--
daryl.monge (AT) ingres (DOT) com
------------------------------------------------------------------------
daryl.monge (AT) ingres (DOT) com's Profile: http://community.ingres.com/forum/member.php?userid=736
View this thread: http://community.ingres.com/forum/sh...ad.php?t=11024

Thanks to all, I appreciate very much your opinions. They are very useful
for me.

I am also be glad to ear more details info about your personal experience
with Ingres, like:

* Actual version of Ingres that you use
* Operating System
* CPU
* RAM
* How many users/connections to DBMS
* Installation type, like 24x365
* Number of DBMS configured
* etc ...

Many thanks again!!

Regards

Oscar





-----Mensaje original-----
De: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] En nombre de Ingres
Forums
Enviado el: miércoles, 12 de agosto de 2009 09:17 a.m.
Para: info-ingres (AT) kettleriverconsulting (DOT) com
Asunto: Re: [Info-Ingres] Ingres 9.x and migrating from Tru64


I concur with Karl's recommendation. All the systems are good but I
find Solaris and Linux are also the most standards compatible. I have
always had the opinion that AIX and HP-UX have many gratuitous changes
to the OS that makes administration more difficult and limit the number
of useful available tools.


--
daryl.monge (AT) ingres (DOT) com
------------------------------------------------------------------------
daryl.monge (AT) ingres (DOT) com's Profile:
http://community.ingres.com/forum/member.php?userid=736
View this thread: http://community.ingres.com/forum/sh...ad.php?t=11024

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres

On Aug 12, 6:12*am, "Jean-Luc Hampton" <Jean-Luc.Hamp... (AT) ingres (DOT) com>
wrote:

I ran Ingres in various incarnations on HPUX for years. the issue
noted previously regarding "internal threads" occurred at HPUX 11.0,
where HPUX had threads, but they were POSIXly compliant. That's long
since been resolved.

For what its worth, I was able to run threaded IngresII on HPUX 11.0,
but it was extremely finicky about the number of write-behinds,
consistency point intervals and such.

Any of the current release of HP (11.23 / 11.31) should not be an
issue. I've never had issues w/ Linux installations, once I managed
to get them installed. Issues there seemed to revolve around X-Terms,
Ingres termcap files and Konsole, if I recall (its been while)

Hi Oscar,

We're still in the process of moving most of our applications from Tru64 to Linux.
I moved our databases from Tru64 (Ingres 2.6) to Linux Itanium (Ingres 9.1.1/NPTL) almost 2 years ago.

I have to admit, it was a bumpy road for a while. Performance wasn't very good until we went to posix threads.

BTW: We plan to test a Tru64 emulator that apparently runs on windows, go figure !


Andre

________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Oscar Carlés
Sent: August 11, 2009 6:36 PM
To: 'Ingres and related product discussion forum'
Subject: [Info-Ingres] Ingres 9.x and migrating from Tru64



Hi all!



Recently we have upgraded from Ingres II 2.6 to Ingres 9.1.2 sp2 on a Tru64 5.1B pk4 platform.

Until now, we are experimenting so many problems, since optimizer issues til random DBMS crash (consistency check follow with SIGSEV).

By now, we're working with Ingres Corp people in order to solve all those issues, but the path is very winding for us.



On the other hand, we're working on the process of search and change our tru64 primary platform, like as you know it will be an obsolete platform soon.



Taking in hand our very bad experience with Tru64 and Ingres 9.1.2, I will appreciate very much your comments about other robust platform that we can consider (AIX, solaris, HP-UX, Linux ...) to have a more smooth Ingres experience.



Thank you very much for your help



Regards



Oscar





Lic. Oscar Carlés Barriocanal

ITIL V3 Certified

Director de Servicios

Íntegra SRL

(59521) 424473 RA

Asunción - Paraguay

Ingres 9.1.1 (and maybe 9.1.2) is stable as Database-server on latest patches.

We have been in production on this since December 2007.



Although we're awaiting a newer patch for both 9.1.2 and 9.2.0 to resolve memory leak for nested select-loops.

Issue originally found and reported on 9.2.0 but now also ported to 9.1.2 (not on 9.1.1).



Like (this is just example no declaration supplied - main loop ends before all rows run)



Select table_name

From iitables

Begin

Callproc localproc()

End



Procedure localproc

Begin

Select column_name, datatype

From iicolumns

Begin

Message 'Column: ' + column_name + ':' + datatype

End

End



For Ingres on TRU64 please note the C-program for crashing reason for AXP.OSF on Ingres Support (TEC416280 Issue with strncmp).

HP has special fixes for both PK5 and PK6. Originally we got a fix for PK5 but it was still not fixed in PK6, so we got one for that as well.



Kind regards

Henrik Georg Sørensen, Organisator, Denmark

________________________________

Fra: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] På vegne af Laframboise, André
Sendt: 12. august 2009 20:09
Til: Ingres and related product discussion forum
Emne: Re: [Info-Ingres] Ingres 9.x and migrating from Tru64



Hi Oscar,



We're still in the process of moving most of our applications from Tru64 to Linux.

I moved our databases from Tru64 (Ingres 2.6) to Linux Itanium (Ingres 9.1.1/NPTL) almost 2 years ago.



I have to admit, it was a bumpy road for a while. Performance wasn't very good until we went to posix threads.



BTW: We plan to test a Tru64 emulator that apparently runs on windows, go figure !





Andre



________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Oscar Carlés
Sent: August 11, 2009 6:36 PM
To: 'Ingres and related product discussion forum'
Subject: [Info-Ingres] Ingres 9.x and migrating from Tru64

Hi all!



Recently we have upgraded from Ingres II 2.6 to Ingres 9.1.2 sp2 on a Tru64 5.1B pk4 platform.

Until now, we are experimenting so many problems, since optimizer issues til random DBMS crash (consistency check follow with SIGSEV).

By now, we're working with Ingres Corp people in order to solve all those issues, but the path is very winding for us.



On the other hand, we're working on the process of search and change our tru64 primary platform, like as you know it will be an obsolete platform soon.



Taking in hand our very bad experience with Tru64 and Ingres 9.1.2, I will appreciate very much your comments about other robust platform that we can consider (AIX, solaris, HP-UX, Linux ...) to have a more smooth Ingres experience.



Thank you very much for your help



Regards



Oscar





Lic. Oscar Carlés Barriocanal

ITIL V3 Certified

Director de Servicios

Íntegra SRL

(59521) 424473 RA

Asunción - Paraguay