Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    24

    Unanswered: 256: Transaction not available

    Hi Friends,
    I have installed informix IDS9.21 FC7 on Hp -UX machine.
    but when i try to access tables from database, i am able to work
    very proper through dbaccess, but not through isql.
    i am gettting this error.

    $isql system

    set isolation dirty read;
    select * from iivnd


    the error is :
    256: Transaction not available.

    please advise/suggest me to fix this problem.


    thanks

    Sundar

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    In order to have transactions (ie Begin...Commit) you must turn on logging for a given database.
    Fred Prose

  3. #3
    Join Date
    Jan 2005
    Posts
    24

    how to turn on logging in informix

    Hi Friends,
    I am new to informix. I have installed and created databases , but
    this problem i have been getting since last three days.
    please tell me the command to turn on logging on the database.

    thanks

    sundar

  4. #4
    Join Date
    Nov 2004
    Posts
    143
    Hi,

    Use ontape command for changing the logging mode like
    ontape -s -L 0 -A or -B db_name

    -A : set the following database(s) to ansi logging
    -B : set the following database(s) to buffered logging

    Bye

Posting Permissions

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