Question:
What does the following statement about self-reorganizing of the Files Data Set in the CA Disk Integration Guide mean exactly:
Self Reorganizing
Switching to the CA Datacom/AD database saves the downtime needed for FDS reorganizations as the new process is typically ‘self-reorganizing’.
If reorganization is necessary, it can be done in real time; the database would not require outage for maintenance.
Answer:
The "self-reorganizing" refers to the ability to perform online REORG (OLREORG).
With OLREORG, you can reorganize the Datacom Files Data Base without having to take it offline.
For more information about the REORG(OLREORG) please check the OLREORG (Reorganize a database online) chapter in the Datacom/DB DBUTLTY Reference Guide.
Additional Information:
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.