ACTIVITY                     Date                Objects Examined Up/Hr
------------------     ----------
---------------------------------
EXPIRATION             2005-03-08
3600000
EXPIRATION             2005-03-09
3373200
EXPIRATION             2005-03-10
3412800
EXPIRATION             2005-03-11
2764800
EXPIRATION             2005-03-12
3448800
EXPIRATION             2005-03-13
5443200
EXPIRATION             2005-03-14
2426400
EXPIRATION             2005-03-15
4363200
EXPIRATION             2005-03-16
3333600
EXPIRATION             2005-03-17
4298400
EXPIRATION             2005-03-18
4161600
EXPIRATION             2005-03-19
4165200
EXPIRATION             2005-03-20
2869200
EXPIRATION             2005-03-21
2840400
EXPIRATION             2005-03-22
3265200
EXPIRATION             2005-03-23
3024000
EXPIRATION             2005-03-24
4143600
EXPIRATION             2005-03-25
3222000
EXPIRATION             2005-03-26
1965600
more...   (<ENTER> to continue, 'C' to cancel)

EXPIRATION             2005-03-27
3524400
EXPIRATION             2005-03-28
3420000
EXPIRATION             2005-03-29
3502800
EXPIRATION             2005-03-30
2754000
EXPIRATION             2005-03-31
3031200
EXPIRATION             2005-04-01
3081600
EXPIRATION             2005-04-02
2872800
EXPIRATION             2005-04-03
2980800
EXPIRATION             2005-04-04
3337200
EXPIRATION             2005-04-05
3409200
EXPIRATION             2005-04-06
2678400



tsm: BACKUP>select pct_utilized, avail_space_mb from db

PCT_UTILIZED     AVAIL_SPACE_MB
------------     --------------
        93.4              16628

Larry Clark
NYS THruway Authority


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