Re: reorg

Also, first thing, you should verify the integrity of the data: tbcheck -cr, tbcheck -cc <dbname>, tbcheck -cD <dbname>, tbcheck -cI <dbname> (and you might as well do another level 0 archive afterwards, too) Wile E. Coyote wrote: > > Hi David, > > > David Kulkarni wrote: > > > > Can somebody help me with step-by-step instructions on > > how to do a reorg on Informix 5.10UC5. I would > > you have to dbexport/import your database to reorganize it. > 1) backup the whole database > (tbtape -s -L 0) > 2) dbexport <database name> > The database will be exported to ASCII format in an directory > called > <database> within your current directory. > 3) drop database (dbaccess|database|drop) > 4) dbimport <database name> > 5) update statistics (dbaccess|query|new "update > statistics"|[ESC]|run) > 6) Activate Logging for your database(tbtape -s -L 0 (-B|-U|-A) > database) > > To check logging mode of your database, use onmonitor: > onmonitor|status|databases > The flags in the right column will show you the logging mode > > (B=buffered, U=unbuffered, A=ansi, N=none) > > For faster import, remove the "create index" statements from the > generated schema file (./database/database.sql). Create them manualle > after running dbimport. > > Hope this helps, > Wile -- Colin Any opinions I state are my own and not necessarily those of my employer