topic Re: AutoRAID and Progress Database Performance issues in Operating System - HP-UX

AutoRAID and Progress Database Performance issues

Francisco Lopez_2 — Tue, 11 Jul 2000 15:54:15 GMT

is there anyone using autoraid 12H for a Progress Database system

Re: AutoRAID and Progress Database Performance issues

Brian M. Fisher — Tue, 11 Jul 2000 16:41:46 GMT

We do not use our AutoRaids for Progress databases instead we use Oracle. Are there any specific problems/questions?

Brian
<*(((>< er

Re: AutoRAID and Progress Database Performance issues

Jennifer Chiarelli — Tue, 11 Jul 2000 17:32:38 GMT

I am not familiar with "AutoRaid 12H". But as I recall Progress is only compatible with raid level 0 or 1. And you must use the Progress backup routine!

Re: AutoRAID and Progress Database Performance issues

Emmanuel Eyer — Wed, 12 Jul 2000 06:14:57 GMT

To answer to Lanny: you probably mis-recall ;-) From HP-UX point of view, thus from the database point of view, data is on a disk device (either a filesystem or a raw device). This device could even be a Logical Volume, which in turn in on a disk device. In any case, what HP-UX sees as being a Physical Volume (the /dev/dsk/c0t5d2) is actually a SCSI LUN on the AutoRAID box (or another RAID box, such as the FC/30 or the FC/60). The LUN is spread on multiple disk mechanisms using a RAID scheme. But the operating system (and thus the applications) cannot "see" those disk mechs. Thus it does not care for it wether you are using RAID 0, RAID 1, or whatever.

Hope it helps, Emmanuel

Re: AutoRAID and Progress Database Performance issues

Andre van der Laarse — Thu, 13 Jul 2000 05:03:18 GMT

Hi,

We use Progress with the filesystems on the AutoRAID 12H, together with MC/ServiceGuard.
In the database there are put 1600 transactions per hour (smal records of about 132 characters long). There are nog problems with the disk access.
Only CPU was an issue, but now with 2 CPU's on our K370 it works fine.
Note that the AutoRAID 12H uses one SCSI interface as standard path. You have to make another LUN and define the alternate path different, see pvchange(1M), to get full benefit of two SCSI interfaces to your AutoRAID 12H.
Regards,
Andre van der Laarse