reorg rebuild ... with online allows you to reorganize your data without taking the data offline. The syntax is:
reorg rebuild table_name [with online]
For example, to rebuild the indexes on the titles table and keep the data online, enter:
reorg rebuild titiles with online
reorg rebuild ... online includes three phases:
A blocking phase that takes exclusive table locks for a short duration to set up new metadata
A nonblocking phase that reorganizes the data and synchronizes the concurrent activity
A blocking phase that reacquires exclusive table locks to synchronize the remaining concurrent activity and install the new metadata
Sybase® recommends that you run reorg rebuild ...online when the table’s transaction load is relatively low.
