Just trying a few ideas.
An ok expiration performance is one that you are happy with, so would be a lot
less than 24 hours (say under 4 hours)
The discard data with the volumes was just a thought, that maybe your database
was nearly full, so did not have enough free space to build up the table for the
full 160,000 delete
You did not provide database statistics
Schaub Joachim Paul ABX-SECE-ZH <joachim.schaub AT abraxas DOT
ch>@vm.marist.edu> on
10/29/2003 10:54:02 AM
Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>
Sent by: "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>
To: adsm-l AT vm.marist DOT edu
cc:
Subject: AW: AW: delete filespace takes >24hours
what means an o.k. expiration performance?
why should it go faster to delete volumes(in 3 pools)?
thanks
joachim
-----Ursprüngliche Nachricht-----
Von: John Naylor [mailto:john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK]
Gesendet: Mittwoch, 29. Oktober 2003 11:21
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: AW: delete filespace takes >24hours
Is your expiration performance ok.
Do you know how many tapes this client has.
Maybe it would go faster with delete volume discarddata
Schaub Joachim Paul ABX-SECE-ZH <joachim.schaub AT abraxas DOT
ch>@vm.marist.edu>
on
10/29/2003 09:31:25 AM
Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>
Sent by: "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>
To: adsm-l AT vm.marist DOT edu
cc:
Subject: AW: delete filespace takes >24hours
some weeks ago we had memory problems, so the system is 'IBM checked' now.
No Resource Problem (800mb Regionsize, DB Bufferpool near 100MB), Cache Hit
Ratio is > 98.5% !
-----Ursprüngliche Nachricht-----
Von: John Naylor [mailto:john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK]
Gesendet: Mittwoch, 29. Oktober 2003 10:11
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: delete filespace takes >24hours
Joachim,
I am on os390 2.10 expecting to go z/os shortly and I would expect that size
of
filespace to be deleted in an hour or so.
What does your DB cache hit rate show.
If you have any sort of performance monitor such as RMF, I would take a look
at
that to see if it thinks TSM is short of resource.
John
Schaub Joachim Paul ABX-SECE-ZH <joachim.schaub AT abraxas DOT
ch>@vm.marist.edu>
on
10/29/2003 08:52:53 AM
Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>
Sent by: "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>
To: adsm-l AT vm.marist DOT edu
cc:
Subject: delete filespace takes >24hours
Dear *SM Group
I have to delete filespaces. One of the delete process runs longer 24 hours.
the FI is apr. 150GB and 160000 Files in size.
How work the TSM DB? One select, one commit, one select one commit?
If i would create an sql select on an Oracle DB it would take a few second
to delete the entries!
Environment:
TSM Server 5.1.5.4 on Z/OS 1.3, enough memory, cpu, cache hit etc.
Regards
Joachim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Joachim Paul Schaub
Abraxas Informatik AG
Beckenhofstrasse 23
CH-8090 Zürich
Schweiz / Switzerland
Telefon: +41 (043) 259 34 41
Telefax: +41 (043) 259 42 82
Internet: http://www.abraxas.ch
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
5 Jahre Abraxas - Ein grosser Erfolg !
http://www.abraxas.ch/top_Downloads/abxnews/jubi_news.pdf
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.
Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************
|
