Sample Header Ad - 728x90

Isolation level at the database level for IBM DB2 LUW

2 votes
1 answer
647 views
How do I determine the default isolation level for our 11.5 DB2 instance running on Linux? I see there is a "special register" from [this IBM documentation](https://www.ibm.com/docs/en/db2/11.5?topic=registers-current-isolation) , however I'm not a DB2 expert so I'm not sure where to look for that, or how to "see" values for "special" registers. I also looked at [this](https://www.ibm.com/docs/en/db2/11.5?topic=mpf-mon-get-connection-details-table-function-get-connection-metrics-as-xml-document) , but I am having no luck understanding how to obtain the current isolation from that either.
Asked by Hannah Vernon (70988 rep)
Oct 18, 2023, 08:15 PM
Last activity: Oct 18, 2023, 09:09 PM