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:[EMAIL PROTECTED] On Behalf Of
Loon, E.J. van - SPLXM
Sent: Thursday, April 07, 2005 4:57 AM
To: ADSM-L@VM.MARIST.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: [EMAIL PROTECTED]:
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.
**********************************************************************
