Re: Locking in Exclusive mode is not working as I thought!!!

Carlson@WHSmith (carlson1@bellsouth.net) wrote: : Here's the error message description: : -256 Transaction not available. : : You cannot begin a transaction in this database because it : does not have a transaction log. In order to support : transactions you must start a transaction log. With the : INFORMIX-OnLine Dynamic Server this is done by the : OnLine administrator (using the Databases screen of the : Logical Logs menu of DB-Monitor or ON-Monitor). With : other database servers it is done using the START : DATABASE statement. _Real_ men use the command line (ontape). : The given database isn't using transaction logging. : Which drove me to some additional research . . . what happens when : there's no transaction logging for the database? : I was able to select on a table that was locked . . . truly peculiar. Open another window and investigate the session that was selecting. You will notice an Isolation level of NL (non-logging, I think). there are no isolation levels. Now try to update a row in that table. You will notice that the level is pretty much like Dirty Read. : John Carlson : Informix DBA : WHSmith USA