Parameter
dbs/db4/allow_cancel
Short text
Allow Cancel of SQL operations
Parameter Description
If enabled, DBSL will attempt a SQL Cancel on a (long-running) SQL operation if instructed to do so by the dispatcher, e.g. on a “stop transaction” request. Otherwise, the dispatcher will instead end the work process.
If dbs/db4/driver_type = XDA, parameter dbs/db4/allow_cancel = 1 will cause usage of Unix domain sockets if application server and database server reside on the same host, TCP/IP otherwise. Otherwise, if dbs/db4/allow_cancel = 0, a local connect is chosen.
If dbs/db4/driver_type = XDN, the connect_type is not influenced.
For more information, see SAP Note 705887 and 494086.
Application Area
Database
Default Value
blank
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
dbs/db4/connect_type
Values allowed
1, Y — SQL Cancel is allowed
0, N — SQL Cancel is not allowed
blank — Let DBSL decide to try
