Hello

I am testing linux to migrate some informix IDS73 servers (currently windows
and SCO OSR5 environnement)

My linux informix that I got is a 7.31.UD2 version and I think this version
is very slow...slower than the SCO or windows 7.31 versions for the same
hardware and the same onconfig parameters.

Is there another 7.31 version (UD3 or more) ? I can't find any answer on the
ibm/informix website...

Do you know where can I download it for evaluation (free, I mean...) ?

Thank you for your answers

jba

quanrante.deux wrote:

> Hello
>
> I am testing linux to migrate some informix IDS73 servers (currently
> windows and SCO OSR5 environnement)
>
> My linux informix that I got is a 7.31.UD2 version and I think this
> version is very slow...slower than the SCO or windows 7.31 versions for
> the same hardware and the same onconfig parameters.
Check if DMA is set to on for the IDE disk (e.g. 'hdparm /dev/hda') and
check the type of filesystem where the dbspaces are located. Reiserfs is
known to be very slow with IDS.

Andreas


>
> Is there another 7.31 version (UD3 or more) ? I can't find any answer on
> the ibm/informix website...
>
> Do you know where can I download it for evaluation (free, I mean...) ?
>
> Thank you for your answers
>
> jba

"quanrante.deux" <quarante.deux@free.fr> wrote:

>My linux informix that I got is a 7.31.UD2 version and I think this version
>is very slow...slower than the SCO or windows 7.31 versions for the same
>hardware and the same onconfig parameters.

We've been using IDS 7.31.UD5 on Linux (SuSE 7.2) for almost a year now,
so your version is way outdated.

Have you checked the release and machine notes of your IDS release for
any kernel and onconfig parameters that might have to be adjusted? Are
you using raw disks on your system? Did you UPDATE STATISTICS after loading
your data onto the Linux system?

HTH, Richard



--
+-------------------------------+-------------------------------+
| Dr. med Richard Spitz | Tel : +49-89-7095-6110 |
| Klinik für Anaesthesiologie | FAX : +49-89-7095-6420 |
| Klinikum der Univ. München | Page: +49-89-7095-789-2116 |
| 81366 München, Germany | |
+-------------------------------+-------------------------------+

"Andreas Breitfeld" <abreitfe@de.ibm.com> a écrit dans le message de
news:c1v83i$pqg$1@gazette.almaden.ibm.com...
> > My linux informix that I got is a 7.31.UD2 version and I think this
> > version is very slow...slower than the SCO or windows 7.31 versions for
> > the same hardware and the same onconfig parameters.
> Check if DMA is set to on for the IDE disk (e.g. 'hdparm /dev/hda') and
> check the type of filesystem where the dbspaces are located. Reiserfs is
> known to be very slow with IDS.

only scsi disks are used...ext3 fs

"Richard Spitz" <Richard.Spitz@med.uni-muenchen.de> a écrit dans le message
news:<c0p640lmi51t4m25bvn10iqno1gstt8n5p@4ax.com>. ..

> "quanrante.deux" <quarante.deux@free.fr> wrote:

>

> >My linux informix that I got is a 7.31.UD2 version and I think this
version

> >is very slow...slower than the SCO or windows 7.31 versions for the same

> >hardware and the same onconfig parameters.

>

> We've been using IDS 7.31.UD5 on Linux (SuSE 7.2) for almost a year now,

> so your version is way outdated.

Hmm..it is the only I have...unfortunatly I have now no contract with
Informix/IBM

> Have you checked the release and machine notes of your IDS release for

> any kernel and onconfig parameters that might have to be adjusted?

I read the releases notes and I understood the kernel parameters of my linux
box seems to be okay...by default. (/proc/sys/shmmax /prox/sys/sem...)
but...the semaphores parameters remains "blur" for me...could you tell me
your kernel tuning ?



> you using raw disks on your system?

No, only cooked files...I tried raw devices once but with no more
performance

> Did you UPDATE STATISTICS after loading

> your data onto the Linux system?

Update statistics high...my databases have a mean size about 500-1024 mb

"Richard Spitz" <Richard.Spitz@med.uni-muenchen.de> a écrit dans le message
news:<c0p640lmi51t4m25bvn10iqno1gstt8n5p@4ax.com>. ..

> "quanrante.deux" <quarante.deux@free.fr> wrote:

>

> >My linux informix that I got is a 7.31.UD2 version and I think this
version

> >is very slow...slower than the SCO or windows 7.31 versions for the same

> >hardware and the same onconfig parameters.

>

> We've been using IDS 7.31.UD5 on Linux (SuSE 7.2) for almost a year now,

> so your version is way outdated.

Hmm..it is the only I have...unfortunatly I have now no contract with
Informix/IBM

> Have you checked the release and machine notes of your IDS release for

> any kernel and onconfig parameters that might have to be adjusted?

I read the releases notes and I understood the kernel parameters of my linux
box seems to be okay...by default. (/proc/sys/shmmax /prox/sys/sem...)
but...the semaphores parameters remains "blur" for me...could you tell me
your kernel tuning ?



> you using raw disks on your system?

No, only cooked files...I tried raw devices once but with no more
performance

> Did you UPDATE STATISTICS after loading

> your data onto the Linux system?

Update statistics high...my databases have a mean size about 500-1024 mb

"quarante-deux" <quarante.deux@free.fr> schrieb:

>I read the releases notes and I understood the kernel parameters of my linux
>box seems to be okay...by default. (/proc/sys/shmmax /prox/sys/sem...)
>but...the semaphores parameters remains "blur" for me...could you tell me
>your kernel tuning ?

Put the parameters from the release notes (IDS_7.3) into the file
"/etc/sysctl". This file is read on system startup and sets the
kernel parameters. This is what my file looks like:

kernel.shmmax = 33554432
kernel.shmmin = 1
kernel.shmmni = 128
kernel.shmseg = 128
kernel.semmni = 128
kernel.semmns = 4096
kernel.semmnu = 4096
kernel.semume = 32
kernel.semmsl = 100
kernel.semmab = 4096

HTH, Richard



--
+-------------------------------+-------------------------------+
| Dr. med Richard Spitz | Tel : +49-89-7095-6110 |
| Klinik für Anaesthesiologie | FAX : +49-89-7095-6420 |
| Klinikum der Univ. München | Page: +49-89-7095-789-2116 |
| 81366 München, Germany | |
+-------------------------------+-------------------------------+