reorg by restore
Is there any disk benefit gained from doing an Informix restore ? In other words, does a restore cause data to be placed more contiguously on the OS disk ? Thanks, floyd ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Home: 703-430-0805 Cell: 703-477-6045 ======================== http://www.one.org/
No. Restore (ontape and onbar) are page for page copies of the
database. People use
dbexport and dbimport for this sort of thing or alter index clustered
to reorg tables.
Floyd Wellershaus wrote:
> Is there any disk benefit gained from doing an Informix restore ? In other words, does a restore cause data to be placed more contiguously on the OS disk ?
>
> Thanks,
> floyd
>
>
>
>
>
>
>
>
>
> ========================
> -<<Floyd Wellershaus>>-
> Database Administrator
> Unix Administrator
>
>
>
> email: fwellers@yahoo.com
>
>
> Home: 703-430-0805
>
>
> Cell: 703-477-6045
> ========================
>
>
> http://www.one.org/
> --0-709693658-1153140018=:88639
> Content-Type: text/html
> X-Google-AttachSize: 1079
>
> <html><head><style type="text/css"><!-- DIV {margin:0px} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV></DIV>
> <DIV>Is there any disk benefit gained from doing an Informix restore ? In other words, does a restore cause data to be placed more contiguously on the OS disk ?</DIV>
> <DIV> </DIV>
> <DIV>Thanks,</DIV>
> <DIV>floyd<BR> </DIV>
> <DIV><BR>
> <DIV><BR>
> <DIV><BR>
> <DIV><BR>
> <DIV>========================<BR>-<<Floyd Wellershaus>>-<BR>Database Administrator<BR>Unix Administrator</DIV><BR>
> <DIV><BR>email: <A href="mailto:fwellers@yahoo.com">fwellers@yahoo.com</A></DIV><BR>
> <DIV>Home: 703-430-0805</DIV><BR>
> <DIV>Cell: 703-477-6045<BR>========================</DIV><BR>
> <DIV><A href="http://www.one.org/">http://www.one.org/</A></DIV></DIV></DIV></DIV></DIV>;
> <DIV></DIV></div></body></html>
> --0-709693658-1153140018=:88639--
Floyd Wellershaus wrote:
> Is there any disk benefit gained from doing an Informix restore ? In
> other words, does a restore cause data to be placed more contiguously on
> the OS disk ?
No. Boson explained it well. The other option is to use:
ALTER FRAGMENT FOR TABLE/INDEX <tablename> INIT IN <dbaspace|fragmentationexpression>.
<Dbspace|fragmentation expression> can be the same as the table's current
location or different.
Art S. Kagel