ADSM-L

Re: [ADSM-L] 4 spindles for db: best performing setup

2009-02-19 09:32:18
Subject: Re: [ADSM-L] 4 spindles for db: best performing setup
From: Richard Rhodes <rrhodes AT FIRSTENERGYCORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 19 Feb 2009 09:29:20 -0500
>I'm more interested in what segment size people use on the disks and if
>a certain pp size is recommended for a volume group under AIX.

If you are creating filsystems or raw volumes down your spindles (ie:  NOT
pp extent stripping
across spindnes), the it really doesn't matter what pp size you use.  If
you setup pp stripping
across spindles, then I would probably stick with a 4mb or 8mb pp.  You
could even go with a 2mb
pp size, but  that can really slow down lvm and vg commands.

>From others comments, it seems tsm mirroring is favored over aix/lvm
mirroring.  if you choose
TSM mirroring, then I'd put 4 spindnes into 2 vg's of 2 spindles each.  I'd
then create a filesystem
or raw volumes in each vg that are extent  striped.

If you use aix mirroring, then I'd put all 4 drives into one vg of a 4mb or
8mb pp.  I'd
then create filesystem or raw volumes using extent stripping on 2 disks and
a mirror
copy on the other 2 disks.  When we use to do Oracle db's on jbod, this was
how
we set them up.

Rick






             Oscar Kolsteren
             <Oscar.Kolsteren@
             INGDIRECT.CO.UK>                                           To
             Sent by: "ADSM:           ADSM-L AT VM.MARIST DOT EDU
             Dist Stor                                                  cc
             Manager"
             <[email protected]                                     Subject
             .EDU>                     Re: 4 spindles for db: best
                                       performing setup

             02/19/2009 03:06
             AM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






Hi Michael,

I have a similar environment and created two RAID 0 lun's of 2 disks
each. The mirroring is done in TSM itself.

I'm more interested in what segment size people use on the disks and if
a certain pp size is recommended for a volume group under AIX.

Good luck


Best Regards,
Oscar


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Michael Green
Sent: 18 February 2009 20:23
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] 4 spindles for db: best performing setup

You are given 4 spindles to place TSM DB on them.
How would you set them up to squeeze maximum performance for DB?

1. Dedicate each spindle for a DBC (result: 3 DBCs, one spindle left
out, nevermind)
2. Create RAID 0 out of each pair of disks. Place a DBC on each RAID
(result: 2 DBCs on two separate RAID 0)
3. Create RAID 1 out of each pair of disks. Place a DBC on each RAID
(result: 2 DBCs on two separate RAID 1)
4. Create RAID 5 out of all spindles. Place one DBC on the RAID
(result: 1 DBC on RAID5)

Notes:
a. There is no RAID 0+1
c. Wasted space is not a concern
--
Warm regards,
Michael Green

************************************************************************
********************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the system manager.

This footnote also confirms that this email message has been swept
by an antivirus scanner for the presence of computer viruses.

ING Direct NV is a limited liability company incorporated in The
Netherlands. Registered in England & Wales, Branch Ref BR7357, 410
Thames Valley Park Drive, Reading, Berkshire, RG6 1RH.
************************************************************************
********************************************


---------------------------------------------------------------------------------------------------------------

ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you receive this
message by mistake, you are hereby notified that any disclosure,
reproduction, distribution or use of this message is strictly prohibited.
Please inform the sender by
reply transmission and delete the message without copying or opening it.

Messages and attachments are scanned for all viruses known. If this message
contains password-protected or encrypted attachments, the files have NOT
been scanned for viruses by the ING mail domain. Always scan attachments
before opening them.

ING Direct NV is limited liability company incorporated in The Netherlands.
Registered in England & Wales, Branch Ref BR7357, 410 Thames Valley Park
Drive, Reading, Berkshire, RG6 1RH.
---------------------------------------------------------------------------------------------------------------




-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If
the reader of this message is not the intended recipient or an
agent responsible for delivering it to the intended recipient, you
are hereby notified that you have received this document in error
and that any review, dissemination, distribution, or copying of
this message is strictly prohibited. If you have received this
communication in error, please notify us immediately, and delete
the original message.