Application development enhancements

The Db2 12.1.3 release includes application development enhancements to lock management for SQL PL developers.

The following table displays a list of the new application development enhancements in Db2 12.1.3:

Table 1. Application development enhancements in Db2 12.1.3.
Enhancement	Description
Application locking enhancements	The DBMS_LOCK module, which provides application locking, now supports Shared locking (`lockmode = S_MODE`) and Transaction scope locking (`release_on_commit = TRUE`). The underlying implementation now uses Db2 locks rather than rows in SYSTOOLS.DBMS_LOCK_DET, and these operations can now be seen in lock monitoring. See the documentation for the DBMS_LOCK REQUEST, RELEASE and CONVERT functions for the specific parameter values that are now supported and a more detailed description of the behavior. Note: To use this new functionality on a pre-12.1.3 Db2 database, you must first run db2updv121 against it with the -a option, to recreate the underlying module objects.