Re: estimate sort space for oncheck -cI
i would make sure i have setup dbspacetemp correctly and have oncheck
use that instead.
and it should be big enough to do so for your largest index!!!!!!!!! it
sounds now that you are unable
to recreate an index.
i guess you could have a look on how big the index is (oncheck -pT....)
Superboer.
Floyd Wellershaus schreef:
> An oncheck -cI keeps running out of space because it makes large sort files in PSORT_DBTEMP.
>
> Is there a way to estimate how much sort space would be required so we can size the filesystem accordingly larger, or do we need trial an error ?
>
> Thanks,
>
>
>
>
>
>
>
>
>
>
>
> ========================
> -<<Floyd Wellershaus>>-
> Database Administrator
> Unix Administrator
>
>
>
> email: fwellers@yahoo.com
>
>
> Home: 703-430-0805
>
>
> Cell: 703-477-6045
> ========================
>
>
> http://www.one.org/
> --0-858581073-1158159982=:66187
> Content-Type: text/html
> X-Google-AttachSize: 1199
>
> <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>An oncheck -cI keeps running out of space because it makes large sort files in PSORT_DBTEMP.</DIV>
> <DIV> </DIV>
> <DIV>Is there a way to estimate how much sort space would be required so we can size the filesystem accordingly larger, or do we need trial an error ?</DIV>
> <DIV> </DIV>
> <DIV>Thanks,</DIV>
> <DIV> </DIV>
> <DIV><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-858581073-1158159982=:66187--
Oh yea the Index is huge. I do have DBSPACETEMP set up to 3 different temp dbspaces, but it seems some sorts MUST go to filesystem and will not use DBSPACETEMP.
========================
-<<Floyd Wellershaus>>-
Database Administrator
Unix Administrator
email: fwellers@yahoo.com
Home: 703-430-0805
Cell: 703-477-6045
========================
http://www.one.org/
----- Original Message ----
From: Superboer <superboer7@t-online.de>
To: informix-list@iiug.org
Sent: Thursday, September 14, 2006 1:33:57 AM
Subject: Re: estimate sort space for oncheck -cI
i would make sure i have setup dbspacetemp correctly and have oncheck
use that instead.
and it should be big enough to do so for your largest index!!!!!!!!! it
sounds now that you are unable
to recreate an index.
i guess you could have a look on how big the index is (oncheck -pT....)
Superboer.
Floyd Wellershaus schreef:
> An oncheck -cI keeps running out of space because it makes large sort files in PSORT_DBTEMP.
>
> Is there a way to estimate how much sort space would be required so we can size the filesystem accordingly larger, or do we need trial an error ?
>
> Thanks,
>
>
>
>
>
>
>
>
>
>
>
> ========================
> -<<Floyd Wellershaus>>-
> Database Administrator
> Unix Administrator
>
>
>
> email: fwellers@yahoo.com
>
>
> Home: 703-430-0805
>
>
> Cell: 703-477-6045
> ========================
>
>
> http://www.one.org/
> --0-858581073-1158159982=:66187
> Content-Type: text/html
> X-Google-AttachSize: 1199
>
> <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>An oncheck -cI keeps running out of space because it makes large sort files in PSORT_DBTEMP.</DIV>
> <DIV> </DIV>
> <DIV>Is there a way to estimate how much sort space would be required so we can size the filesystem accordingly larger, or do we need trial an error ?</DIV>
> <DIV> </DIV>
> <DIV>Thanks,</DIV>
> <DIV> </DIV>
> <DIV><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-858581073-1158159982=:66187--
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Floyd Wellershaus wrote: > Oh yea the Index is huge. I do have DBSPACETEMP set up to 3 different > temp dbspaces, but it seems some sorts MUST go to filesystem and will > not use DBSPACETEMP. > If you have PSORT_NPROCS set and PSORT_DBTEMP set then IDS will use those filesystems listed in PSORT_DBTEMP instead of DBSPACETEMP temp dbspaces. Unset PSORT_DBTEMP to force the engine to use DBSPACETEMP space if you do not have enough filesystem space (You can list as many filesystems as you like there BTW, you don't need one big one, however, the spaces are used round robin so the size of the smallest will limit the amount of usable space in all.) Art S. Kagel