RE: Can you reorg a Table without stopping the DB?

Posted in 1997

Sujit Pal — 28 Jul 1997 11:23:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Jason If you mean doing a reorg on a table while there are sessions accessing = the table, no. However if you were to reorg the table while the engine = is online, yes. You may want to check out my reorg.pl script in the IIUG archives. What = the script does is to extract information about the table like extent = size, dbspace, etc, drop the table and recreate it with user-supplied = extent sizes and dbspace information, if supplied. I have seen posts that suggest Platinum TSREORG utility as well. You may = want to check that out too. HTH Sujit Pal ---------- From: Jason Berryhill[SMTP:jason_berryhill@hp.com] Sent: Friday, July 25, 1997 10:33 AM To: informix-list@rmy.emory.edu Subject: Can you reorg a Table without stopping the DB? Greetings to INFORMIX practitioners: Can anyone tell me if it is possible to do a reorg. on a table within IN FORMIX without shutting down the database? I.E. keeping it online and working. Thanks all, Jason Berryhill