Hi Eric,
Thanks for the info! The older of the 2 servers returned a
percent_frag of "-0.01" the newer returned a percent_frag of "27.44". The
older server is 4 years old...the newer is 3 years old. Seems strange the
newer server would have such a significantly higher frag %. Any idea what
kinds of activity result in fragmentation? Is unload/reload the answer
here or will the server make efficient use of these fragments over time?
Is unload/reload a performance solution or utilization solution or both?
or neither?
Thanks in advance,
Dave
"Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
10/08/2004 10:10 AM
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
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.
**********************************************************************
|