Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Question Unanswered: Reorganise system tabels of Informix

    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

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183

    Angry

    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

  3. #3
    Join Date
    Apr 2004
    Posts
    2
    Thank you very much, I will give it a shot.

    dennis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •