New and changed functions

This topic summarizes the recent enhancements and changes in IBM Db2 DevOps Experience for z/OS.

V1.1.0.6 (PTF7): March 15, 2020

Description Related APARs
Site rules:
  • Fixed: Incorrect validation messages were displayed when editing site rules created in PTF5.
  • Fixed: Environment deletion was not cascaded to complex site rules.
  • Fixed: The db2complexsiterules.yaml file was incorrectly stored in the var/conf directory.
 PH22352
Db2 support:
  • Fixed: Added support for FL levels lower than 500.
 PH22073
Subsystem registration:
  • Fixed: GOCCM generated during subsystem registration was incorrect.
 PH22070

V1.1.0.6 (PTF6): December 13, 2019

Description Related APARs
Site rules:
  • Extended site rules to all objects
  • Support for complex site rules
 PH19180
Subsystem registration:
  • Added "Copy From" option for registering new subsystems using the definition of an existing subsystem
 PH19180
Application and instance management:
  • API support for provisioning into a specific schema, database, and collection
  • Performance fixes for instance management
  • Fixed: team administrator deprovisioning issues
  • Fixed: failing to provision an instance containing a Java stored procedure with a JAR object in the Db2 catalog
  • Fixed: Not ignoring collid when comparing the DDL of stored procedures
  • Fixed: Allocating datasets as NEW,KEEP could cause errors. Now allocating datasets as NEW,CATLG.
  • Fixed: Added support for providing collid/schema name as input when provisioning an instance
 PH19180, PH12677, PH19167, PH19179, PH19160
Security and authorization:
  • Support for CA Top Secret® security manager
  • Support for secondary authorization for dbaUser
 PH19180
Installation:
  • Enhanced installation script
 PH19180
Job Administration:  
Miscellaneous:
  • Support for open source Zowe as a prerequisite
  • Support for providing a custom HLQ (high level qualifier) for temporary files
  • Fully documented Swagger request JSON
 PH19180, PH19110

V1.1.0.5 (PTF5): August 30, 2019

Description Related APARs
Application discovery:
  • Added a “Select All” option for selecting objects while creating an application
  • Added “Expand All” and “Collapse All” options for object selection when creating an application
  • The Application Builder now requires parent applications to have a Db2 Object
 PH15869
Application and Instance Management:
  • Enhanced capabilities for deploying changes into higher level environments (i.e. integration testing, staging, pre-production, production)
  • Created an API to keep track of the number of times an application has been provisioned, by whom, and when
  • Fixed an error in the Swagger documentation of the POST body that was causing an internal server error
 PH15869, PH16034
DDL management:
  • Editing DDL and adding objects are now prohibited after a pull request is issued against an instance
  • New objects do not appear in the difference section after the pull request is approved and merged.
 PH15869, PH16036
Security/Authorization:
  • Added support for CSRF_SWITCH in z/OSMF
  • Made API changes to support secondary authorization for dbaUser
 PH15869
Installation:
  • Created a sample JCL procedure to start the server
  • Made all SMP/E-managed directories read-only and all user-managed directories read/write
  • The setup wizard now recognizes the lower cased “dbaUser”
  • Users only enter a port number in one location now, instead of two, to prevent problems that arose when users did not enter the same port number in each location.
PH15869, PH16035
Job Administration:
  • You can now configure a prefix for submitted jobs
 PH15869
Miscellaneous:
  • Added site rules for missing data types and storage groups
  • Added support for subsystem location names with more than 8 characters or underscores (_).
  • Stopped unnecessary regeneration of the DDL on application color change
  • Resolved the "Error searching Db2 objects" that occurred when searching for table spaces
  • Resolved a problem that caused the DOE Server to stop and leave objects in uncertain states
  • Resolved a problem with SYSAFF discovery and validation
 PH15869, PH15925, PH12365, PH09306

V1.1.0.4 (PTF4): July 3, 2019

Description Related APARs
Application discovery:
  • When you create an application and select an object, its child objects are selected automatically.
  • You cannot add implicit sequences to applications.
 PH13718
Application and Instance Management:
  • Fixed an issue handling user instance limits when working with multiple environments.
  • The Admin team can now access the Manage tab.
  • You can search for teams while provisioning instances.
  • The Admin team can de-provision team instances.
  • You can no longer include cast functions in application definitions.
  • Added support for applying site rules to databases, tablespaces, tables, indices, and stored procedures.
  • Added API support to allow deployment of an application's master DDL to a target subsystem.
 PH13718
API:
  • Fixed issues with /policy/pull-requests POST API where lower case reviewer names generated an error and required manually removing the related yaml file and restarting the DOE server. The API now converts reviewer names to upper case, and makes sure that reviewers are on a team associated with the pull-request application.
  • Fixed an issue with the swagger.json API document where the __yamlClass in the requiredApps section of the /policy/applications POST API did not display clearly.
 PH12194, PH09308
DDL management:
  • Fixed an issue where, when you edited DDL in a provisioned instance and the browser session times out, after refreshing the screen the Apply object changes button was incorrectly grayed out.
  • On the "Edit DDL & SQL" page, the Revert and Revert All buttons are disabled by default.
 PH13718, PH09302
