What's new in Db2 DevOps Experience

Edit online

The Db2® DevOps Experience has been updated to include new features, enhancements, and fixes.

To enable these features, you must install the latest DevOps Experience PTF and the compatible UMS PTF. To choose the appropriate compatible PTF, refer to the UMS PTF compatibility table.

Table 1. Db2 DevOps Experience 1.3.0.13 (UO07250) new and changed functions
Feature Description APAR
Support for new object type DevOps experiences now supports a new object type: Global variable.
For more information, refer to the following topics:
PH70469
Configuration parameter for DevOps experiences The disableLegacyApplicationDryRun parameter is now added to the IZPDB2PM PARMLIB to optimize the application dry‑run performance.

For more information, refer to Experience-specific PARMLIB members.

Enhancement to the Sync application page The Sync application page now includes two new tabs:
  • Affected objects
  • Affected applications
For more information, refer to Synchronizing applications and Editing instance objects.		 PH69953
Support for drop 'Index' in user interface The following User Interface (UI) enhancements have been introduced for drop 'Index' operation in an instance:
  • A Dropped objects tab to display the list of 'Index' objects dropped in an instance.
  • A drop icon next to the 'Index' on the Db2 objects section of the instance edit DDL page.
  • An approve icon next to the 'Index' in the Dropped objects section of the Diff tab on the Pull request page.
For more information, refer to the following topics: 		PH70469
Table 2. Db2 DevOps Experience 1.3.0.12 (UO06223) new and changed functions
Feature Description APAR
Java arguments for worklist You can now use java arguments for generating a unique name for the worklist when submitting the JCL jobs. For more information on the list of worklist java arguments, refer to Db2 java arguments for performance improvement. PH68608
Support for JCL templates Provides JCL template support for applying the object changes in an instance and merging the pull request. For more information, refer to Managing JCL templates. PH69171
Table 3. Db2 DevOps Experience 1.3.0.11 (UO05308) new and changed functions
Feature Description APAR
Disabled support for Db2, version 11.1.0 Support for registering a subsystem in Db2 version 11.1.0 is disabled by:
  • The Version drop-down on the Registered tab will not display option 11.1.0.
  • The Discovered tab will not include check boxes for subsystems in Db2 version 11.1.0.
PH68332
Support for period character in the name field The name fields of applications, teams, environments, instances, site rules, DDL templates, saved searches, and favorite statements now support the use of the period (.) character.
Support for Delete Policy-Cache API You can now use the Delete Policy-Cache API to clear the appsVirtualRepository cache for applications and instances if the policy-cache name meets any of the following conditions:
  • The name is Application or applicationStatusReport.
  • The policy-cache name is not provided.
 PH67718
Support for 'saveForLater' parameter The following POST Instances APIs now support the saveForLater parameter:
  • /policy/instances/{instanceId}/addobjects
  • /policy/instances/{instanceId}/objects

You can set the saveForLater parameter to true to temporarily add the Db2 objects only to the instance manifest without including them in the Db2 catalog or instance. Later, when you want to add the Db2 objects to the Db2 catalog, you can use the ‘Apply All’ button to implement all pending changes from the instance manifest to the Db2 catalog.

 PH66748
Table 4. Db2 DevOps Experience 1.3.0.10 (UO03793) new and changed functions
Feature Description APAR
Support for dropping 'Index' objects using API You can now drop 'Index' objects from an instance using the drop API. For more information on the drop object functionality, refer to Instance drop API. PH66728
Approval for dropped objects in pull request If a pull request includes any dropped objects, those objects must be explicitly approved before the pull request is merged. Otherwise, the merge will fail with a message.

Now, an optional requestBody parameter has been added to the pull request approve and need-info APIs for approving or disapproving the dropped objects, respectively. For more information, refer to Pull request approve API and Pull request need-work API.
Supports overriding data sets for provisioning an instance You can now override data set definitions by configuring the required data set values in the dataSetOverrides section of the provisioning instance API payload. This section supports:
  • Overriding ADMINDATASET and GOCCM data sets.
  • Creating a new data set, such as Work Statement List (WSL) data set under CREDS.
 PH66333
Synchronizing applications Use the Sync application option to fetch the objects that are missing or newly added in the application and synchronize them with the catalog objects. Refer to Synchronizing applications. PH66420
Support modifying the Work Statement List (WSL) Use the convertWslToIspf parameter in the Resume-Merge API for the following:
  • Creating and modifying the WSL data set during failure.
  • Importing the modified WSL for fixing the Resume-Merge issues.
