Databases

A database object is a 1-to-8 character name assigned to a collection of tables and indexes. When creating a database (without specifying a stogroup) the XDB Server also creates a subdirectory on disk using the database name. The subdirectory is created under the directory of the current location. (For example: c:\xdb\locat1\dbname )

When you create a table, you can specify the name of the database with which you want it to be associated. If you are using table spaces, you specify the name of the database and table space. If you do not specify a database name, then the tables and other objects are stored in the DSNDB04 default database which is automatically included in each location.

If you have defined stogroups (see above), you can specify which stogroup should be the default stogroup for the database. The directory (path) defined for that stogroup will then be used to store the various database files (tables, indexes, etc.).

If you do not specify a stogroup for the database, the XDB Server uses the default stogroup (SYSDEFLT) which causes files for database objects to be stored under the ..\location-name\dbname\ structure described above. (It is also possible to specify a stogroup for each table space that you define for your tables and indexes, if you use table spaces.)

See the SQL Reference for detailed information regarding the storage structure and naming conventions that apply when creating various database objects with and without stogroups.