Loon, E.J. van - SPLXM wrote:
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.
**********************************************************************
Hoi Eric, from 2 servers, expiration runs in parralle on these servers,
both are on the same box:
tsm: KORB>select activity, cast ((end_time) as date) as "Date"
,(examined/cast((end_time-start_time) seconds as decimal(18,13)) *3600)
"Objects ExaminedUp/Hr" from summary where act
ivity='EXPIRATION' and days (end_time) -days(start_time)=0
ACTIVITY Date Objects ExaminedUp/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2005-03-08 766800
EXPIRATION 2005-03-09 882000
EXPIRATION 2005-03-10 475200
EXPIRATION 2005-03-11 475200
EXPIRATION 2005-03-12 406800
EXPIRATION 2005-03-13 554400
EXPIRATION 2005-03-14 676800
EXPIRATION 2005-03-15 1760400
EXPIRATION 2005-03-16 2318400
EXPIRATION 2005-03-17 1386000
EXPIRATION 2005-03-18 1501200
EXPIRATION 2005-03-19 1180800
EXPIRATION 2005-03-20 1400400
EXPIRATION 2005-03-21 1522800
EXPIRATION 2005-03-22 1530000
EXPIRATION 2005-03-23 1976400
EXPIRATION 2005-03-24 1202400
EXPIRATION 2005-03-25 993600
EXPIRATION 2005-03-26 1584000
EXPIRATION 2005-03-27 1443600
EXPIRATION 2005-03-28 1504800
EXPIRATION 2005-03-29 1620000
EXPIRATION 2005-03-30 1951200
EXPIRATION 2005-03-31 1260000
EXPIRATION 2005-04-01 892800
EXPIRATION 2005-04-02 1303200
EXPIRATION 2005-04-03 1472400
EXPIRATION 2005-04-04 1324800
EXPIRATION 2005-04-05 1836000
EXPIRATION 2005-04-06 1836000
EXPIRATION 2005-04-07 896400
tsm: KORB>select pct_utilized, avail_space_mb from db
PCT_UTILIZED AVAIL_SPACE_MB
------------ --------------
77.5 29752
---
tsm: BASKET>select pct_utilized, avail_space_mb from db
PCT_UTILIZED AVAIL_SPACE_MB
------------ --------------
85.9 221568
tsm: BASKET>select activity, cast ((end_time) as date) as "Date"
,(examined/cast((end_time-start_time) seconds as decimal(18,13)) *3600)
"Objects ExaminedUp/Hr" from summary where act
ivity='EXPIRATION' and days (end_time) -days(start_time)=0
ACTIVITY Date Objects ExaminedUp/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2005-03-08 324000
EXPIRATION 2005-03-09 392400
EXPIRATION 2005-03-10 108000
EXPIRATION 2005-03-10 306000
EXPIRATION 2005-03-11 0
EXPIRATION 2005-03-11 284400
EXPIRATION 2005-03-12 219600
EXPIRATION 2005-03-12 187200
EXPIRATION 2005-03-13 363600
EXPIRATION 2005-03-13 201600
EXPIRATION 2005-03-13 244800
EXPIRATION 2005-03-14 435600
EXPIRATION 2005-03-14 824400
EXPIRATION 2005-03-15 57600
EXPIRATION 2005-03-16 529200
EXPIRATION 2005-03-17 450000
EXPIRATION 2005-03-17 82800
EXPIRATION 2005-03-17 475200
EXPIRATION 2005-03-18 72000
EXPIRATION 2005-03-18 273600
EXPIRATION 2005-03-19 489600
EXPIRATION 2005-03-20 442800
EXPIRATION 2005-03-21 252000
EXPIRATION 2005-03-21 478800
EXPIRATION 2005-03-22 3600
EXPIRATION 2005-03-22 165600
EXPIRATION 2005-03-23 3600
EXPIRATION 2005-03-24 7200
EXPIRATION 2005-03-25 237600
EXPIRATION 2005-03-26 190800
EXPIRATION 2005-03-26 144000
EXPIRATION 2005-03-27 450000
EXPIRATION 2005-03-28 568800
EXPIRATION 2005-03-28 532800
EXPIRATION 2005-03-29 698400
EXPIRATION 2005-03-30 446400
EXPIRATION 2005-03-31 388800
EXPIRATION 2005-04-01 403200
EXPIRATION 2005-04-02 237600
EXPIRATION 2005-04-03 835200
EXPIRATION 2005-04-04 370800
EXPIRATION 2005-04-05 187200
EXPIRATION 2005-04-06 694800
--
Met vriendelijke groeten,
Remco Post
SARA - Reken- en Netwerkdiensten http://www.sara.nl
High Performance Computing Tel. +31 20 592 3000 Fax. +31 20 668 3167
"I really didn't foresee the Internet. But then, neither did the
computer industry. Not that that tells us very much of course - the
computer industry didn't even foresee that the century was going to
end." -- Douglas Adams
