When the physical sequence of records in an area is causing a performance problem, a database reorganization is usually scheduled. In the past, this would require the table being rendered unavailable while backups and reloads of the data in Native Key sequence are performed. With OLREORG, however, you can reorganize the database table without having to take it offline.
For information on DBUTLTY STATUS console command support for this function, see DBUTLTY STATUS.
Note: DBUTLTY status is only available when the FIRSTKEY= and LASTKEY= keywords are not specified or no rows are found in the specified key range.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|