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 <[EMAIL PROTECTED]>@vm.marist.edu> on 10/29/2003 08:52:53 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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. **********************************************************************
