Setting up the user realms

Like the realms and files of the compiler database, the user realms have to be set up with the CREATE-FILE command.

If it is not possible to estimate the size of the user realms before the Schema DDL and SSL are compiled, setting up the user realms after BGSIA and before BFORMAT will suffice.
BGSIA prints out the ESTIMATE-REPORT listing the sizes of individual user realms as estimated by UDS/SQL (see “Description of the ESTIMATE-REPORT” in chapter "Setting up the Schema Information Area (SIA) with BGSIA").

/CREATE-FILE FILE-NAME=dbname.realm-name
    ,SUPPORT=*PUBLIC-DISK(SPACE=*RELATIVE(PRIMARY-ALLOCATION=primary
    ,SECONDARY-ALLOCATION=secondary))
   [,SUPPORT=*PRIVATE-DISK(VOLUME=priv-vsn,DEVICE-TYPE=device,SPACE=...)]

dbname

Database name

realmname

Name of the user realm defined in the Schema DDL

SPACE

Specification of storage space (see section "Maximum size of UDS/SQL files" in chapter "Files and realms of a UDS/SQL database").

PRIMARY-ALLOCATION=primary

Primary allocation for user realm

SECONDARY-ALLOCATION=secondary

Secondary allocation;

secondary=0

Suppresses automatic realm extensibility and online realm extensibility.

secondary>0

Prerequisite for automatic realm extensibility and online realm extensibility.In the case of secondary>0, online realm extensibility is already activated for the realm concerned when the database is created.
When online realm extensibility is activated in this way, the default values NR-PAGES=64 and MIN-PAGES=0 are entered for NR-PAGES and MIN-PAGES (see Activating online extensibility when creating databases and DAL command ACT INCR in the "Database Operation" manual). 

VOLUME
DEVICE-TYPE

If the user realm is stored on private disk (PRIVATE VOLUME), the following must be specified:

priv-vsn

Volume serial number

device

Device type of private disk