Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Ian Clark — — source: Informix-list mailing list archive (1991-1998)
Hi All,
I was considering a tidy up operation on our database. In the years
that it has been up and running it has never been properly maintained
in order for it to be as efficient as possible.
In fact, I modified the backup script the other night to include an
'UPDATE STATISTICS' afterwards and that is probably the only
administration that it has seen in 5 years!! :-)
My plan for giving the database an overhaul was as follows:
1. Backup the database.
2. Backup the database. Never can be too carful :-)
3. Produce a schema from which to re-create the database.
4. Unload the data for each table to an ascii file.
5. Delete the database.
6. Recreate the database from the schema.
7. Load all the data back.
Sounds straightforward enough. Am I missing anything?
Any views/comments would be most welcome.
Cheers, Ian.
Tedious 'office speak' part 3: "Let's go scuba in the think tank."
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.