ACTIVITY                     Date                Objects Examined Up/Hr
------------------     ----------     ---------------------------------
EXPIRATION             2005-03-08                               1879200
EXPIRATION             2005-03-08                               2710800
EXPIRATION             2005-03-09                               1087200
EXPIRATION             2005-03-09                               1846800
EXPIRATION             2005-03-10                                698400
EXPIRATION             2005-03-10                                518400
EXPIRATION             2005-03-11                               1832400
EXPIRATION             2005-03-11                               2102400
EXPIRATION             2005-03-12                               1620000
EXPIRATION             2005-03-12                               3063600
EXPIRATION             2005-03-13                               2941200
EXPIRATION             2005-03-14                               1699200
EXPIRATION             2005-03-15                               1854000
EXPIRATION             2005-03-15                               2710800
EXPIRATION             2005-03-16                                961200
EXPIRATION             2005-03-16                               1846800
EXPIRATION             2005-03-17                                658800
EXPIRATION             2005-03-17                                676800
EXPIRATION             2005-03-18                                532800
EXPIRATION             2005-03-18                               1656000
EXPIRATION             2005-03-18                               2786400
EXPIRATION             2005-03-19                               1461600
EXPIRATION             2005-03-19                               3337200
EXPIRATION             2005-03-20                               2185200
EXPIRATION             2005-03-21                               1623600
EXPIRATION             2005-03-22                               1882800
EXPIRATION             2005-03-22                               2815200
EXPIRATION             2005-03-23                               1044000
EXPIRATION             2005-03-23                               1836000
EXPIRATION             2005-03-24                                644400
EXPIRATION             2005-03-24                                694800
EXPIRATION             2005-03-25                                583200
EXPIRATION             2005-03-25                               1702800
EXPIRATION             2005-03-26                               1738800
EXPIRATION             2005-03-26                               2937600
EXPIRATION             2005-03-27                               1562400
EXPIRATION             2005-03-28                               1926000
EXPIRATION             2005-03-29                               1659600
EXPIRATION             2005-03-29                               2581200
EXPIRATION             2005-03-30                                943200
EXPIRATION             2005-03-30                               1562400
EXPIRATION             2005-03-31                                626400
EXPIRATION             2005-03-31                                594000
EXPIRATION             2005-04-01                                536400
EXPIRATION             2005-04-01                               1378800
EXPIRATION             2005-04-01                               2466000
EXPIRATION             2005-04-02                               1782000
EXPIRATION             2005-04-02                               2912400
EXPIRATION             2005-04-03                               1836000
EXPIRATION             2005-04-04                               1681200
EXPIRATION             2005-04-05                               1386000
EXPIRATION             2005-04-05                               2761200
EXPIRATION             2005-04-06                               1108800
EXPIRATION             2005-04-06                               1699200

PCT_UTILIZED     AVAIL_SPACE_MB
------------     --------------
        73.5              33504

Phil Jones
Technical Specialist
United Biscuits

e-mail: phil_jones at biscuits dot com



                      "Loon, E.J. van -
                      SPLXM"                   To:       ADSM-L AT VM.MARIST 
DOT EDU
                      <Eric-van.Loon@KL        cc:
                      M.COM>                   Subject:  Help me convincing IBM 
please!!!!
                      Sent by: "ADSM:
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      07/04/2005 10:57
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






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 e-mail and any attachments are confidential and solely for the use of
the intended recipient.  They may contain material protected by legal
professional or other privilege. If you receive it in error, please delete
it from your system, make no copies of it, do not disclose its contents to
any third party or use it for your own or any other person's benefit.
Please advise the sender of its receipt as soon as possible. Although this
email and its attachments are believed to be free of any virus or other
defect, it is the responsibility of the recipient to ensure that they are
virus free and no responsibility is accepted by the company for any loss or
damage arising from receipt or use thereof. Any opinions expressed that do
not relate to the official business of the company are those of the author,
not the United Biscuits group of companies.
________________________________________________________________________________________