Create a Read-only Database
The process to create a read-only database is as follows:
1. Create a checkpoint with journal of the source database:
ckpdb +j +w source_db
2. Create a directory for the read-only database:
mkdir /tmp/readonly_dbloc
mkdir /tmp/readonly_dbloc/ingres/data/default
3. Create a location in iidbdb to the readonly_dbloc directory:
sql iidbdb
create location readonlyloc with area='/tmp/readonly_dbloc', usage=(database)
4. Copy the database related files to the readonly_dbloc directory:
cp -r $II_SYSTEM/data/default/source_db/* /tmp/readonly_dbloc/ingres/data/default
5. Create the read-only database:
createdb -r readonlyloc readonly_db
Note: Use the -encrypt flag while creating a read-only database if the source is an encrypted database. The passphrase of the source database should also be specified for the read-only database.
Last modified date: 01/28/2026