A fix is available
APAR status
Closed as program error.
Error description
List of all internal bugs/stories fixed for PTF3: * User should be added with the SPECIAL attribute * POST application for a TS created in implicit DB expects qualifier field to be filled * (Non-fatal) DOES002E sqlcode -104 when viewing instance with java SP * Add option to specify dependent objects should be added or not * Provisioning with dataseed fails when table have underscore in name * When user adds the definition for new object and click on 'add object' button, then screen gets blank * DDL Change Report gives false impression of object having been dropped/created * We do not tolerate 504 function level for Db2v12 * Trying to view a PR with status error leads to an empty screen and makes user to re-open the application from scratch * Delete Application is not working. * Problems creating an application with system temporal table * Problems creating an application with archive table * DDL for auxiliary table is repeated * API: Support Database and TableSpace arguments in Table search * User is able to set 2 different application with the same name by just editing the application(Application name is case-sensitive while editing application) * Revert doesn't work if Apply Object Changes fails * API Authorization : When using a Rest client, Calls to APIs are going thru without providing basic auth * Search on "Instances" is case sensitive * Application Create UI should default '%' at end of search filter * '_' in Search API works same as % * Add Object - Unable to create a pull request after adding UDF * If the application has the status as 'deleting', then that application name is coming in the drop down on new instance creation wizard * Provisioning Error for application with LOB * If user rename the application name just while the ddl_generation is in progress, then existing application's name gets deleted and then ddl for new application name gets generated. * Edit application - change color - cosmetic issues * When Application Discovery is loaded for the first time, an exception is seen. * Source Sub system not visible for a committed application * Possible to enter lowercase characters in some fields * Add UI support for site rule "assign to all future apps" * If user creates an Instance with only one object as Database, then on View Instance page for space there is no unit displayed(Unit should be Giga Bytes) * UI is getting distorted when user selects all the application from the drop down of 'Required applications' * Application Discovery Added to the list of object types you can add to applications to include views, synonyms, aliases, stored procedures, functions and triggers. Added a feature in the object discovery UI to exclude their dependent objects. By default, dependent objects are included in the application. Fixed an issue with searching for objects using the underscore(_) wildcard. * Application and Instance Management 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. * 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 DLL changes not reverting after an attempt to apply object changes failed. * 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. * Db2v12 function level 504 support
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users * **************************************************************** * PROBLEM DESCRIPTION: Application Discovery * * - Added to the list of object types you * * can add to applications to include * * views, synonyms, aliases, stored * * procedures, functions and triggers. * * - Added a feature in the object * * discovery UI to exclude their * * dependent objects. By default, * * dependent objects are included in the * * application. * * - Fixed an issue with searching for * * objects using the underscore(_) * * wildcard. * * * * 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. * * (PMR02138,999,000) * * - 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. * * * * 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 DLL changes not * * reverting after an attempt to apply * * object changes failed. * * * * 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. * * * * Db2v12 function level 504 support * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** .
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH11593
Reported component name
DB2 DEVOPS EXPR
Reported component ID
5698DEX00
Reported release
110
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-04-29
Closed date
2019-05-14
Last modified date
2019-06-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI63018
Modules/Macros
DOESERVE DOEUI
Fix information
Fixed component name
DB2 DEVOPS EXPR
Fixed component ID
5698DEX00
Applicable component levels
R110 PSY UI63018
UP19/05/17 P F905
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"110","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 June 2019