Installation:
  • Added a field to the DevOps set up wizard for users to enter a name for a data set that will contain artifacts created when a DevOps user registers a Db2 subsystem. The value is stored in an editable cmBatchDsn parameter in the configuration.yaml file.
  • Added four ISPF library parameters to the configuration.yaml file. Previously, these values were hard-coded. In configuration.yaml, they are editable.
 PH13718
Pull requests:
  • Fixed issue where the IDs of de-provisioned instances were displaying in the Past Activity UI.
 PH13718, PH12194
Cosmetic changes:
  • Fixed a UI issue with overlapping objects in the "Edit DDL & SQL" page.
 PH13718
Documentation:
  • Improved the Db2 Set Up wizard field labels and hover help.
  • In the appendix, added a JCL script that you can run to configure DevOps security.
  • In a new Granting catalog and bufferpool access topic, added a DCL script that you can run to grant to PUBLIC the use of all bufferpools and also SELECT access on Db2 catalog tables (except SYSIBM.USERNAMES). This is required before you install DevOps.
  • Simplified and clarified some installation topics.
  • In the DevOps installation topic, clarified when and how the user should restart Zowe during installation.
  • In the DevOps installation topic, clarified how to specify values for DOE_HOME and LIB_DIR in the doeserver.sh file.
 PH13718

V1.1.0.3 (PTF3): May 14, 2019

Description Related APARs
Application discovery:
  • Added views, synonyms, aliases, stored procedures, functions, and triggers to the list of object types you can add to applications.
  • Added a feature in the object discovery UI to exclude dependent objects. By default, when you select objects their dependent objects are included in the application.
  • Fixed an issue with searching for objects using the underscore(_) wildcard.
 PH11593
Application and Instance Management:
  • Fixed an issue with objects that were added to an instance and then merged not propagating to other instances of the application after a pull.
  • Fixed issue with merge conflicts occurring when creating application instances after new objects were added to the application.
  • Fixed an issue with provisioning instances with source data if a table in the application name contained an underscore(_).
  • Fixed an issue with creating applications containing system temporal tables.
  • Fixed an issue with creating applications containing archive tables.
  • Fixed an issue with UDF type objects that were added to an instance and then merged not propagating to other instances of the application after a pull.
  • Fixed an issue with creating applications containing large objects (LOBs).
  • Fixed an issue with creating applications during DDL generation.
 PH11593, PH11598
DDL management:
  • Only members of an application's owning team can modify its instance DDLs. (All users can still provision instances and view instance DDLs.)
  • Fixed an issue with storing auxiliary table DDLs in two places.
  • Fixed an issue with DDL changes not reverting after an attempt to apply object changes failed.
 PH11593
Support update:
  • Support for Db2v12 function level 504
 None
Cosmetic changes:
  • Fixed an issue with search on the Instances page being case-sensitive. It is no longer case-sensitive.
  • Fixed an issue with the "Required Applications" dropdown field displaying incorrectly in the UI.
  • Fixed an issue with allowing users to type lower-case characters in subsystem registration page fields that should only allow upper-case values.
 PH11593
Documentation: None

V1.1.0.2 (PTF2): April 3, 2019

Description Related APARs
Application discovery:
  • Re-factored application discovery functionality for enhanced performance and usability.
  • Redesigned the graph display and selection mechanism with a tabular format populated from user-specified search criteria.
  • Users can select individual objects and add them to a list of objects to be included in an application.
  • Upon submission, the system automatically adds any required object(s) to ensure the application definition is valid.
  • Objects that depend upon selected objects are also automatically added.
 None
Site rules:
  • Optionally, site rules can now be applied to future applications by default.
  • Fixed an issue with the “INDEX UNIQUE must_be_absent/present” rule.
 None
DDL management:
  • Made cosmetic usability enhancement and minor content corrections to the DDL Diff page.
  • Fixed an issue with adding objects to existing applications.
  • Fixed an issue with the state of the "Apply these DDL changes" button.
  • Fixed an issue with nested views when generating DDL.
  • Fixed an issue with aliases when generating DDL.
  • Fixed issues with the DDL Change Report content.
 PH09305
Application and instance management:
  • Users can now refresh page content for Application Management and Instance Management.
  • Fixed issues with application deprovisioning.
  • Fixed an issue with provisioning applications without a database or tablespace.
  • Fixed an issue with stored procedure qualifiers during instance provisioning.
 PH09307
Pull request management:
  • Fixed an issue with the list of pull requests to approve.
  • Fixed a problem with viewing stored procedure changes in pull requests.
 None
Cosmetic changes:
  • Enhanced hover behavior to ensure all data is visible.
  • Fixed the application tile header color behavior.
  • Fixed selected application highlight behavior.
  • Fixed the position of the status bar.
 None
User and team management:
  • Fixed a performance issue with the user and team management pages.
 None
Documentation:
  • Improved Swagger documentation.
 PH09303, PH09304, PH09308