isolation level : dirty read 
Author Message
 isolation level : dirty read

Hi Guys,
Just tel me please what am I messing here :
I create a index in a big table. and when the creation is processing, I do a
set isolation to dirty read and a select from this table, but I get a
surprise, I get the next error :
242: Could not open database table (informix.booking).
   106: ISAM error:  non-exclusive access.
I tought that with isolation to dirty read I can select from this table.
So can some one tel me what am I messing here please ..
Thanks

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://www.***.com/



Sat, 05 Jun 2004 03:48:38 GMT
 isolation level : dirty read

dirty read still requires table to be read in non exclusive
mode for getting the table structure etc. Hence ur query failed
since it couldn't read the system catalog table for table structure.

Ravi


Quote:

> Hi Guys,
> Just tel me please what am I messing here :
> I create a index in a big table. and when the creation is processing, I do
a
> set isolation to dirty read and a select from this table, but I get a
> surprise, I get the next error :
> 242: Could not open database table (informix.booking).
>    106: ISAM error:  non-exclusive access.
> I tought that with isolation to dirty read I can select from this table.
> So can some one tel me what am I messing here please ..
> Thanks

> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx



Sat, 05 Jun 2004 05:17:39 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. isolation level ( dirty read ) on OPS node

2. Dirty read isolation level

3. trick for setting isolation dirty read in an Ace report

4. GQL: Set isolation to dirty read?

5. Undocummented: SET ISOLATION TO DIRTY READ

6. Isolation level READ UNCOMMITTED

7. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

8. Transaction at isolation level Read Committed blockage problem

9. Transaction at isolation level Read Commited blockage problem.

10. TRANSACTION ISOLATION LEVEL - need advice for read-only queries

11. JDBC isolation level "read committed"

12. "the read uncommitted transaction isolation level"


 
Powered by phpBB® Forum Software