For more information, refer to Merging pull requests and APIs.		 PH66930
Table 5. Db2 DevOps Experience 1.3.0.9 (UO02762) new and changed functions
Feature Description APAR
Support for JCL templates Provides JCL template support for application registration and application instance-related jobs. For more information, refer to Managing JCL templates. PH65396
Improvement to instance provisioning

Instance provisioning is allowed when the application enters an apply error state while merging a PR. For more information, refer to Provisioning instances.
Enhancement to DDL protection

A proxy user protects the master DDL changes by acting as an authorization layer to control and restrict Db2 object changes. For more information, refer to Creating a proxy user.
Performance improvement Improved the performance of creating the applications for Db2 DevOps Experience.
Table 6. Db2 DevOps Experience 1.3.0.8 (UI99020) new and changed functions
Feature Description APAR
Creating editable JCL templates Db2 DevOps Experience offers new editable JCL templates in [conf_location]/jcl for the following:
  • Instance provision or deprovision jobs.
  • Register or unregister Db2 subsystem.

For more information, refer to Managing JCL templates and Editing JCL templates.

 PH63932
Improvement to Table DDL Db2 DevOps Experience supports modifying the Database or Tablespace name in the Table DDL. For more information, refer to Adding Db2 instance objects.
Table 7. Db2 DevOps Experience 1.3.0.7 (UI96715) new and changed functions
Feature Description APAR
Improvement in the scalability of UMS instance provisioning Utilized the additional ADB parameters in the REST API to enhance the scalability of UMS instance provisioning. PH60815
Table 8. Db2 DevOps Experience 1.3.0.6 (UI96247) new and changed functions
Feature Description APAR
Extended Referential integrity (RI) support Handled DELETE NO ACTION clause. Now, child tables with DELETE NO ACTION are considered required for the parent table. PH60225
DDL validation enhancement
  • Improved the DDL template global variable validations while creating DDL templates.
  • Improved the API performance of the Delete application and the Dryrun application.
Table 9. Db2 DevOps Experience 1.3.0.5 (UI94997) new and changed functions
Feature Description APAR
UI support for object creation templates Introduced a new DDL template option in the user interface. You can now use this option in the UI to manage templates and their links to different object types. Refer to Managing Db2 object templates. PH58157
External Db2 security You can now use an external Db2 security not only for subsystem registration but also for instance lifecycle workflow by moving the Suppress Db2 grants slider toward True during subsystem registration.
Performance enhancement  Improved the performance of the application and the instance workflow.
Table 10. Db2 DevOps Experience 1.3.0.4 (UI93733) new and changed functions
Feature Description APAR
API support for object creation templates You can now use API to perform CRUD operations for object creation templates. You can also link the object creation templates to other required object creation templates. PH56863
External Db2 security You can now use an external Db2 security for subsystem registration by moving the Suppress Db2 grants slider toward True during subsystem registration. For more information, see Registering Db2 subsystems.
Table 11. Db2 DevOps Experience 1.3.0.3 (UI93092) new and changed functions
Feature Description APAR
Instance add object supports specific name and version Support for specific name and version in the Db2 object instance when adding or searching for object types such as user-defined functions, stored procedures, and triggers. PH56032
Performance improvement Reduced file I/O operations by implementing the cache mechanism for Applications, Teams, Environments, and Subsystems.
Table 12. Db2 DevOps Experience 1.3.0.2 (UI92459) new and changed functions
Feature Description APAR
Creating object templates for different object types Supports object template creation for all object types in IBM Db2 DevOps Experience. Every object type will be delivered with a template file that contains a CREATE statement, which will be used when a new object is requested or as a required object of another object type. For details, see Adding Db2 instance objects. PH54940
View pull requests for super admin and team users Allows super admin and team users to access and view the pull request and the associated reports. For details, see Configuring pull request privileges.
Table 13. Db2 DevOps Experience 1.3.0.1 (UI91303) new and changed functions
Feature Description APAR
Instance management If the object is core and the associated application creation team and instance provisioning team are the same, associated application objects can now be modified in the instance. PH53501
The add object workflow now supports the addition of non-core objects.
You can now click the Preview changes button to review an impact report of pull request for application or associated applications.
To mark an application as complete, required objects from associated application will now be added as non-core objects.
Site rule enhancement Support is added for triggering site rules for associated applications core objects.
A site rule applied to the parent application will be enforced on the associated applications. The reverse is not available.
DDL enhancement Object DDL changes resulting in the dropping or recreation of objects or associated objects will be highlighted with a warning icon and a tooltip.
Table 14. Db2 DevOps Experience 1.3.0.0 new and changed functions
Feature Description
Application management You can change settings for an application. To perform this action from the applications page, click the overflow menu on the required application and click Change settings. For more information, see Changing application settings.