Hi all,

There was a recent inquiry concerning *SM DB unloading-loading and the
potential benefits/drawbacks.
The stated benefit was a significant reduction in DB size (>90% to 52%) but the
drawback was that the process took
approximately 24 hours (this was on a 46 GB DB).

I'm running ADSM 3.1.2.40 on an AIX 4.3.2 SP node (4-way F50 equivalent w/1GB
memory) and have a 19 GB DB. I have some disk space available and was thinking
about doing the unload-reload to disk. I'm hoping this significantly reduces
the processing time.

Has anyone else attempted to do this in an AIX environment and if so what were
your results? Was it worthwhile?

Also, I didn't see anything in the ADSM Admin. Reference manual about
"unloading" the *SM DB.
How is this done?


Thx for any and all input, Tim Melly
                                              Bayer Pharmaceuticals

------------------------------------------------------------------------------
This message and any attachment is confidential and may be privileged or 
otherwise protected from disclosure.  If you have received it by mistake please 
let us know by reply and then delete it from your system; you should not copy 
the message or disclose its contents to anyone.
This message and any attachment is confidential and may be privileged or 
otherwise protected from disclosure.  If you have received it by mistake please 
let us know by reply and then delete it from your system; you should not copy 
the message or disclose its contents to anyone.