Hi,

I am using IDS 9.3.

How do i create a read-only database using dbaccess.

Thanks,
Anu_r

You can't.

You have a few possibilities:
1. Use HDR to create a read-only instrance. In th eprimary instance you can create a database that is fully query-able in th esecondary database server.
2. You can create a standard database and make sure that the users who connect to this database only have select permissions.
3. Create you database and make sure that your read-only data resides on an optical disk using the optical disk subsystem.
4. Create your own interface with VTI (Virtual Table Interface)

Thanks!! Can you give me a link to the documentation that describes the methods you state. I will try.

I tried a HDR sometime ago but unfortunately could not do it.

Anu_R

In reply to yr private msg:

ONDBSPACEDOWN 2
# Dbspace down option: 0 = CONTINUE, 1 = ABORT,2 = WAIT

This is a parameter in the $INFORMIXDIR/etc/$ONCONFIG file.

To bring down a dbspace, issue the command:
onspaces -s <dbspace> -p <path> -o <offset> -D -y

To bring a dbspace up, issue the command:
onspaces -s <dbspace> -p <path> -o <offset> -O -y

onspaces -- will give you an overview.