CREATE DATABASE -+------------------++
+-> ALIAS <alias> -+|
+------------ <-----------------------+
++-----------------------------++------------------------------+-+
+++-> root-file-params-1 ---++++++-> storage-area-params-1 -+++ |
|+-> root-file-params-2 ---+| |+-> storage-area-params-2 -+| |
|+-> root-file-params-3 ---+| +-------------- <------------+ |
|+-> root-file-params-4 ---+| |
+----------- <--------------+ |
+-------------------------- <------------------------------------+
++--------------------+--+-----------------------+--------->
+-> character-sets --+ ++-> database-element -++
+-------- <-----------+
root-file-params-1 =
-+-> FILENAME <db-attach-spec> -++----------------------++->
+-> PATHNAME <path-name> ----++-> literal-user-auth -+|
+-> attach-options -------------------------------------+
+-> COLLATING SEQUENCE <collation-name> -----+ |
| +-------------------<---------------------+ |
| ++-----------------------------------+----+ |
| +-> COMMENT IS ---+-> '<string>' --++ | |
| +------- / <-----+ | |
| +-------------------<---------------------+ |
| +--> <ncs-name> -+-----------------------+-----------+
| +-> FROM <library-name> + |
+-> NUMBER OF USERS -------> <number-users> ------------+
+-> NUMBER OF BUFFERS -----> <number-buffers> ----------+
+-> NUMBER OF CLUSTER NODES ----> <number-nodes> --+ |
| +--------------------------------------------+ |
| ++----------------------------------------+-------+
| +> ( -+-> SINGLE ---+-> INSTANCE --> ) --+ |
| +-> MULTIPLE -+ |
+-> NUMBER OF RECOVERY BUFFERS -> <number-buffers> -----+
+-> BUFFER SIZE IS -> <buffer-blocks> --> BLOCKS -------+
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>' -+
attach-options =
-+-> DBKEY -+-> SCOPE IS -+-> ATTACH -------+-----------------------+->
+-> ROWID -+ +-> TRANSACTION --+ |
+-> MULTISCHEMA IS -+-> ON --+-------------------------------------+
| +-> OFF -+ |
+-> PRESTARTED TRANSACTIONS ARE -+-> ON --+------------------------+
| +-> OFF -+ |
+-+-------+-> RESTRICTED ACCESS -----------------------------------+
+-> NO -+
root-file-params-2 =
-+-> global-buffer-params -----------------------------------------+->
+-> SNAPSHOT IS ----+-----> ENABLED -+-> IMMEDIATE +-+-----------+
| | +-> DEFERRED -+ | |
| +-----> DISABLED -----------------+ |
+-> DICTIONARY IS ---+---> REQUIRED -------+----------------------+
| +---> NOT REQUIRED ---+ |
+-> ADJUSTABLE LOCK GRANULARITY IS -+-> ENABLED -> alg-options -+-+
| +-> DISABLED ---------------+ |
+-> LOCK TIMEOUT INTERVAL IS <number-seconds> SECONDS ------------+
+-> SEGMENTED STRING -+-> STORAGE AREA IS <area-name> ------------+
+-> LIST -------------+ |
+-> DEFAULT ----------+ |
+-> PROTECTION IS ---+---> ANSI --+-------------------------------+
| +---> ACLS --+ |
+-> RESERVE <n> +-> CACHE SLOTS ----+-----------------------------+
| +-> JOURNALS -------+ |
| +-> STORAGE AREAS --+ |
| +-> SEQUENCES ------+ |
+-+-> 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 -+ |
+------------------- , <----------------+
alg-options =
--+------------------------------+-->
+-> ( --> COUNT IS <n> --> ) --+
txn-modes =
-+-+-------+-+-> READ ONLY -----------------+-->
| +-> NO -+ +-> READ WRITE ----------------+
| +-> BATCH UPDATE --------------+
| +-> SHARED ----+--+----------+-+
| +-> PROTECTED -+ +-> READ --+ |
| +-> EXCLUSIVE -+ +-> WRITE -+ |
+-------------> ALL -----------------------+
+-------------> NONE ----------------------+
root-file-params-3 =
-+> 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 ----------------------------+ |
+> SYSTEM INDEX -+-> COMPRESSION IS -+-> ENABLED ---+-----+----------+
| | +-> DISABLED --+ | |
| +-> ( -+-> system-index-options -+-> ) --+ |
| +---------- , <-----------+ |
+> prestarted-transaction-params ------------------------------------+
+> SECURITY CHECKING IS --> security-checking-options ---------------+
+> SYNONYMS ARE ENABLED ---------------------------------------------+
+> NOTIFY IS -+-> ENABLED --> notify-options -+---------------------+
+-> DISABLED --------------------+
system-index-options =
-+-> COMPRESSION IS --------------------------------++- ENABLED -++->
+-> PREFIX CARDINALITY COLLECTION IS --------------++> DISABLED +|
+-> PREFIX CARDINALITY COLLECTION IS ENABLED FULL ---------------+
+-> TYPE IS SORTED --+-----------+-------------------------------+
+-> RANKED -+
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 -------------------+
security-checking-options =
-+-> EXTERNAL -+------------------------------------------------++->
| +-> ( -> PERSONA SUPPORT IS -+-> ENABLED --+> ) -+|
| +-> DISABLED -+ |
+-> INTERNAL -+-----------------------------------------------+-+
+-> ( -> ACCOUNT CHECK IS -+---> ENABLED --+> ) +
+---> DISABLED -+
notify-options =
--+-----------------------------------------------------+-->
+--> ( ALERT OPERATOR -+--> operator-class -+-- ) --+
+--------- + <---------+
root-file-params-4 =
-+-> ASYNC BATCH WRITES ARE +> ENABLED -> async-bat-wr-options -+---+->
| +> DISABLED ------------------------+ |
++------------+-> ASYNC PREFETCH IS --+ |
|+> DETECTED -+ +-------------------+ |
| +-+-> ENABLED ---> async-prefetch-options +------+
| +-> DISABLED ---------------------------+ |
+-> ROW CACHE IS -+-> ENABLED --+-+----------------------+---------+
| +-> DISABLED -+ +-> row-cache-options -+ |
+-+------+-> INCREMENTAL BACKUP SCAN OPTIMIZATION -----------------+
| +> NO -+ |
+-> MULTITHREAD AREA ADDITIONS ----> multithread-options ----------+
+-> RECOVERY JOURNAL -> ( -> ruj-options -> ) ---------------------+
+-> OPEN IS -+> MANUAL --------------------------------------------+
| +> AUTOMATIC -+--------------------------------------++
| +->(WAIT <n> -> MINUTES -> FOR CLOSE) -+|
+-> SHARED MEMORY IS -+-> SYSTEM -------------------+--------------+
+-> PROCESS -+-------------+--+
+-> RESIDENT -+
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 -+ |
+----------------- , <--------------------------+
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 ------------------------+|
+-------------------------- , <-----------------------------+
multithread-options =
---+-----------------------------------------+-->
+-> ( --+-> ALL AREAS -----------+--> ) --+
+-> LIMIT TO <n> AREAS --+
ruj-options =
-+-> LOCATION IS --> <directory-spec> -+-->
+-> NO LOCATION ----------------------+
+-> BUFFER MEMORY IS -+-> LOCAL ------+
+-> GLOBAL -----+
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 -----+
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> ------->
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> + |
+------------------------------<--------------------------+
character-sets =
-+-+--> DEFAULT CHARACTER SET <support-char-set> --+-+->
| +--> NATIONAL CHARACTER SET <support-char-set> -+ |
| +--> IDENTIFIER CHARACTER SET <names-char-set> -+ |
| +--> DISPLAY CHARACTER SET <support-char-set> ----+
+---------------------- <---------------------------+
database-element =
-+-> create-cache-clause -----------------+-->
+-> create-catalog-statement ------------+
+-> create-collating-sequence-statement -+
+-> create-domain-statement -------------+
+-> create-function-statement -----------+
+-> create-index-statement --------------+
+-> create-module-statement -------------+
+-> create-procedure-statement ----------+
+-> create-sequence-statement -----------+
+-> create-schema-statement -------------+
+-> create-storage-area-clause ----------+
+-> create-storage-map-statement --------+
+-> create-table-statement --------------+
+-> create-trigger-statement ------------+
+-> create-view-statement ---------------+
+-> grant-statement ---------------------+