WE are using Informix 7.3 on a Unix system in combination with BaaN4c4

In the inf_storage we tell whcih tables need to go to which dbspace.

When I want to clear the dbspaces, I find system-tables of Informix.
Does anybody know if I can reorganise them and direct them to a specific dbspace so it is always together??

Any information on this subject is very welcome!

Kind regards,
Dennis

PS
example:
sysutils:informix.sysprocedures 699 8
sysutils:informix.sysprocbody 707 8
sysmaster:informix.syscolumns 715 8
baan:informix.systables 53 8
baan:informix.syscolumns 61 8
baan:informix.sysindexes 69 8

Hi,

You're officially not allowed to do so. You can recreate the sysutils and sysmaster, but this also isn't very nice. You can try setting the next size bigger and then alter index to cluster on one of the indexes. Don't forget to changed the index back to not clustered. THis should work on some tables, but I don't think it is officially supported....

Greetz,

Rob Prop

Thank you very much, I will give it a shot.

dennis