602SQL Documentation Index  

Database Files Locations and Overview

Database server works with these files:

File name Purpose
wb8.fil Database file containing everything stored in the database.
transact.fil Transaction file containing information about developed transactions.
wbsqllog.txt Basic server log file, see logging.
/etc/602sql Configuration file of a server. This file contains information about registered databases and values of important server properties (used for Linux). This file also contains all paths to the files specified above for each registered database.

Database and transaction files are usually stored on the same computer as the database server working with them, so the access response is very fast.

Database file should be protected by operating system access privileges, because deleting or editing this file results in unrecoverable damage to the database.

Transaction file is used by the server for temporary storage of data which are modified in transactions, and for finishing of a nonterminated transaction after server crash. If the server is shut down properly, this file can be safely deleted.

These files have default given names and can't be renamed. Therefore you can't store two databases in a single folder.

Splitting the Database File into Multiple Parts

The database file can be split into multiple parts (not more than four). Some reasons for splitting the database file are:

Each part of the database file is a separate file from the operating system view. Each part has the same name but is stored in different folder. Each part (except for the last one) has a maximum size value - when data size crosses this value, data are being stored in the next part. If the maximum size is not specified for some part, that part becomes the last part and grows without a limit.

Splitting the database file can be setup from the Control Panel in this way:

  1. select a database server whose database file you wish to split, but don't connect to it;
  2. select the Database management action from the popup menu, then select the Files tab.

Locations of Another Database Files

The transaction file and the basic log file are located in the same folder as the database file by default (or its last part, if the database file is split). You can specify different location for these files, usually when you fear that the drive that stores the database file may run out of free space.

Database files locations are specified in the same way that was described in the previous section. If you don't specify a folder, default location will be used.