To optimize the usage of memory
on the metadata server, you should occasionally use the optimizeIMDB
command option of the metadata server script. This option analyzes
the handling of character variables, checking for items such as unnecessary
indexes, long character variables that can be stored as variable-length
strings, and duplicate strings. A report is produced showing the expected
amount of memory that will be required for each repository after the
optimizations are applied. The optimizations are then applied the
next time you pause and resume (or restart) the metadata server.
The optimizeIMDB command
option is new with SAS 9.3. It replaces the %OMARUNAN macro and the
RUNANALYSIS option of %OMABAKUP, which provided similar functionality
in previous releases.