ALTER DATABASE -+-> FILENAME <db-attach-spec> -++---------------------++
+-> PATHNAME <path-name> ------++> literal-user-auth -+|
+----------------------------------------------------------------------+
+-+-+-----------------------------------------+-+---------------------->
| +-> alter-root-file-params1 --------------+ |
| +-> alter-root-file-params2 --------------+ |
| +-> alter-root-file-params3 --------------+ |
| +-> alter-journal-params -----------------+ |
| +-> alter-storage-area-params ------------+ |
| +-> add-row-cache-clause -----------------+ |
| +-> add-journal-clause -------------------+ |
| +-> add-storage-area-clause --------------+ |
| +-> alter-row-cache-clause ---------------+ |
| +-> alter-journal-clause -----------------+ |
| +-> alter-storage-area-clause ------------+ |
| +-> drop-clause --------------------------+ |
+--------------------<------------------------+
db-attach-spec =
--+----------------+-> <file-spec> --->
+-> <node-spec> -+
node-spec =
-+-> <nodename> -+-------------------+-+->
| +-> <access-string> + |
+------------------ :: <--------------+
access-string =
-+-> " <user-name> <password> " --+->
+-> " <VMS-proxy-user-name> " ---+
literal-user-auth =
---> USER '<username>' -+------------------------+-->
+-> USING '<password>' -+
alter-root-file-params1 =
-+-> attach-options ----------------------------------------------+->
+-> NUMBER OF USERS IS --> <number-users> -----------------------+
+-> NUMBER OF BUFFERS IS --> <number-buffers> -------------------+
+-> NUMBER OF CLUSTER NODES IS -> <number-nodes> ---+ |
| +-----------------------------------------------+ |
| ++------------------------------------------+----------------+
| +> ( -+-> SINGLE ---+--> INSTANCE --> ) ---+ |
| +-> MULTIPLE -+ |
+-> NUMBER OF RECOVERY BUFFERS IS -> <number-buffers> -----------+
+-> BUFFER SIZE IS <buffer-blocks> BLOCKS -----------------------+
+-> SNAPSHOT IS -+> ENABLED -+------>------+-+-------------------+
| | +> IMMEDIATE -+ | |
| | +> DEFERRED --+ | |
| +> DISABLED ----------------+ |
+-> DICTIONARY IS ------+-> REQUIRED -------+--------------------+
| +-> NOT REQUIRED ---+ |
+-> DICTIONARY IS ------+-> USED -----------+--------------------+
| +-> NOT USED -------+ |
+-> ADJUSTABLE LOCK GRANULARITY IS -+-> ENABLED -> alg-options -++
+-> DISABLED ---------------+
attach-options =
-+> MULTISCHEMA IS +> ON ---+--------------------------------------+->
| +> OFF --+ |
+> OPEN IS -+> MANUAL --------------------------------------------+
+> AUTOMATIC +---------------------------------------++
+> ( WAIT <n> -> MINUTES -> FOR CLOSE ) +
alg-options =
--+------------------------------+-->
+-> ( --> COUNT IS <n> --> ) --+
alter-root-file-params2 =
-+-> global-buffer-params ---------------------------------------+->
+-> CARDINALITY COLLECTION IS ------------+-+-> ENABLED ----+---+
+-> CARRY OVER LOCKS ARE -----------------+ +-> DISABLED ---+ |
+-> GALAXY SUPPORT IS --------------------+ |
+-> LOCK PARTITIONING IS -----------------+ |
+-> LOGMINER SUPPORT IS ------------------+ |
+-> METADATA CHANGES ARE -----------------+ |
+-> STATISTICS COLLECTION IS -------------+ |
+-> WORKLOAD COLLECTION IS ---------------+ |
+-> prestarted-transaction-params ------------------------------+
+-> LOCK TIMEOUT INTERVAL IS <number-seconds> SECONDS ----------+
+-> RESERVE <n> +-> CACHE SLOTS ----+---------------------------+
| +-> JOURNALS -------+ |
| +-> STORAGE AREAS --+ |
| +-> SEQUENCES ------+ |
+-> ROW CACHE IS -+-> ENABLED --+--+-----------------------+----+
| +-> DISABLED -+ +-> row-cache-options -+ |
+-> SET --+--> TRANSACTION MODES -+--> txn-modes -+---->) -+
+-> ALTER -+ +-----> , ----------+
global-buffer-params=
--> GLOBAL BUFFERS ARE -+-> ENABLED --+--------------+
+-> DISABLED -+ |
+----------------------------------------------------+
+---------------------------------------------------+--->
+> ( -++-> NUMBER IS <number-glo-buffers> ----++> ) +
|+-> USER LIMIT IS <max-glo-buffers> ---+|
|+-> PAGE TRANSFER VIA --+-> DISK ---+--+|
|| +-> MEMORY -+ |
|+-> LARGE MEMORY IS --+--> ENABLED --+--+
| +--> DISABLED -+ |
+------------------- , <----------------+
prestarted-transaction-params =
-> PRESTARTED TRANSACTIONS ARE -++--> ENABLED -++----------------------------++>
|+--> ON -----++->(prestart-trans-options) -+|
+-+-> DISABLED --+----------------------------+
+-> OFF -------+
prestart-trans-options =
-+---------------------------------+->
+-> WAIT <n> SECONDS FOR TIMEOUT -+
+-> WAIT <n> MINUTES FOR TIMEOUT -+
+-> NO TIMEOUT -------------------+
row-cache-options =
-> ( -++-> CHECKPOINT -+-> ALL ROWS TO BACKING FILE -----------+-++-> ) -->
|| +-> TIMED EVERY <n> SECONDS ------------+ ||
|| +-> UPDATED ROWS TO -+-> BACKING FILE -++ ||
|| +-> DATABASE -----+ ||
|+-> LOCATION IS --> <directory-spec> ---------------------+|
|+-> NO --+--> LOCATION --------+--------------------------+|
|| +--> SWEEP INTERVAL --+ ||
|+-> NUMBER OF SWEEP ROWS IS <n> --------------------------+|
|+-> SWEEP INTERVAL IS <n> SECONDS ------------------------+|
+-------------------------- , <-----------------------------+
txn-modes =
-+-+-------+-+-> READ ONLY -----------------+-->
| +-> NO -+ +-> READ WRITE ----------------+
| +-> BATCH UPDATE --------------+
| +-> SHARED ----+--+----------+-+
| +-> PROTECTED -+ +-> READ --+ |
| +-> EXCLUSIVE -+ +-> WRITE -+ |
+-------------> ALL -----------------------+
+-------------> NONE ----------------------+
alter-root-file-params3 =
-+> ASYNC BATCH WRITES ARE -+-> ENABLED -> async-bat-wr-options ++>
| +-> DISABLED -----------------------+|
++------------+-> ASYNC PREFETCH IS --+ |
|+> DETECTED -+ +-------------------+ |
| +-+-> ENABLED ---> async-prefetch-options +---+
| +-> DISABLED ---------------------------+ |
++------+-> INCREMENTAL BACKUP SCAN OPTIMIZATION ---------------+
|+> NO -+ |
+> RECOVERY JOURNAL -> ( -> ruj-options -> ) -------------------+
+> SECURITY CHECKING IS ---> security-checking-options ---------+
+> SYNONYMS ARE ENABLED ----------------------------------------+
+> SHARED MEMORY IS --+-> SYSTEM -------------------+-----------+
| +-> PROCESS --+-------------+-+ |
| +-> RESIDENT -+ |
+> NOTIFY IS -+->ENABLED ---> notify-options -+---------------+
+->DISABLED ----------------------+
asynch-bat-wr-options =
-+----------------------------->-------------------------------+->
+ ( ++-> CLEAN BUFFER COUNT IS <buffer-count> BUFFERS --++> ) +
|+-> MAXIMUM BUFFER COUNT IS <buffer-count> BUFFERS +|
+------------------- , <-----------------------------+
async-prefetch-options =
--+-----------------------------------------------------------+>
+-> ( -+-+-> DEPTH IS <number-buffers> BUFFERS -----+--+> )-+
| +-> THRESHOLD IS <number-buffers> BUFFERS -+ |
+----------------- , <--------------------------+
ruj-options =
-+-> LOCATION IS --> <directory-spec> -+-->
+-> NO LOCATION ----------------------+
+-> BUFFER MEMORY IS -+-> LOCAL ------+
+-> GLOBAL -----+
security-checking-options =
-+-> EXTERNAL -+------------------------------------------------++->
| +-> ( -> PERSONA SUPPORT IS -+-> ENABLED --+> ) -+|
| +-> DISABLED -+ |
+-> INTERNAL -+-----------------------------------------------+-+
+-> ( -> ACCOUNT CHECK IS -+---> ENABLED --+> ) +
+---> DISABLED -+
alter-journal-params =
-> JOURNAL IS ---+
+----------------+
+-+> ENABLED +----------------------------------------++->
| +> ( +-+-> aij-control-options-1 -+-+> ) +|
| | +-> aij-control-options-2 -+ | |
| +------------- , <-------------+ |
+> DISABLED -----------------------------------------+
aij-control-options-1 =
--+-> ALLOCATION IS <n> BLOCKS ----------------------------+->
+-> BACKUP SERVER IS +> AUTOMATIC +> <backup-file-spec>--+
| +> MANUAL ---+ |
+-> BACKUP FILENAME ---> <backup-file-spec> --+ |
| +-----------------------------------------+ |
| +-> backup-filename-options -------------------------+
+-> NO BACKUP FILENAME ----------------------------------+
+-> EXTENT IS <n> BLOCKS --------------------------------+
backup-filename-options =
-+------------------------------------------------------+->
+-> ( -+-> NO EDIT STRING ----------------------+-> ) -+
+-> EDIT STRING IS -+-+-> SEQUENCE --+-+-+
| +-> YEAR ------+ |
| +-> MONTH -----+ |
| +-> DAY -------+ |
| +-> HOUR ------+ |
| +-> MINUTE ----+ |
| +-> JULIAN ----+ |
| +-> WEEKDAY ---+ |
| +-> literal ---+ |
+--------- + <-----+
aij-control-options-2 =
-+-> FAST COMMIT IS -+> ENABLED ---> fc-options --+-------+->
| +> DISABLED -----------------+ |
+-> LOG SERVER IS -+> MANUAL ----+-----------------------+
| +> AUTOMATIC -+ |
+-> OVERWRITE IS --+> ENABLED --+------------------------+
| +> DISABLED -+ |
+-> SHUTDOWN TIME IS <n> MINUTES ------------------------+
fc-options =
--+------------------------------------------------------------------+->
+-> ( -++> CHECKPOINT -+-> INTERVAL IS <n> BLOCKS ------+-+-+-> ) -+
|| +-> TIMED EVERY <n> SECONDS -----+ | |
|| +-> EVERY <n> TRANSACTIONS ------+ | |
|++-------+-> COMMIT TO JOURNAL OPTIMIZATION ------+ |
||+-> NO -+ | |
|+-> TRANSACTION INTERVAL IS <number-txns> --------+ |
+----------------- , <-------------------------------+
notify-options =
--+-----------------------------------------------------+-->
+--> ( ALERT OPERATOR -+--> operator-class -+-- ) --+
+--------- + <---------+
operator-class =
---+--+------+-+--> CENTRAL -----+--->
| +> NO -+ +--> DISKS -------+
| +--> CLUSTER -----+
| +--> CONSOLE -----+
| +--> SECURITY ----+
| +--> OPER1 -------+
| +--> OPER2 -------+
| +--> OPER3 -------+
| +--> OPER4 -------+
| +--> OPER5 -------+
| +--> OPER6 -------+
| +--> OPER7 -------+
| +--> OPER8 -------+
| +--> OPER9 -------+
| +--> OPER10 ------+
| +--> OPER11 ------+
| +--> OPER12 ------+
+--------------> ALL ---------+
+--------------> NONE --------+
extent-params =
--+-> EXTENT IS -+-> ENABLED -------------------++-->
| +-> DISABLED ------------------+|
| +-> <extent-pages> --> PAGES --+|
| +-> (extension-options) -------+|
+---------------------<------------------------+
extension-options =
---> MINIMUM OF <min-pages> PAGES, --+
+------------------------------------+
+--> MAXIMUM OF <max-pages> PAGES, --+
+------------------------------------+
+--> PERCENT GROWTH IS <growth> ------->
add-journal-clause =
---> ADD JOURNAL -----> <journal-name> ------+
+--------------------------------------------+
++---------------------------------+-+-+--------------------+-+->
+-> FILENAME <journal-file-spec> -+ | +-> add-aij-options -+ |
+---------- <------------+
add-aij-options =
-+-> ALLOCATION IS --> <n> -> BLOCKS ---------------+-->
+-> EXTENT IS --> <n> -> BLOCKS -------------------+
+-> BACKUP FILENAME -> <backup-file-spec> ---+ |
| +------------------------------------------+ |
| +--> backup-filename-options --------------------+
+-> SAME BACKUP FILENAME AS JOURNAL ---------------+
+-> NO BACKUP FILENAME ----------------------------+
add-storage-area-clause =
---> ADD STORAGE AREA <area-name> --+
+-----------------------------------+
+-+-------------------------+-++-> storage-area-params-1 -+-+->
+-> FILENAME <file-spec> -+ |+-> storage-area-params-2 -+ |
+-------------- <-------------+
storage-area-params-1 =
--+-> ALLOCATION IS ---> <number-pages> --> PAGES -----+->
+-> CACHE USING <row-cache-name> --------------------+
+-> NO ROW CACHE ------------------------------------+
+-> extent-params -----------------------------------+
+-> INTERVAL IS --> <number-data-pages> -------------+
+-> LOCKING IS --+-> ROW --+--> LEVEL ---------------+
| +-> PAGE -+ |
+-> PAGE FORMAT IS +-> UNIFORM -+--------------------+
| +-> MIXED ---+ |
+-> PAGE SIZE IS ----> <page-blocks> --> BLOCKS -----+
storage-area-params-2 =
--+-> CHECKSUM CALCULATION IS -----------+--+-> ENABLED --+-+->
+-> SNAPSHOT CHECKSUM CALCULATION IS --+ +-> DISABLED -+ |
+-> SNAPSHOT ALLOCATION IS --> <snp-pages> ----> PAGES ---+
+-> SNAPSHOT EXTENT IS -+-> <extent-pages> ----> PAGES --++
| +-> (extension-options) ---------+|
+-> SNAPSHOT FILENAME --> <file-spec> --------------------+
+-> THRESHOLDS ARE ( <val1> +-----------------------+> ) -+
| +> ,<val2> -+----------++ |
| +> ,<val3> + |
+------------------------------<--------------------------+
add-row-cache-clause =
---> ADD CACHE <row-cache-name> -+-+----------------------+-+->
| +-> row-cache-params1 -+ |
| +-> row-cache-params2 -+ |
+-------------<------------+
alter-row-cache-clause =
---> ALTER CACHE <row-cache-name> -+-+----------------------+-+->
| +-> row-cache-params1 -+ |
| +-> row-cache-params2 -+ |
+-------------<------------+
row-cache-params1 =
--+-> ALLOCATION IS <n> -+--+-----------+----------------+->
+-> EXTENT IS <n> -----+ +-> BLOCK --+ |
| +-> BLOCKS -+ |
+-> CACHE SIZE IS <n> -+----> ROW --+------------------+
| +----> ROWS -+ |
+-> CHECKPOINT -+> UPDATED ROWS TO -+> BACKING FILE -+-+
| | +> DATABASE -----+ |
| +> ALL ROWS TO BACKING FILE ---------+ |
+-> LARGE MEMORY IS ----+-+-> ENABLED --+--------------+
+-> ROW REPLACEMENT IS -+ +-> DISABLED -+ |
+-> LOCATION IS --> <directory-spec> ------------------+
+-> NO LOCATION ---------------------------------------+
row-cache-params2 =
--+-> NUMBER OF -+-> RESERVED -+-> ROWS IS <n> --------------+->
| +-> SWEEP ----+ |
+-> ROW LENGTH IS <n> -+-------------+---------------------+
| +----> BYTE --+ |
| +----> BYTES -+ |
| |
+-> ROW SNAPSHOT IS --+-> ENABLED rs-opt -+---------------+
| +-> DISABLED --------+ |
| |
+-> SHARED MEMORY IS --+----> SYSTEM -------------------+--+
| +----> PROCESS --+-------------+-+ |
| | | |
| +-> RESIDENT -+ |
| |
+-> WINDOW COUNT IS <n> -----------------------------------+
rs-opt =
--+-------------------------------+--->
+-> (CACHE SIZE IS <n> ROWS) ---+
alter-journal-clause =
---> ALTER JOURNAL ---+-> <journal-name> -++
+-> RDB$JOURNAL ----+|
+------------------------------------------+
++-> alter-aij-options --+------------------->
+----------<------------+
alter-aij-options =
-+-> JOURNAL IS --> UNSUPPRESSED ------------------+--->
+-> BACKUP FILENAME -----> <backup-file-spec> -+ |
| +------------------------------------------+ |
| +-> backup-filename-options ------------------+
+-> SAME BACKUP FILENAME AS JOURNAL---------------+
+-> NO BACKUP FILENAME ---------------------------+
alter-storage-area-clause =
---> ALTER STORAGE AREA <area-name> -+
+------------------------------------+
++---> alter-storage-area-params ---------------+-->
+----------------------------<-----------------+
alter-storage-area-params =
-+-> ALLOCATION IS --> <number-pages> --> PAGES ----------+->
+-> extent-params ---------------------------------------+
+-> CACHE USING <row-cache-name> ------------------------+
+-> NO ROW CACHE ----------------------------------------+
+-> LOCKING IS -+-> ROW -+-> LEVEL ---------------------+
| +-> PAGE -+ |
+-> READ WRITE ------------------------------------------+
+-> READ ONLY -------------------------------------------+
+-> SNAPSHOT ALLOCATION IS --> <snp-pages> --> PAGES ----+
+-> SNAPSHOT EXTENT IS +-> <extent-pages> --> PAGES ---+-+
| +-> (extension-options) --------+ |
+-> CHECKSUM CALCULATION IS ----------+--+-> ENABLED --+-+
+-> SNAPSHOT CHECKSUM CALCULATION IS -+ +-> DISABLED -+
drop-clause =
--+-> DROP CACHE <row-cache-name> ---+-+-------------+-+->
+-> DROP STORAGE AREA <area-name> -+ +-> CASCADE --+ |
| +-> RESTRICT -+ |
+-> DROP JOURNAL <journal-name> ---------------------+