Solaris?  Which server version?  How many database volumes are there defined to
TSM?  How big are your database volumes?  Thanks!

Luke

"Remeta, Mark" wrote:

> I have a 40gb database on RAID5 with no performance issues.. fyi...
> not sure if you consider this small, average, or heavy.
>
> -----Original Message-----
> From: Zlatko Krastev/ACIT [mailto:acit AT ATTGLOBAL DOT NET]
> Sent: Wednesday, November 20, 2002 3:02 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Database Questions
>
> You can find long discussions on this topic in the list archives.
> - it is mostly disadvantageous to have more than one or two DB volumes per
> disk/array - parallelism you create with more volumes results disk heads
> moving back and forth. You are shooting yourself in the leg.
> - RAID 5 is definitely not very good for TSM DB and for average or
> heavy-loaded server might be disastrous for performance. For small servers
> might be just fine. Your server with 35 GB DB does not fit in second
> category.
> - "sessions running for hours" sounds terrible. What is DB cache hit
> ratio? Do you have DB volumes on Veritas filesystem?!?
>
> Zlatko Krastev
> IT Consultant
>
> Luke Dahl <ldahl AT JPL.NASA DOT GOV>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 07.11.2002 19:47
> Please respond to "ADSM: Dist Stor Manager"
>
>         To:     ADSM-L AT VM.MARIST DOT EDU
>         cc:
>         Subject:        Database Questions
>
> Does anyone know of any advantage/disadvantage of the file sizes for the
> database?  Is there an advantage to creating many 1Gb .db files over
> fewer 10Gb .db files?  Also, we're running TSM 4.2.1.15 on Solaris 5.8
> using raid 5.  I've heard performance can be much greater with raid 0.
> Any truth to that?  We're seeing load averages above 10 nearly every day
> and TSM performance is pretty poor.  Our database size is 35Gb and
> sessions are running for hours (even small incrementals of various
> workstations).  Network bandwidth hasn't peaked over 50% in any 24 hour
> duration.  Any thoughts?  Many thanks in advance.
>
> Luke Dahl
> NASA - Jet Propulsion Laboratory
> 818-354-7117
>
> Confidentiality Note: The information transmitted is intended only for the
> person or entity to whom or which it is addressed and may contain
> confidential and/or privileged material. Any review, retransmission,
> dissemination or other use of this information by persons or entities other
> than the intended recipient is prohibited. If you receive this in error,
> please delete this material immediately.