Hi Carlos,

Between us only, because I can't promote any specific OS on this forum, due to my position.

The biggest Ingres installations I work on, are on HP-UX. The biggest one is on HP-UX 11.23, for 8000 actual sessions.

HP-UX was not very efficient with OS threads in the previous OS versions, (Tru64 was far more efficient in the past) now it's pretty well fixed.

At present I would advise HP-UX 11.31 with specific OS patches and fine Kernel and Ingres tunings.



I am not aware of so many big references with AIX, except one in Germany which reached kernel limitations (in shared memory) but all the "standard" installations I did and configured in Europe, run fine with a few hundreds of sessions.

Ingres works fine on AIX for medium size installations. I just don't really like the system administration spirit on AIX (smit). Supposed to be easy but it's not obvious in fact.



I would choose HP-UX for my system. About disk arrays, EVA technology is really great.

Cheers

JL









Jean-Luc Hampton

Senior Consultant

Ingres Corporation

Jean-Luc.Hampton (AT) Ingres (DOT) com <mailto:Jean-Luc.Hampton (AT) Ingres (DOT) com>



PHONE +33 (0) 1 72 75 74 52

MOBILE +33 (0) 6 14 11 95 07

FAX +33 (0) 1 72 75 74 51



www.ingres.com <http://www.ingres.com/>

IFrug

Ingres French Speaking user group

Ne manquez pas la rencontre du groupe utilisateurs Ingres,

Présentations, ateliers, rencontres.. Rejoignez-nous !

2 Octobre 2009, à l'occasion de l'Open World Forum à Paris.

Informations, programme ici <http://info.ingres.com/g/?S6YN1CBIKU:XS5LKBFINS=contactID:0,ssID:0,email:,c licksrc:ingres> .







&









This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.





From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Oscar Carlés
Sent: jeudi 1 octobre 2009 14:27
To: 'Ingres and related product discussion forum'
Subject: [Info-Ingres] Ingres 9.x, choosing platforms



Hi all!



We're in the process of changing our main Ingres platform, which is actually Alpha Servers with Tru64 Os.

Main players on this are IBM Power 6 with AIX OS and IBM Virtual Machines architecture and HP Itanium with HP-UX and HP Virtual Machines architecture.



I will appreciate your comments about experiences on these platforms and maybe some information about quantity of Ingres installations mounted on these kind of architecture around the globe.



Many thanks for your feedback



Regards





Lic. Oscar Carlés Barriocanal

ITIL V3 Certified

Director de Servicios

Íntegra SRL

(59521) 424473 RA

Asunción - Paraguay

On Oct 1, 2009, at 8:27 AM, Oscar Carlés wrote:

I personally like AIX a bit better than HP-UX, but it might simply be
that
I am more used to AIX. Both unix variants have their quirks. Ingres
used to
run better on AIX than on HP-UX, because of issues with HP-UX threading.
I believe that's all fixed now. Either platform would probably work
well for you.

Karl

I appreciate very much your comments.
I would like some comments, if you have experience, about using Virtual
Machines architecture on either both platforms.

Is there something about that? Or is it quite transparent for Ingres?

Thanks

Oscar


-----Mensaje original-----
De: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] En nombre de Karl
Schendel
Enviado el: viernes, 02 de octubre de 2009 05:10 p.m.
Para: Ingres and related product discussion forum
Asunto: Re: [Info-Ingres] Ingres 9.x, choosing platforms


On Oct 1, 2009, at 8:27 AM, Oscar Carlés wrote:

I personally like AIX a bit better than HP-UX, but it might simply be
that
I am more used to AIX. Both unix variants have their quirks. Ingres
used to
run better on AIX than on HP-UX, because of issues with HP-UX threading.
I believe that's all fixed now. Either platform would probably work
well for you.

Karl



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

It's absolutely transparent for Ingres.
Cheers,
JL



-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Oscar Carlés
Sent: vendredi 2 octobre 2009 23:48
To: 'Ingres and related product discussion forum'
Subject: Re: [Info-Ingres] Ingres 9.x, choosing platforms

I appreciate very much your comments.
I would like some comments, if you have experience, about using Virtual
Machines architecture on either both platforms.

Is there something about that? Or is it quite transparent for Ingres?

Thanks

Oscar


-----Mensaje original-----
De: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] En nombre de Karl
Schendel
Enviado el: viernes, 02 de octubre de 2009 05:10 p.m.
Para: Ingres and related product discussion forum
Asunto: Re: [Info-Ingres] Ingres 9.x, choosing platforms


On Oct 1, 2009, at 8:27 AM, Oscar Carlés wrote:

I personally like AIX a bit better than HP-UX, but it might simply be
that
I am more used to AIX. Both unix variants have their quirks. Ingres
used to
run better on AIX than on HP-UX, because of issues with HP-UX threading.
I believe that's all fixed now. Either platform would probably work
well for you.

