Online Utilities for Uninterrupted Access to Data
This is a white paper about SAP Sybase ASE online utilities. Here we address the problem of keeping exclusive access on table by utilities. The current business trends can't afford the long data unavailability and they force 24 X 7 data availability. If utilities such as Data Reorganization or Create Index take exclusive lock on the table, it directly conflicts with requirement of keeping the data available almost all the time. This challenge leads to a need to change these utilities in such a way that they don't block the access to the data all the time and still maintain the integrity of the data or make these utilities operate in online mode.