Re: logical volumes/filesystems for db's on AIX

I tend to split off my large tables (10G+) into separate LV's, just to make them easier to maintain and move around to get more balanced I/O. To be honest, with IBM SSA drives starting at a minimum of 4.5G in size, either approach would work on jfs. It's just that if you allocate all the space to a big jfs up front you don't leave yourself with many options...

I tend to use raw LV's on AIX, all of 1G size to make things simpler to manage. Large LV's make me nervous when it comes to backup/restore/reallocation.

MotoX.

On Tue, 15 Dec 1998 09:16:33 -0600, Susan Malisch <susan.malisch_at_ctp.com> wrote:

>We are installing a large Oracle 7.3.4 implementation on AIX 4.3. If we
>have some tables that are going to be 5 - 10 gb in size, we're wondering
>if it's more beneficial to configure 2-4 logical volumes so that we can
>then mount the filesystems as multiple pieces? Or is it better to
>create one huge filesystem to accommodate the tables/groups of tables?
>We plan to stripe data across disks and mirror the data in a HACMP
>cascading configuration.
>
>I appreciate any insights on this. Please send any replies to me
>directly at smalis02_at_ctp.com as well as posting the reply so that I
>don't miss them.
>Thanks,
>Susan
Received on Tue Dec 15 1998 - 00:00:00 CET