Each database has the following files associated with it:
The database file This file holds the database information. It typically has the extension .db.
The transaction log This file holds a record of the changes made to the database, and is necessary for recovery and synchronization. It typically has the extension .log. See The transaction log.
The temporary file The database server uses the temporary file to hold information needed during a database session. The database server discards this file once the database shuts down—even if the server remains running. The file has a server-generated name with the extension .tmp.
The location of the temporary file can be specified when starting the database server using the -dt server option. If you do not specify the location of the temporary file when starting the database server, the following environment variables are checked, in order:
If none of these environment variables are defined, SQL Anywhere places its temporary file in the current directory on Windows operating systems, or in the /tmp directory on Unix.
The database server creates, maintains, and removes the temporary file. You only need to ensure that there is enough free space available for the temporary file. You can obtain information about the space available for the temporary file using the sa_disk_free_space procedure. See sa_disk_free_space system procedure.
Predefined dbspace files These files store your data and other files used by the database. See Predefined dbspaces.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|