Previous topic  Top  Next topic  Print this Topic
 

Database File Layout

 

This is an excerpt of the H2 website describing the database file layout. The following files can be created by the database:

File Name

Description

Number of Files

edb.data.db

Data file contains the data for all tables Format: <database>.data.db

1 per database

edb.index.db

Index file contains the data for all (btree) indexes Format: <database>.index.db

1 per database

edb.0.log.db

Log file The log file is used for recovery Format: <database>.<id>.log.db

0 or more per database

edb.lock.db

Database lock file Exists only if the database is open Format: <database>.lock.db

1 per database

edb.trace.db

Trace file Contains trace information Format: <database>.trace.db If the file is too big, it is renamed to <database>.trace.db.old

1 per database

edb.14.15.lob.db

Large object Contains the data for BLOB or CLOB Format: <database>.<tableid>.<id>.lob.db

1 per object

edb.123.temp.db

Temporary file Contains a temporary blob or a large result set Format: <database>.<session id>.<object id>.temp.db

1 per object

edb.7.hash.db

Hash index file Contains the data for a linear hash index Format: <database>.>object id>.hash.db

1 per linear hash index