Dear All,
Hello!!
I am seeking points to differentiate between the three OS's which are
AIX, Linux & HP-UX in terms of both technical approach and hardware required with a suggested DB integration.
I tried googling on the same but not much successful. Can you please let me know the points of difference between these three OS's? It will be of great help.

I was able to find the following points but need to add up more in with your help:

A) Hardware:
Linux: Can run on any hardware.
AIX: Must and can be installed on IBM hardware.
HP-UX: Must and can be installed on HP hardware only.

B) Filesystem:
Linux:
a. LVM is optional
b. Linux partition is mandatory to create PV and thereafter creation of LVM.
c. Can have more than one PV per disk.

AIX
a. LVM is mandatory
b. Every disk is automatically a PV.
c. One disk to one PV restriction.

HP-UX:
Searching

Thanks & Regards,
Deepesh

On Linux you do NOT have to partition to create an entire disk as a PV. There are reasons it is suggested that you do so however.
You do have to have partitions if you want to have multiple PVs from a disk. (But then the question is why are you doing LVM instead of just using partitions?)


HP-UX:
a. LVM is optional but is built in. Many people use Veritas Volume Manager (VxVM also known as part of Veritas Foundation Suite.)
b. No partitioning is require on HP-UX to make a disk a PV.
c. Can NOT have more than one PV per disk given you use the entire disk as the PV.
NOTE also in your research: HP-UX up until 2009 was mostly used on HP's PA-RISC chipset (HP-UX 11.21 and below). They introduced Intel Itanium with 11.22 and as of 2009 is only available on Itanium with the latest version being 11.3x). There are differences between the way things ran on the HP-UX PA-RISC servers (called RP-* after the introduction of Itanium) and the Itaniums known as RX-*.

Linux also offers meta-disks (software) RAID which can be used with partitions and with or without LVM.
HP-UX Veritas stuff (also seen in Solaris and available at a cost for Linux) also does software RAID.
HP-UX LVM mirroring (RAID 1) was an add on cost the last time I installed it.

For the most part your solution is going to be cheapest using Linux. The main reason to use AIX or HP-UX would be for specific workloads that are optimized for them OR for fault tolerance as they aim at high end installations these days.

Hello There!!!
Thank you very much for your prompt response.

Could you please add some more points related to the same which will differentiate them from each other?

Thanks & Regards,
Deepesh

You've already cited what to me is the most important difference:HP-UX and AIX are proprietary and can only run on specific hardware. As a result, they both are subject to the business needs of each of those manufacturers and can therefore contain non-standard forms of common commands as well as system structure.

As unofficial as it is, wikipedia has lots of information about both HP-UX and AIX and their current status. Plus you can review further information on both of those operating systems from the manufacturers' websites.

It might be helpful instead of just asking people to provide detailed overviews to instead indicate the specific information you're seeking, cite why you are seeking this information, and illustrate where you find either no information or a confusing mismatch of information.

HP-UX can use a variety of different file systems, and they have changed this over the years. Further, a lot of sources will cite that IBM and HP file systems, although stated to be something like JFS or some other common file system, it has been found that data from their systems is not always read-able on a different system even though that different system supports the same file system. For that I'd suggest you do some general web searching using the term: "hp-ux file system type"

"Why do you ask" about these differences? They should not matter.

If they do, then you have a XY Problem, where "You want to do X, and you think Y is the best way of doing so. Instead of asking about X, you ask about Y." Big mistake.

AIX, Linux, and HP/UX are all "somewhat Unix-compatible platforms," all three with very significant differences. If you have a particular "killer app" that your company wants/needs to run, then you should simply be purchasing "the appropriate hardware, and the OS appropriate to that hardware."