altdb_set.gif

alter database DBS-NAME 
 set
   {
    retrieve_buffer_size SIZE-STRING
    |retrieve_sort_buffer_size SIZE-STRING
    |data_cache_size SIZE-STRING
    |index_cache_size SIZE-STRING
    |currency_database DBS-STRING
    |currency_member MEMBER-NAME
    |currency_conversion {division|multiplication}
    |minimum permission %DBS-SYSTEM-ROLE%
    |compression {rle|bitmap}
    |lock_timeout 
     {
      immediate
      |never
      |after INTEGER {[!seconds!|minutes]} 
     }
    |implicit_commit after INTEGER {blocks|rows}
    |variable VARIABLE-NAME STRING
    |default calculation {CALC-NAME-SINGLE|as calc_string CALC-STRING}
    |active alias_table ALT-NAME-SINGLE
    |performance statistics {enabled|disabled|mode to %PST-SPEC%}
    |note COMMENT-STRING
   }

DBS-SYSTEM-ROLE::=
 {no_access|read|write|execute|manager}

PST-SPEC::=
 {
  default 
  |{medium|long} persistence {all|database|server} scope
 }