Toad World® Forums

Pushing a default DB2 Isolation Level to users of Toad Data Point

We use Toad Data Point 3.4 in our shop. We would like to push a default DB2 Isolation Level out to all our users of Toad. Is this possible? Does the default/current setting exist in some configuration file that can be manipulated?

I know the interactive way of changing the isolation level from within Toad.

Thanks,

Scott

Hello Scott,

Toad settings are set under your user profile.

Default isolation parameter can be found in DB2.xml file:

C:\Users<>\AppData\Roaming\Quest Software\Toad Studio <>\ModuleSettings\DB2.xml

<SOAP-ENV:Envelope xmlns:xsi="www.w3.org/…/XMLSchema-instance&quot; xmlns:xsd="www.w3.org/…/XMLSchema&quot; xmlns:SOAP-ENC="schemas.xmlsoap.org/…/&quot; xmlns:SOAP-ENV="schemas.xmlsoap.org/…/&quot; xmlns:clr="schemas.microsoft.com/…/1.0&quot; SOAP-ENV:encodingStyle='schemas.xmlsoap.org/…/&quot;>

SOAP-ENV:Body

<a1:DB2Settings id=“ref-1” xmlns:a1="schemas.microsoft.com/…/ToadDB2%2C%20Version%3D6.1.0.16569%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull&quot;>

Read Committed

</a1:DB2Settings>

</SOAP-ENV:Body>

</SOAP-ENV:Envelope>

It affects newly created connections.


Isolation level is also part of connection configuration. To accomplish you task you could also distribute pre-set connection file for your users.

**

C:\Users<>\AppData\Roaming\Quest Software\Toad Studio <>\Connections.xml

3

Read Committed

True

Libor

Thank you Libor!!