Karl



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





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

It is absolutely transparent, but absolutely disastrous if
the VM solution doesn't have a well planned I/O strategy for
databases.

If you are using a SAN, don't put the Ingres areas on one big
SAN disk, no matter what the moron SAN sales idiot tells you.
No matter how many charts he gives you.

You need to make sure your SAN serves up dedicated sets of spindles
for Ingres only. DBMS servers have VASTLY different I/O characteristics
than file services.

SAN sales droids insist it doesn't matter. They are all idiots.

Michael Leo
Director of Managed Services
Kettle River Consulting

MLeo (AT) KettleRiverConsulting (DOT) com


On Oct 2, 2009, at 5:04 PM, Jean-Luc Hampton wrote:

On Oct 3, 6:11*am, Mike Leo <m... (AT) kettleriverconsulting (DOT) com> wrote:
Aladdin San ?

HI,

We were on Tru64 for along time (Ingres 2.6) but migrated to Suse Linux on Itanium (Ingres 9.1) when HP announced
they were pulling the plug on Tru64.

Our database is 2 TB with approx 700 concurrent users. Ingres runs fine on cheap hardware under a free OS

Andre

________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com on behalf of Jean-Luc Hampton
Sent: Fri 02/10/2009 5:03 PM
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Ingres 9.x, choosing platforms



Hi Carlos,

Between us only, because I can't promote any specific OS on this forum, due to my position.

The biggest Ingres installations I work on, are on HP-UX. The biggest one is on HP-UX 11.23, for 8000 actual sessions.

HP-UX was not very efficient with OS threads in the previous OS versions, (Tru64 was far more efficient in the past) now it's pretty well fixed.

At present I would advise HP-UX 11.31 with specific OS patches and fine Kernel and Ingres tunings.



I am not aware of so many big references with AIX, except one in Germany which reached kernel limitations (in shared memory) but all the "standard" installations I did and configured in Europe, run fine with a few hundreds of sessions.

Ingres works fine on AIX for medium size installations. I just don't really like the system administration spirit on AIX (smit). Supposed to be easy but it's not obvious in fact.



I would choose HP-UX for my system. About disk arrays, EVA technology is really great.

Cheers

JL





IngresLogo_Color<https://owa.lac-bac.gc.ca/exchange/andre.laframboise/Drafts/RE:%20%5BInfo-Ingres%5D%20Ingres%209.x,%20choosing%20platforms.E ML/1_multipart/image002.jpg>



Jean-Luc Hampton

Senior Consultant

Ingres Corporation

Jean-Luc.Hampton (AT) Ingres (DOT) com <mailto:Jean-Luc.Hampton (AT) Ingres (DOT) com>



PHONE +33 (0) 1 72 75 74 52

MOBILE +33 (0) 6 14 11 95 07

FAX +33 (0) 1 72 75 74 51



www.ingres.com <http://www.ingres.com/>

IFrug

Ingres French Speaking user group

Ne manquez pas la rencontre du groupe utilisateurs Ingres,

Présentations, ateliers, rencontres.. Rejoignez-nous !

2 Octobre 2009, à l'occasion de l'Open World Forum à Paris.

Informations, programme ici <http://info.ingres.com/g/?S6YN1CBIKU:XS5LKBFINS=contactID:0,ssID:0,email:,c licksrc:ingres> .





IngresLogo_Color.jpg<https://owa.lac-bac.gc.ca/exchange/andre.laframboise/Drafts/RE:%20%5BInfo-Ingres%5D%20Ingres%209.x,%20choosing%20platforms.E ML/1_multipart/image003.jpg>

&

Logo Communauté Ingres.jpg<https://owa.lac-bac.gc.ca/exchange/andre.laframboise/Drafts/RE:%20%5BInfo-Ingres%5D%20Ingres%209.x,%20choosing%20platforms.E ML/1_multipart/image004.jpg>







This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.





From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Oscar Carlés
Sent: jeudi 1 octobre 2009 14:27
To: 'Ingres and related product discussion forum'
Subject: [Info-Ingres] Ingres 9.x, choosing platforms



Hi all!



We're in the process of changing our main Ingres platform, which is actually Alpha Servers with Tru64 Os.

Main players on this are IBM Power 6 with AIX OS and IBM Virtual Machines architecture and HP Itanium with HP-UX and HP Virtual Machines architecture.



I will appreciate your comments about experiences on these platforms and maybe some information about quantity of Ingres installations mounted on these kind of architecture around the globe.



Many thanks for your feedback



Regards





Lic. Oscar Carlés Barriocanal

ITIL V3 Certified

Director de Servicios

Íntegra SRL

(59521) 424473 RA

Asunción - Paraguay