dbs/db4/allow_cancel SAP Parameter attribute - Allow cancel of SQL operations using 'Stop Transaction'

dbs/db4/allow_cancel is a SAP Parameter attribute which is used to control Allow cancel of SQL operations using 'Stop Transaction' information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the attributes values .

dbs/db4/allow_cancel profile paramerter attributes

Parameter Name: dbs/db4/allow_cancel
Description: Allow cancel of SQL operations using 'Stop Transaction'
Default Value:
Parameter Type ( See IF_PARAMETER_TYPES): String(STRING)
Restriction Values:
Parameter Unit:
Parameter Group: Database
CSN Component: BC-DB-DB4
System-Wide parameter: No
Dynamic Parameter: No
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

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.

See SAP Parameter Documentation for full SAP documentation for this profile parameter.