I doubt that this comes up often, but I find myself in a bit of an argument about what isolation level will be used for transactions in our SQL Server database when the transaction is initiated by WebSphere. There are various documents that indicate how WebSphere can over ride this value.
I decided to dig into this a bit further.
In doing so, I found that I could monitor our SQL Server DB to determine this.
I have only found two places where the transaction isolation level is appearing:
1 - Sessions:Existing Connection.Text Data
2 - In a deadlock trace as part of the XML output.
If anyone can find it elsewhere, I'd love to hear from you. However, this makes sense, since this is more-or-less controlled at the session level.
If found that DBCC USEROPTIONS
would give me the *default* TIL for the db, but that if that TIL was altered by the session, it would not reflect that.
To get the TIL for *your session*, you can run the following query:
I was a bit surprised that not all RDBMS platforms offer robust, native support for regular expressions.
Oracle introduced this in 10g. It is implemented in roughly the way I would expect and looks like it's pretty useful. Reference
DB2 seems to have this capability in 9.7. NOTE that I have not checked to see if it was available in earlier releases. However, it appears you have to go through the XQuery interface. I'm not surprised by this, but a bit disappointed. I had hoped for an implementation more like Oracle's. I think that the DB2 way is going to be cumbersome for the average user.
Example: db2 "with val as (
from texts t
where xmlcast(xmlquery('fn:matches(\$TEXT,''^[A-Za-z 0-9]*$'')') as integer) = 0
select * from val"Reference1, IBM DB2 for LUW 9.7 information center referenceMS SQL Server: SQL Server, it seems, requires you to roll your own solution or look to some sort of 3rd party. I'm very s…