altdb_as.gif

alter database DBS-NAME 
 {
  {enable|disable}
   {
    startup
    |autostartup
    |query_tracking
    |replication_assume_identical_outline
   }
  |set
   {
    retrieve_buffer_size SIZE-STRING
    |retrieve_sort_buffer_size SIZE-STRING
    |minimum permission %DBS-SYSTEM-ROLE%
    |variable VARIABLE-NAME STRING
    |active alias_table ALT-NAME-SINGLE
   }
  |reset [{all|data}]
  |clear
   {
    aggregates
    |data in region CUBE-AREA[,...][physical]
   } 
  |compact outline
  |add variable VARIABLE-NAME [STRING]
  |drop variable VARIABLE-NAME
  |%LOAD-BUFFER-INIT%
  |destroy load_buffer with buffer_id BUFFER-ID[,...]
  |unlock all objects
  |rename to DBS-STRING
  |comment COMMENT-STRING
  |merge {all|incremental} data
  |begin archive to file FILE-NAME
  |end archive
 }

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

LOAD-BUFFER-INIT::=
 initialize load_buffer with buffer_id BUFFER-ID[,...]
  [resource_usage RNUM][property PROPS][wait_for_resources]