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.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 2. 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 3. 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 4. 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 5. 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 6. 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 7. 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 8. 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 9. 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 10. 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 11. 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 12. 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. |