What's new in Db2 DevOps Experience

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.2.0.9 (UI83150) new and changed functions
Feature Description APAR
Miscellaneous Improved error messaging while performing a pull request merge in Db2 DevOps Experience. PH50629
Table 2. Db2 DevOps Experience 1.2.0.8 (UI82464) new and changed functions
Feature Description APAR
Miscellaneous The default value for UNLOAD_ALTERED_TABLES in IZPD2DPM is now configured as DES. PH49391
Table 3. Db2 DevOps Experience 1.2.0.7 (UI81667) new and changed functions
Feature Description APAR
Instance management You can now change the name and owner of a provisioned instance. To perform this action, click the overflow menu of an instance and select Change settings. PH47789
Site rule enhancement You can now assign newly created site rules to applications or environments from the create site rule page.
Miscellaneous The UNLOAD_ALTERED_TABLES attribute in IZPD2DPM now supports YES and No values.
Table 4. Db2 DevOps Experience 1.2.0.6 (UI80702) new and changed functions
Feature Description APAR
Site rules The following enhancements have been done to the site rules:
  • You can now create a site rule for adding columns only at the end of the column list. After applying this site rule, if you edit the DDL of the table object and add a column at the beginning or in the middle of the column list, the following site rule violation will be displayed: New columns must be added at the end of the column list.
  • You can specify a new site rule that validates whether the tablespace object is of the UTS (universal tablespaces) type. To validate, set the following site rule: Tablespace TSTYPE must be UTS. To know the prerequisites that are needed for creating this site rule, see Object attribute variables.
PH45030
DDL management While adding a new object or editing the DDL of an existing object, you can now enter any number of characters on one line in the DDL editor because the restriction of entering only 72 characters per line has been removed.
Subsystem management
  • You can now forcefully delete a subsystem that is unreachable. To unregister such a subsystem, click the Unregister button on the Remove subsystem window. You can also remove an unreachable subsystem by specifying forceDelete=true in the Deregister Db2Subsystem API.
  • You can now specify the values for all the subsystem registration parameters by using the register.JCL file. To know how to modify these parameters, see Updating subsystem registration parameters.
Db2 for z/OS® support Support has been added for Db2, 13.1 (5698-DB2)V13 subsystem in UMS. You can now register a V13 subsystem on UMS.
Table 5. Db2 DevOps Experience 1.2.0.5 (UI79786) new and changed functions
Feature Description APAR
Instance management An invalid instance status is now resolved correctly when home objects are moved to another application. PH44661
You can now view the database and instance schema map on the instance details page.
Site rules enhancement Different icons are now shown for new and old site rule violations.
Application management You can now view DDL for an application.
API enhancement Added support for new APIs to fetch the pull request details. For more information, see Support for new APIs.
Table 6. Db2 DevOps Experience 1.2 PTF 4 (UI77752) new and changed functions
Feature Description APAR
Application management To ensure that the instance of an application gets successfully provisioned, Alias of a table is now included as a required object of the table while creating that application. PH40911
Git exception resolved while merging the pull request.
Instance management You can now add a new database to an instance.
Db2 privileges The following parameters are added in the PRIVILEGE section of the configuration_db2_devops.yaml file:
  • SYSTEM_PRIVILEGE

    System privileges are BINDADD and CREATEALIAS. The default value is true.

  • DEV_PRIVILEGE

    The DEV privileges are CREATEIN, ALTERIN, DROPIN and COLLECTION. The default value is true.

  • DBADM_PRIVILEGE

    The DBADM privilege is DBADM. The default value is true.
Subsystem management You can now specify a new owner for all the databases and table spaces that are created in a subsystem by specifying a new value for the dbaSqlid parameter while registering a subsystem.
You can now connect to the subsystem by using a specific user ID and password instead of using the global DBA user ID.
Miscellaneous Improved error messages in the Unified Experience UI.
Improved icon alignment in the Unified Experience UI.
Granular control is now allowed for granting Db2 privileges.
Improved dry-run operation performance for REST API.
Improved the installation verification program for Db2 DevOps Experience.
Table 7. Db2 DevOps Experience 1.2 PTF 3 (UI76508) new and changed functions
Feature Description APAR
Application management You can now move home objects to another application. PH39078
Improved the workflow for deleting an application from UI.
Instance management All pull requests except merged and declined are listed on the dashboard.
To avoid the application from going in an inconsistent state, indexes and triggers can be added only if the table is present in originating the application.
Db2 object renaming is not supported to prevent object duplication.
You can now rename an instance using patch API.
Instance polling is stopped if the instance is in apply error state and changes are discarded from the UI.
DDL Management The new variable NICE_NAME is added in the DDL_FILE_NAME_PATTERN section of the configuration_db2_devops.yaml file. The default value of the NICE_NAME parameter is true. Use this feature to define user friendly DDL file names. This feature helps in locating relevant files if an application contains multiple objects of the same type. UI75418
Miscellaneous The following updates are made in the APPLY and MERGE sections of the configuration_db2_devops.yaml file:
  • The default value of the RUN_REORG_REBUILD parameter is now A.
  • A new parameter TAKE_AN_IMAGE_COPY with a default value of B is added.

To use these parameters, add them to IZPD2DPM and then restart UMS.

 UI75418
The IZP_DB2_POST_INSTALL parameter is removed from the configuration_db2.yaml file because it is no longer needed while installing the Db2 DevOps Experience.