Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

ADO.NET documentation shows the possibility of setting the transaction level for a SQL transaction to Chaos. It sounds unpleasant, but if the feature is there, presumably it has some legitimate use.

The SET TRANSACTION ISOLATION LEVEL command in BOL (ah! see, I can use google and BOL) nothing seems to be named "chaos" and ADO.NET does have 5 modes that match up nicely to documented levels in addition to "chaos"

What or who is this Chaos level for? (And why does it have an unfriendly name?)

Refs: The ADO.NET enum

share|improve this question
Can you link to the relevant documentation that mentions a "chaos" isolation level? It might just be a scary name for READ UNCOMMITTED. –  Nick Chammas Nov 28 '11 at 18:44
Added a ref to the enum –  MatthewMartin Nov 28 '11 at 18:49
yes Microsoft Analsis services has chaos isolation level –  user13108 Oct 2 '12 at 23:19

2 Answers 2

Db2 has a transaction isolation level called "Chaos": http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.swg.im.dbclient.adonet.ref.doc/doc/DB2ConnectionClassConnectionStringProperty.html

Perhaps it's meant to be used for that.

share|improve this answer
Appears to be for System i only. Do you know what it means? I can't find much info about it, it says no commit so I assume it means that each statement is committed instantly. But this seems orthogonal to isolation level, so there is probably something else –  Lennart Aug 8 at 1:19
I'm really not sure, but I would assume it means no definable transaction isolation –  Dan Field Aug 9 at 14:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.