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 |