ADSM-L

Re: [ADSM-L] DBUnload, need for speed

2012-06-28 09:07:56
Subject: Re: [ADSM-L] DBUnload, need for speed
From: "Loon, EJ van - SPLXO" <Eric-van.Loon AT KLM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 28 Jun 2012 14:59:39 +0200
Hi Oscar!
Money and resources. The P-Series server currently used hasn't got the
resources (CPU and memory) to run version 6. In the past we decided to
install TSM on a frame along with other servers. The frame is currently
full, so if we want more resources for TSM, we will have to move other
servers from this frame to other frames. This is a difficult and costly
operation, mainly since a lot of our services require a 24*7
availability.
Money is also a BIG issue in our shop, maybe you already heard about the
airline business: these are not the best of times for us...
Kind regards,
Eric van Loon

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Oscar Kolsteren
Sent: woensdag 27 juni 2012 17:40
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: DBUnload, need for speed

Hi Eric,

What's holding you back from upgrading to version 6?

Maybe the upgrade will take as long as unloading/loading but you're in a
better position than staying on 5.5.

Groetjes,
Oscar
Butterfly Software Limited

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Loon, EJ van - SPLXO
Sent: 27 June 2012 14:23
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] DBUnload, need for speed

Hi TSM-ers!
My TSM databases are running for quite a while (since 4.1) and they are
becoming rather fragmented, one of them more that 25%! It becomes
noticeable too, expiration is running longer and longer.
Our TSM servers are all running in AIX 5.3 on a P-series 570, SAN
attached
to a VMAX (OS, DB and LOG) and VNX (diskpool) storage subsystem and two
EMC DL4106 DiskLibraries (VTS without physical tapes).
Unloading the smallest (95 Gb) database takes about 7 hours, loading it
takes about 3.5 hours. These tests are perform with a live database copy
on our test environment. Overall it takes too long to do this on our
live
environment.
I tried several scenarios: multiple filesystems, RAW lv's, cio/dio
mounted
filesystems, multiple database volumes on multiple filesystems,
everything
you can think of, but there's only a small gain in using multiple
volumes
on dio mounted filesystems, the rest is marginal or even worse.
The first part of the unload is running very fast (4 or even 5 million
entries per minute, but at a given point performance drops dramatically.
It's always at the same point (around 80%), so my guess is that that's
the
most heavily fragmented part.
The only thing I can think of to speed up the process is to use a
storage
device with a very low latency, like SSD, but unfortunately that's not
supported on the P5 series...
Does anybody have some additional tips I can try?
Thanks for your reply in advance!
Kind 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.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
Airlines) is registered in Amstelveen, The Netherlands, with registered
number 33014286
********************************************************
********************************************************
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. 
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286
********************************************************
                        

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