ADSM-L

Re: Help me convincing IBM please!!!!

2005-04-07 13:20:48
Subject: Re: Help me convincing IBM please!!!!
From: "Dearman, Richard" <rdearm1 AT UIC DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 7 Apr 2005 12:13:58 -0500
ACTIVITY                     Date                Objects Examined Up/Hr
------------------     ----------     ---------------------------------
EXPIRATION             2005-03-08                                853200
EXPIRATION             2005-03-09                               1566000
EXPIRATION             2005-03-10                                558000
EXPIRATION             2005-03-11                                684000
EXPIRATION             2005-03-12                                907200
EXPIRATION             2005-03-13                               1483200
EXPIRATION             2005-03-14                                932400
EXPIRATION             2005-03-16                                774000
EXPIRATION             2005-03-17                               1706400
EXPIRATION             2005-03-18                                716400
EXPIRATION             2005-03-19                                982800
EXPIRATION             2005-03-20                               1490400
EXPIRATION             2005-03-21                               1015200
EXPIRATION             2005-03-22                               1224000
EXPIRATION             2005-03-23                               1515600
EXPIRATION             2005-03-24                                972000
EXPIRATION             2005-03-25                                831600
EXPIRATION             2005-03-26                               1677600
EXPIRATION             2005-03-27                                788400
EXPIRATION             2005-03-28                                748800
EXPIRATION             2005-03-29                               1612800
EXPIRATION             2005-03-30                                446400
EXPIRATION             2005-03-31                                799200
EXPIRATION             2005-04-01                                658800
EXPIRATION             2005-04-02                               1771200
EXPIRATION             2005-04-03                               1173600
EXPIRATION             2005-04-04                               1821600
EXPIRATION             2005-04-05                               1065600
EXPIRATION             2005-04-06                               1569600
EXPIRATION             2005-04-07                                709200

PCT_UTILIZED     AVAIL_SPACE_MB
------------     --------------
        73.9             100000


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Loon, E.J. van - SPLXM
Sent: Thursday, April 07, 2005 4:57 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Help me convincing IBM please!!!!

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.
**********************************************************************