ADSM-L

Re: Help me convincing IBM please!!!!

2005-04-07 14:20:59
Subject: Re: Help me convincing IBM please!!!!
From: Jonathan Kaufman <jkaufman AT FOOTLOCKER DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 7 Apr 2005 13:23:40 -0500
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" <Eric-van.Loon AT KLM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04/07/2005 04:57 AM
Please respond to "ADSM: Dist Stor Manager"



        To:     ADSM-L AT VM.MARIST DOT 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: 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.
**********************************************************************

<Prev in Thread] Current Thread [Next in Thread>