Here you go!
it is 2 CPU IBM 345, 2 years old,
database split in 4 database volumes over two raid-1 IBM-scsi arrays each,
10kRPM.
Both disks share half of 2GB logfile (in normal mode) as well,
disk one shares operating system W2K as well and disk 2 shares one seldom used
storage pool as well.
This might explain the big differencie among single results.
Regards
juraj
CT_UTILIZED AVAIL_SPACE_MB
----------- --------------
83.7 15000
ACTIVITY Date Objects Examined Up/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2003-10-13 1875600
EXPIRATION 2003-10-16 4474800
EXPIRATION 2003-10-20 860400
EXPIRATION 2003-10-24 1105200
EXPIRATION 2003-10-27 730800
EXPIRATION 2003-10-28 1612800
EXPIRATION 2003-10-28 4813200
EXPIRATION 2003-10-29 1681200
EXPIRATION 2003-10-30 1692000
EXPIRATION 2003-10-30 5090400
EXPIRATION 2003-10-31 1695600
EXPIRATION 2003-10-31 3906000
EXPIRATION 2003-11-03 1299600
EXPIRATION 2003-11-04 2239200
EXPIRATION 2003-11-05 1670400
EXPIRATION 2003-11-06 1638000
EXPIRATION 2003-11-07 1584000
EXPIRATION 2003-11-10 1274400
EXPIRATION 2003-11-10 3862800
EXPIRATION 2003-11-11 1706400
EXPIRATION 2003-11-12 1411200
EXPIRATION 2003-11-12 3672000
EXPIRATION 2003-11-13 1522800
EXPIRATION 2003-11-14 1580400
EXPIRATION 2003-11-17 1123200
EXPIRATION 2003-11-17 2520000
EXPIRATION 2003-11-18 1602000
> -----Ursprüngliche Nachricht-----
> Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im
> Auftrag von Loon, E.J. van - SPLXM
> Gesendet: Donnerstag, 07. April 2005 11:57
> An: ADSM-L AT VM.MARIST DOT EDU
> Betreff: 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.
> **********************************************************************
>
|