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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Loon, E.J. van - SPLXM
Sent: Friday, October 08, 2004 3:10 PM
To: ADSM-L AT VM.MARIST DOT EDU
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:David_R_Nicholson AT WHIRLPOOL DOT COM]
Sent: Friday, October 08, 2004 15:47
To: ADSM-L AT VM.MARIST DOT EDU
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" <alexandra.yuhico AT ATOSORIGIN DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
10/07/2004 02:39 PM
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
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:Peter.Sternecker AT RUV DOT DE]
Sent: Friday, 8 October 2004 2:16 AM
To: ADSM-L AT VM.MARIST DOT EDU
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:Peter.Sternecker AT ruv DOT de
> -----Ursprüngliche Nachricht-----
> Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im
> Auftrag von Richard Sims
> Gesendet: Donnerstag, 7. Oktober 2004 17:56
> An: ADSM-L AT VM.MARIST DOT EDU
> 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
|