Complete database re-org

All, I am planning a complete database re-org for one of our Informix servers. The disk layout that I inherited when I joined the company is utterly unacceptable and must be changed. I'm drafting a step-by-step plan for this re-org, and I thought I'd run it by the Informix community for critique. The plan looks like this: 1. Perform Level 0 archive (ontape -s -L 0). 2. Do dbexport of databases. 3. Modify schemas of databases to place certain highly used tables in specific dbspaces, and set first and next extent sizes for all tables. 4. Drop databases. 5. Bring Informix off-line. 6. Modify onconfig file to set new rootdbs path, offset, and size, physical log size, dbspacetemp names, and logical log max number and size. 7. Re-initialize disk space for informix (oninit -i). 8. Add dbspaces/chunks of new disk layout. 9. Modify physical log dbspace in onconfig, and bounce engine. 10. Add logical logs to new logdbs. 11. Perform dbimport of databases. 12. Perform Level 0 archive (ontape -s -L 0). 13. Move current logical log to one of those in the new logdbs (onmode -l). 14. Drop logical logs in rootdbs. Am I missing anything? Are there steps that are utterly extraneous? Is there a better way to accomplish any of this? Other notes: In step 6, I plan on setting LOGFILES to just 3, and just adding the logs with onparams. LOGSMAX would be set to 32. Makes me wonder what importance the LOGFILES parameter has other than the point right after Informix disk space is initialized. I don't think there's a way to avoid step 9, since when the Informix instance's disk space is initialized, the only dbspace is rootdbs. Is that correct, or is there a way to assign the physical log to a different dbspace initially? I wanted to say in addition to the above, that I'm very thankful for the advice that I've received on c.d.i. I'm only a recent contributor, since I just changed companies. I came from a shop with a whole team of DBA's where we had technical meetings and could confer with one another on various issues. At my new company, I'm the only DBA. This newsgroup has become my "team of DBA's". I guess I just want to say thanks to all who provide insights to any of my questions. I'll try to lend any insight to anyone asking questions that I can help with. Many might say that no thanks are necessary; that that's why this newsgroup is here in the first place. That may be, but the help is no less appreciated. -- Kind regards, John Bejarano bebe stores, inc. Personal e-mail: jbejaran@yahoo.com -- Kind regards, John Bejarano bebe stores, inc. Personal e-mail: jbejaran@yahoo.com

John... Don't forget UPDATE STATISTICS... ~tut