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