Hi Eric
Here my output (attach file) from the SQL statements in out TSM Server
Regards
Robert Ouzen
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J.
van - SPLXM
Sent: Thursday, April 07, 2005 12:57 PM
To: [email protected]
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.
**********************************************************************
ACTIVITY Date Objects Examined Up/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2005-03-08 903600
EXPIRATION 2005-03-09 511200
EXPIRATION 2005-03-10 640800
EXPIRATION 2005-03-12 846000
EXPIRATION 2005-03-13 522000
EXPIRATION 2005-03-14 306000
EXPIRATION 2005-03-15 1702800
EXPIRATION 2005-03-16 482400
EXPIRATION 2005-03-17 446400
EXPIRATION 2005-03-18 460800
EXPIRATION 2005-03-19 586800
EXPIRATION 2005-03-20 601200
EXPIRATION 2005-03-21 381600
EXPIRATION 2005-03-22 1659600
EXPIRATION 2005-03-23 579600
EXPIRATION 2005-03-24 522000
EXPIRATION 2005-03-25 637200
EXPIRATION 2005-03-26 648000
EXPIRATION 2005-03-27 669600
EXPIRATION 2005-03-28 2790000
EXPIRATION 2005-03-29 1677600
EXPIRATION 2005-03-29 9381600
EXPIRATION 2005-03-30 576000
EXPIRATION 2005-03-31 601200
EXPIRATION 2005-04-03 1137600
EXPIRATION 2005-04-04 1681200
EXPIRATION 2005-04-04 27086400
EXPIRATION 2005-04-05 1335600
EXPIRATION 2005-04-05 2120400
EXPIRATION 2005-04-06 586800
PCT_UTILIZED AVAIL_SPACE_MB
------------ --------------
46.3 50000
