Hi Eric, What would negative results mean?
We get -0.09 on a 100GB (used space, 30GB exension available)) DB. It has never been unloaded / loaded in 2 years, as far as I am aware. I would expect to see more fragmentation, I know that large swathes of filespaces / nodes have been added / removed in that time. Matt. _-'-_ -|- -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Friday, October 08, 2004 3:10 PM To: [EMAIL PROTECTED] Subject: Re: AW: DSMSERV UNLOADDB Hi David! Try the following SQL statement: SELECT CAST((100 - (CAST(MAX_REDUCTION_MB AS FLOAT) * 256 ) / (CAST(USABLE_PAGES AS FLOAT) - CAST(USED_PAGES AS FLOAT) ) * 100) AS DECIMAL(4,2)) AS PERCENT_FRAG FROM DB It will give you the fragmentation level. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -----Original Message----- From: David Nicholson [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 15:47 To: [EMAIL PROTECTED] Subject: Re: AW: DSMSERV UNLOADDB Hi All, I am surprised by the significant reduction is Pct Utilized. I thought in previous discussions that Unload/Reload had minimal impact on utilization. I have (2) TSM 5.2.2 servers on AIX with 40GB db's that are 90% used. I haven't done a unload/reload since there creation 3 years ago...do I have an opportunity here? Thanks in advance, Dave "Yuhico, Alexandra" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 10/07/2004 02:39 PM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: AW: DSMSERV UNLOADDB guys.... I've finished the DSMSERV LOADDB!!! previous q db gave a Maximum reduction of zero and a PCT Util of 68% but my current q db shows the following : Available Assigned Maximum Maximum Page Total Used Pct Max. Space Capacity Extension Reduction Size Usable Pages Util Pct (MB) (MB) (MB) (MB) (bytes) Pages Util --------- -------- --------- --------- ------- --------- --------- ----- ----- 32,768 32,768 0 17,436 4,096 8,388,608 3,928,814 46.8 46.8 Now... silly question... how do you edit the crontab? I thought it was crontab -C but that doesn't seem to work Alexandra -----Original Message----- From: Sternecker, Peter [mailto:[EMAIL PROTECTED] Sent: Friday, 8 October 2004 2:16 AM To: [EMAIL PROTECTED] Subject: AW: AW: DSMSERV UNLOADDB well, well he is right as always. OH NO , no best shell discussion 8-). Peter Sternecker R+V Allgemeine Versicherung AG * mailto:[EMAIL PROTECTED] > -----Urspr�ngliche Nachricht----- > Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im > Auftrag von Richard Sims > Gesendet: Donnerstag, 7. Oktober 2004 17:56 > An: [EMAIL PROTECTED] > Betreff: Re: AW: DSMSERV UNLOADDB > > > On Oct 7, 2004, at 11:34 AM, Sternecker, Peter wrote: > > > if your TSM-Server runs on Unix > > > > shell command | tee path_to_logfile > > > > this sends output to the terminal and the logfile. > > That will pipe Stdout, but not Stderr, where scary stuff > goes. You may instead want to do > > shell command 2>&1 | tee path_to_logfile > > or more conveniently use Cshell: > > command |& tee path_to_logfile > > This keeps important msgs from being lost. > > Richard Sims > This e-mail is privileged and may contain confidential information intended only for the person(s) named above. If you receive this e-mail in error, please notify the addressee immediately by telephone or return e-mail. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. ********************************************************************** 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. ********************************************************************** ___________________________ Disclaimer Notice __________________________ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432
