I've been following this thread all day.  Without running the script,
I know I am getting abround 2.5 million objects per hour examined
and it takes aboput 2.5 hours to run  expiration daily.  That's this
week.  Last week, it took about 8-10 hours to run expiration.

What's the difference?  Last week my DB was on a FAStT200HA
with 4 drawers of 73GB 10K disks.  This week it is on a
FAStT 600 Turbo with 4 drawers of 73GB 15K disks and the EXP710
drawers.  That is the only change,  Hint Hint!  The TSM Buffer pool
stayed the same size and my "Cache hit" pct was still 99% + in both
cases.  These disks systems are totally owned by one TSM server.

Forget what version of TSM and what CPU etc.  The very basics
of TSM tuning is the disks, especially the TSM DB volumes.  Split
them up over many disks and as fast as possible.  Unless you have a
really wimpy CPU or limited memory or something, disk is your
limiting factor.

As a bonus piece of info, I next moved my disk pools over to the
FAStT 600 also.  Now my migrations can feed my LTO1 tape drives at
maximum rate and my LTO2 drives real close.

Used RAID3 for disk pools on both FASTts and RAID0 for DB's.  (I
use the TSM DB Mirroring and use JFS filesystems on my AIX TSM server
for DB and disk pools.)  Had a few more disks to use for the DBVOLs
on new FAStT and increased the DB size, was 70GB now 80GB, 62% used.



David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5509
david.longo AT health-first DOT org


>>> Eric-van.Loon AT KLM DOT COM 04/07/2005 5:57:19 AM >>>
Hi *SM-ers!
Please help me with this and take the time to read this request!!!!

We're having serious performance problems with our TSM database. Part
of the
discussion with IBM is how expiration should perform.
A technical document on the TSM website stated that one should be able
to
expire 3.8 million objects per hour. As soon as I referred to this
document
("How to determine when disk tuning is needed") IBM removed it from
their
site!!!!
Expiration runs at a speed of 140.000 objects per hour in my shop an I
know
for sure that some of you are running at 3.8 million or more and I like
to
prove this to IBM.

I'm begging for your help with this. I would like to ask you to issue
the
following SQL statements on your TSM server(s) and send the output
directly
to me: Eric-van.Loon AT klm DOT com:

select activity, cast ((end_time) as date) as "Date" ,(examined/cast
((end_time-start_time) seconds as decimal(18,13)) *3600) "Objects
Examined
Up/Hr" from summary where activity='EXPIRATION' and days (end_time)
-days(start_time)=0

select pct_utilized, avail_space_mb from db

The first statement calculates your expiration performance
(objects/hour)
and the second one lists your database size and utilization.
Thank you VERY much for sending me your statistics in advance, I
REALLY
appreciate it!!!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee only. If
you are not the addressee, you are notified that no part of the e-mail
or any attachment may be disclosed, copied or distributed, and that any
other action related to this e-mail or attachment is strictly
prohibited, and may be unlawful. If you have received this e-mail by
error, please notify the sender immediately by return e-mail, and delete
this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its
subsidiaries and/or its employees shall not be liable for the incorrect
or incomplete transmission of this e-mail or any attachments, nor
responsible for any delay in receipt.
**********************************************************************

##############################################################
This message is for the named person's use only.  It may
contain confidential, proprietary, or legally privileged
information.  No confidentiality or privilege is waived or
lost by any mistransmission.  If you receive this message
in error, please immediately delete it and all copies of it
from your system, destroy any hard copies of it, and notify
the sender.  You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of this message
if you are not the intended recipient.  Health First reserves
the right to monitor all e-mail communications through its
networks.  Any views or opinions expressed in this message
are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of
a particular entity;  and (2) the sender is authorized by
the entity to give such views or opinions.
##############################################################