dbs/mss/update_with_updlock SAP Parameter attribute - MSSQL: Set UPDLOCK hint on all UPDATE SQL statements

dbs/mss/update_with_updlock is a SAP Parameter attribute which is used to control MSSQL: Set UPDLOCK hint on all UPDATE SQL statements 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/mss/update_with_updlock profile paramerter attributes

Parameter Name: dbs/mss/update_with_updlock
Description: MSSQL: Set UPDLOCK hint on all UPDATE SQL statements
Default Value: 0
Parameter Type ( See IF_PARAMETER_TYPES): String(STRING)
Restriction Values:
Parameter Unit:
Parameter Group: Database
CSN Component: BC-DB-MSS
System-Wide parameter: No
Dynamic Parameter: Yes
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

When this parameter is turned off, SQL UPDATE statements will no longer contain an added hint: UPDLOCK HOLDLOCK. This hint has been used for years in MS SQL Server to avoid deadlocks mainly in the spool area (TSP tables). The hint does reduce concurrency, so if no deadlocks are observed without this flag, it can be turned off to gain some performance through increased concurrency.

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