Re: Move and resize rootdbs
Olaf Kratzsch wrote:
> What are the differences between onunload/onload and
> dbexport/dbimport ???
First one is working on physical level (Page level) so you'll got the same copy
of your table spaces etc (including defragmentation etc.)
while second one is working on logical level, so the logical (not physical)
scheme and data would be unloaded/loaded.
First one is almost all the time faster, but if you have _big holes_ in
your table spaces etc. the last one would be faster.
The problem with second one is that its a environment dependant data formats,
so if you'll dbexports locale-dependant data you have to ensure that the same
formatting is used when you dbimport it. + you may have some problem
with inter base (synonyms etc) dependency.
Last one method is yet another way to _optimize_ your physical data layering.
But don't forget to use UPDATE STATISTICS after dbimport !
SY, Alex
--
Alexander V.Didytch, Kyiv, Ukraine ICQ 21528397
--
GIGO ...
--Unknown Methodologist
On Fri, 23 Apr 1999 17:49:07 +0300, "Alexander V.Didytch"
<dav@entel.kiev.ua> wrote:
Thank you for yur help
GREETINGS OLAF
>
>Olaf Kratzsch wrote:
>> What are the differences between onunload/onload and
>> dbexport/dbimport ???
>
>First one is working on physical level (Page level) so you'll got the same copy
>of your table spaces etc (including defragmentation etc.)
>
>while second one is working on logical level, so the logical (not physical)
>scheme and data would be unloaded/loaded.
>
>First one is almost all the time faster, but if you have _big holes_ in
>your table spaces etc. the last one would be faster.
>
>The problem with second one is that its a environment dependant data formats,
>so if you'll dbexports locale-dependant data you have to ensure that the same
>formatting is used when you dbimport it. + you may have some problem
>with inter base (synonyms etc) dependency.
>
>Last one method is yet another way to _optimize_ your physical data layering.
>
>But don't forget to use UPDATE STATISTICS after dbimport !
>
>SY, Alex
>--
>Alexander V.Didytch, Kyiv, Ukraine ICQ 21528397
>--
>GIGO ...
>--Unknown Methodologist