At your request
tsm: CEH>select pct_utilized, avail_space_mb from db

PCT_UTILIZED     AVAIL_SPACE_MB
------------     --------------
        88.6               7144

tsm: CEH>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 d         ays(end_time)-days(start_time)=0


ACTIVITY                     Date                Objects Examined Up/Hr
------------------     ----------     ---------------------------------
EXPIRATION             2005-03-12                               1940400
EXPIRATION             2005-03-13                               2858400
EXPIRATION             2005-03-14                               1821600
EXPIRATION             2005-03-15                               2660400
EXPIRATION             2005-03-16                               2775600
EXPIRATION             2005-03-17                               2052000
EXPIRATION             2005-03-18                               1753200
EXPIRATION             2005-03-19                               1987200
EXPIRATION             2005-03-20                               2610000
EXPIRATION             2005-03-21                               1652400
EXPIRATION             2005-03-22                               1396800
EXPIRATION             2005-03-23                               1512000
EXPIRATION             2005-03-24                               1760400
EXPIRATION             2005-03-25                               1886400
EXPIRATION             2005-03-26                               1807200
EXPIRATION             2005-03-27                               2174400
EXPIRATION             2005-03-28                               1710000
EXPIRATION             2005-03-29                               1846800
EXPIRATION             2005-03-30                               1839600
EXPIRATION             2005-03-31                               1299600
EXPIRATION             2005-04-01                               1861200
EXPIRATION             2005-04-02                               1652400
EXPIRATION             2005-04-03                               1652400
EXPIRATION             2005-04-04                               1760400
EXPIRATION             2005-04-05                               1710000
EXPIRATION             2005-04-06                               1555200
EXPIRATION             2005-04-07                               1666800
EXPIRATION             2005-04-08                               2556000
EXPIRATION             2005-04-09                               1926000
EXPIRATION             2005-04-10                               1965600
EXPIRATION             2005-04-11                               1645200




-----Mensaje original-----
De: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] En nombre de
William Boyer
Enviado el: jueves, 07 de abril de 2005 17:21
Para: ADSM-L AT VM.MARIST DOT EDU
Asunto: Re: Help me convincing IBM please!!!!

Good thing Eric asked " and send the output directly to me:
Eric-van.Loon AT klm DOT com:" or the list would be swamped with the replies!
:-)

Bill Boyer
"Some days you're the bug, some days you're the windshield" - ??
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Julian Armendariz
Sent: Thursday, April 07, 2005 11:19 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Help me convincing IBM please!!!!

>>> Eric-van.Loon AT KLM DOT COM 04/07 4:57 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.
**********************************************************************