Operating System - HP-UX
1748008 Members
4750 Online
108757 Solutions
New Discussion юеВ

AutoRAID and Progress Database Performance issues

 
Francisco Lopez_2
Occasional Contributor

AutoRAID and Progress Database Performance issues

is there anyone using autoraid 12H for a Progress Database system
IT is the field to be
4 REPLIES 4
Brian M. Fisher
Honored Contributor

Re: AutoRAID and Progress Database Performance issues

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

Brian
<*(((>< er
Perception IS Reality
Jennifer Chiarelli
Regular Advisor

Re: AutoRAID and Progress Database Performance issues

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!
It's a binary world!
Emmanuel Eyer
Frequent Advisor

Re: AutoRAID and Progress Database Performance issues

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

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