Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Posts
    38

    Question Unanswered: Read only database

    Hi,

    I am using IDS 9.3.

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

    Thanks,
    Anu_r

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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)
    rws

  3. #3
    Join Date
    Jun 2003
    Posts
    38
    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

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

  5. #5
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •