If your SMC or other metadata-based SAS tools seem to take a long time to load up when connecting to the metadata server you may benefit from running a reorg. The %OMABAKUP macro includes a reorg parameter which reduces the amount of fragmentation in how the datasets making up SAS metadata are stored:
REORG="YES|NO"
is an optional parameter for a backup that enables you to reclaim unused disk space left from previously deleted metadata objects from SAS metadata repositories.When metadata is deleted from a SAS metadata repository, the record is removed from both memory and disk. However, the disk space that had been allocated for the record remains in the data set after the record is removed.
Specify one of the following values for this parameter:
YES (or Y) if you want to reclaim disk space during the backup operation. (This option is not valid when %OMABAKUP is executed in restore mode.) If you specify this option, %OMABAKUP does the following:
- re-creates the repository data sets as it copies them to the backup destination, eliminating unused space in the process
- copies the re-created data sets back to their original locations
Note: Because of the overhead that is associated with re-creating the data sets, you might not want to use the REORG option for every backup. Consider using this option once a month and after large amounts of metadata have been deleted.
NO (or N) if you want to copy the repositories as they are. This is the default value.
For more details see:
http://support.sas.com/onlinedoc/913/getDoc/en/bisag.hlp/a003134684.htm#a003134788