The LVs may all be on the same physical disk, but they are not in the same
spot on the PV. The less time it takes for the read/write head to get
where it is going, the less time it takes to get your data. I would
suggest you partition your LVs in such a way that you can place your
hot tables on the center of these drives. You can specify that when you
create the LVs (inside, or outside of SMIT).
Also, you always want to separate your data and log onto different PVs if
possible. That way you can get something close to parallel writes for
logged transactions.
Good luck-
|>Newsgroups: comp.databases.sybase
|>Subject: Sybase devices and AIX logical volumes
|>Date: Mon, 22 Aug 1994 19:58:22 GMT
|>
|>Question that I don't think I've seen before.
|>
|>I have an RS/6000 running AIX 3.2.5. We have 2 1Gig drives and 2 2Gig
|>drives attached.
|>
|>My question is whether or not it makes sense to partition the 2Gig drives
|>into logical volumes of 300 MB or so, and let Sybase use these as database
|>devices?
|>
|>I mean after all, the logical volumes are all on the same physical
|>disk, so I should get the same performance as if I had just one big logical
|>volume that was used by Sybase for both data and log.
|>
|>Thanks,
|>Brian Glaeske
|>--
|>----------------------------------------------------------------------------
|>"Men Rule. Rap Sucks. Eat Fatty Food." The PIPC, Outland
|>
--
Sean Allen AIX/Database Administration
(919)543-6021 Fax 7996 IBM Personal Computer Company
Internal Zip: D318/B205 Research Triangle Park, NC 27709
by