My experiences are a little bit different from Thomas.
We had a similar reduction, the sqls were faster, BUT........after two or three
weeks, everything went back to the point where we started. The reduction had
gone, the sql speed had gone........
I'm not sure, if it will make sense (to us!) doing this challenge again (Because
the unload took 600 minutes and the reload 918 Minutes realtime on S390 Server
V3.7.5 with 3590E Tapes and a DB with 76% Utilization of 16 Gb)

regards
Gerhard Wolkerstorfer





andyc AT ANDYC.CARENET DOT ORG (Andrew Carlson) am 28.05.2002 13:31:01

Bitte antworten an ADSM-L AT VM.MARIST DOT EDU

An:   ADSM-L AT VM.MARIST DOT EDU
Kopie:     (Blindkopie: Gerhard Wolkerstorfer/DEBIS/EDVG/AT)

Thema:    Unload/Loaddb Question: what happens after a little time passes



I asked this before, but did not see an answer.  I did a test
unload/load on my test server, and saw a 44% reduction in the database.
My selects ran with blazing speed, even on a much smaller box than the
production box.  What I wanted to know, from people that have seen
significant reductions, how long do the benefits last?  The database has
a percent changed of around 10% a day.  It seems like this could quickly
make these benefits "go away", but if the same, or close, 10% of the
database changes, the benefits might stay awhile.  I am trying to figure
out if I will need to do this again in 6 months, a year, or more, or
less.  Thanks for any info.  I know that, when I  do this, I will find
out myself, but we are not doing it til July 4th weekend, and I just
wanted to get some idea what other people are seeing.


Andy Carlson                                    |\      _,,,---,,_
Senior Technical Specialist               ZZZzz /,`.-'`'    -.  ;-;;,_
BJC Health Care                                |,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri                           '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html