Re: recreate system tables

It's long to tell why I need the ids but I can tell you that is a third
party tool and it works that way, I can't change it. I also can tell
tou that I hate it because the way it works but I can't do anything
about it.
What you suggest is nearly imposible, I can't recreate the ids for
every primary key and every index.
i don't care if the database is messy, I just need the ids.
Is there any way to backup just the schema withou the data?

.

Relevant Pages

  • Re: TSM and IDS - Any suggestions for best performance?
    ... I'm mostly concerned with the IDS piece where we'll take level 0 archives ... each night and continuously backup the logical logs to match our current ... There will be a dedicated RAID device attached to the TSM server ... attached to the server for our Tape Storage Pool. ...
    (comp.databases.informix)
  • RE: IDS, Linux and OOM killer
    ... onbar -w will run serially. ... The backup process runs every night, ... Are you absolutely certain the ONLY thing on this server is IDS? ... Is there some type of cron or system activity or network that also happens twice a month? ...
    (comp.databases.informix)
  • Re: Lazy IDS Onbar Backup
    ... A backup you have taken with IDS 9.20 you will have to restore with 9.20. ... 2- Do your test during a quieter period for the server. ...
    (comp.databases.informix)
  • Re: IDS, Linux and OOM killer
    ... The backup process runs every night, ... Are you absolutely certain the ONLY thing on this server is IDS? ... to see how the RAM and Swap evolve in time. ...
    (comp.databases.informix)
  • Re: recreate system tables
    ... You could restore the entire database then delete all the data, shrink it ... can't think of another way to preserve the IDs. ... > Is there any way to backup just the schema withou the data? ...
    (comp.databases.ms-sqlserver)