How the Createdb Command Works
A database is created using the createdb system command (or the equivalent operation in Director or VDBA). For command syntax, see the Command Reference Guide. The createdb operation does the following:
• Updates the system catalogs in the master database (iidbdb).
• Creates a subdirectory under the database location for the database, with the name of the database.
• For X100, creates subdirectories under the database location 'default' and 'vectorwise' for the database, with the name of the database. The folder structures 'wal' and 'CBM' are created in the new 'vectorwise' database directory. Within these are a number of subfolders and files that are maintained by the X100 Server. The wal folder contains all the Write-Ahead Log information for a database. The CBM folder contains the actual data for the tables.
Notes:
– Until data is inserted into a table there may not be any physical files associated with it.
– When data is inserted a few rows at a time (less than three) there may be no physical files created for the table until a threshold is reached that triggers propagating the PDT data to table files.
• Creates directories under the work, journal, dump, and checkpoint locations for the database. These directories may not be created at the time the database is created, but at the time, for example, that a checkpoint is first run against the database.
• Creates the configuration file (aaaaaaaa.cnf) and the core system catalogs (aaaaaaax.t00, x=b through e) in the new database directory.
• Creates and modifies the DBMS system catalogs for the new database.
• Creates the standard catalog interface.
• Creates the user interface system catalogs (restricted by any -f flag options).
• Grants “select” permission for the system catalogs to “public.”
Last modified date: 01/30/2023