Each location consists of a number of files and subdirectories to store location data, system catalog tables, and user-defined tables and indexes for each database in the location. Storage group (stogroup) directories might be used to organize the physical placement of some files. See the Data Storage Architecture for more information.
| File Name | Description |
|---|---|
| numeric. * | Most file names are derived from the first 8 characters of their corresponding objects (location name, table name, etc.) If the first 8 characters do not produce a unique name, a random 8-digit number is generated by the XDB Server and is used as the file name. |
| location.ddt | Contains information on the tables in a location. |
| location.ddf | Contains information on the columns in tables in a location. |
| location.ddi | Contains information on indexes in a location. |
| location.ddv | Contains information on the XDB Server version. |
| sys*.tab | XDB Server system catalog tables. (Due to similarity of names, many system tables carry a numeric filename as explained above.) |
| table.tab | Contains the data stored in an XDB Server table. |
| index.idx | Contains index values for indexed columns. |
| index.ptr | Contains record pointers to duplicate occurrences of values. (Contain 0 bytes if the index is unique.) |