This article describes the XDB.INI setting in SQL Option for DB2 which will allow the transaction dialog box to be disabled when connecting through XDBLink.
Problem:
When connecting to a DB2 location using SQLWizard or Migrate you first receive a transaction dialog box which includes the following text:
Complete the transaction which will free locks and close queries.
At this point you must click commit, rollback, or proceed. Can this transaction dialog be disabled so that it will not display when connecting to the mainframe location?
Resolution:
Yes, there is an XDB.INI setting in SQL Option for DB2 which will allow you to disable the transaction dialog box when connecting through XDBLink.
[MultiUser]
IsolationLevel=Cursor Stability
TimeOutInterval=10
AutoCommit=OFF
BackwardLog=Off
ForwardLog=Off
CommitAtLogin=On
With CommitAtLogin the transaction dialog box will be disabled.
#MFDS
#EnterpriseDeveloper
