After the statements are stabilized, the stabilized access path can be retrieved and used from the catalog tables at full prepare when Db2 does not find the statements in the dynamic statement cache. Db2 can provide consistent performance with a stabilized dynamic SQL statement. Performance improvement for the dynamic prepare is also possible when the statements are found in the catalog instead of having to go through a full prepare. 

This feature is expected to be useful during workload transitions, configuration changes, and when applying future Db2 maintenance upgrades. 

Dynamic statement stability requires the activation of Function Level 500 or greater and provides various monitoring and statistics changes in prepare operations. 

## 1.3 Other key features in Db2 12 for z/OS 

The key improvements and features that are delivered by Db2 12 for z/OS in addition to performance improvements are described in this section. For more information about Db2 12 features, see IBM DB2 12 for z/OS Technical Overview , SG24-8383. Db2 12 for z/OS also includes the following other key features: 

## 1.3.1 Mobile application enablement 

GLYPH<SM590000> Mobile application enablement 

GLYPH<SM590000> Resiliency and continuous availability 

GLYPH<SM590000> Simplified migration and continuous delivery support 

A large set of new SQL capabilities are introduced or enhanced in Db2 12 to encourage the application development and porting in Db2 for z/OS. 

## RESTful API 

Db2 Adaptor for z/OS Connect enablement, introduced in Db2 11, made it faster and easier to deploy RESTful services that access Db2 data. However, this solution requires the installation and setup of z/OS Connect services. 

To speed up application deployment, native REST support is now built into Db2. With native REST API support, Db2 DDF address space provides a set of services to replace the Db2 Adaptor and z/OS Connect features. JSON is used to pass input and return the results back to the requester. Native REST API support is available in Db2 12 and Db2 11 (with APAR PI66828). 

## Application enablement 

Db2 12 expands SQL capability to continue to support and attract today’s application development. 

Enhancements in application enablement include advanced triggers, which allow developers to create the logic within a trigger. An enhanced MERGE statement is now aligned with the behavior that is defined in the SQL standard and Db2 family, and now allows you to delete from the target tables. Db2 12 provides SQL propagation features that support both numeric and data dependent pagination. 

Piece-wise data modification support allows the developer to specify a FETCH FIRST clause for a DELETE statement and issue a COMMIT. This ability addresses many possible concerns, such as lock contention, long-running UR, and CF effect or recovery. 

