Here you go...
Box #1
ACTIVITY Date Objects ExaminedUp/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2005-03-08 10180800
EXPIRATION 2005-03-09 5166000
EXPIRATION 2005-03-10 5241600
EXPIRATION 2005-03-11 7232400
EXPIRATION 2005-03-12 6948000
EXPIRATION 2005-03-13 9979200
EXPIRATION 2005-03-14 8906400
EXPIRATION 2005-03-15 8132400
EXPIRATION 2005-03-16 22597200
EXPIRATION 2005-03-17 4888800
EXPIRATION 2005-03-18 9399600
EXPIRATION 2005-03-19 5907600
EXPIRATION 2005-03-20 7812000
EXPIRATION 2005-03-21 12981600
EXPIRATION 2005-03-22 7732800
EXPIRATION 2005-03-23 9378000
EXPIRATION 2005-03-24 6433200
EXPIRATION 2005-03-25 10148400
EXPIRATION 2005-03-26 6253200
EXPIRATION 2005-03-27 8049600
EXPIRATION 2005-03-28 9277200
EXPIRATION 2005-03-29 7477200
EXPIRATION 2005-03-30 9648000
EXPIRATION 2005-03-31 4136400
EXPIRATION 2005-04-01 7722000
EXPIRATION 2005-04-02 6094800
EXPIRATION 2005-04-03 6976800
EXPIRATION 2005-04-04 7948800
EXPIRATION 2005-04-05 9561600
EXPIRATION 2005-04-06 9183600
EXPIRATION 2005-04-07 4993200
PCT_UTILIZED AVAIL_SPACE_MB
------------ --------------
30.8 18432
Box #2
ACTIVITY Date Objects ExaminedUp/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2005-03-08 273600
EXPIRATION 2005-03-09 388800
EXPIRATION 2005-03-11 133200
EXPIRATION 2005-03-11 176400
EXPIRATION 2005-03-12 216000
EXPIRATION 2005-03-13 327600
EXPIRATION 2005-03-14 21600
EXPIRATION 2005-03-16 252000
EXPIRATION 2005-03-18 309600
EXPIRATION 2005-03-20 331200
EXPIRATION 2005-03-22 108000
EXPIRATION 2005-03-24 252000
EXPIRATION 2005-03-25 482400
EXPIRATION 2005-03-27 432000
EXPIRATION 2005-03-29 183600
EXPIRATION 2005-03-30 320400
EXPIRATION 2005-03-31 352800
EXPIRATION 2005-04-01 334800
EXPIRATION 2005-04-02 331200
EXPIRATION 2005-04-03 360000
EXPIRATION 2005-04-04 223200
EXPIRATION 2005-04-05 349200
EXPIRATION 2005-04-06 399600
PCT_UTILIZED AVAIL_SPACE_MB
------------ --------------
60.5 20192
Jonathan Kaufman
Box #2 is an old s70, #1 is a much larger lpar on a 690
"Loon, E.J. van - SPLXM" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU>
04/07/2005 04:57 AM
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L@VM.MARIST.EDU
cc:
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.
**********************************************************************
