PH58657: THIS APAR WILL PROVIDE A FIX FOR SELECTING RI OBJECTS FOR A STORED PROCEDURE EXPERIENCE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• We identified a problem when selecting Referential Integrity
  (RI) objects for a stored procedure, particularly when the
  procedure references an external function. The SQL query for
  checking external User Defined Functions (UDFs) appears to be
  incorrect, as it uses the NAME instead of the SCHEMA +
  SPECIFICNAME name, resulting in the issue.
  

Local fix

• BYPASS/CIRCUMVENTION:
  NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 DevOps Experience for z/OS  *
  ****************************************************************
  * PROBLEM DESCRIPTION: WARNING : server added a requiredObject *
  *                      that doesn't exist message in Db2       *
  *                      DevOps Experience                       *
  ****************************************************************
  In Db2 DevOps Experience, when creating an application the
  following might be incorrectly encountered when the application
  contains routines such as user defined functions.
  
  WARNING : server added a requiredObject that doesn't exist
  

Problem conclusion

• Apply the PTF that is provided by this APAR
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• IZPALOPL IZPB0A   IZPB0R   IZPB0T   IZPB0VA  IZPB0VR  IZPB0VT
  IZPB1A   IZPB1R   IZPB1T   IZPB1VA  IZPB1VR  IZPB1VT  IZPB2A
  IZPB2R   IZPB2T   IZPB2VA  IZPB2VR  IZPB2VT  IZPB3R   IZPB3T
  IZPB3VR  IZPB3VT  IZPB4R   IZPB4VR  IZPC1A   IZPC1R   IZPC1T
  IZPC1VA  IZPC1VR  IZPC1VT  IZPC2A   IZPC2R   IZPC2T   IZPC2VA
  IZPC2VR  IZPC2VT  IZPCHG   IZPCPYM2 IZPCPYML IZPD1A   IZPD1R
  IZPD1T   IZPD1VA  IZPD1VR  IZPD1VT  IZPD2A   IZPD2R   IZPD2T
  IZPD2VA  IZPD2VR  IZPD2VT  IZPD3A   IZPD3R   IZPD3T   IZPD3VA
  IZPD3VR  IZPD3VT  IZPD4A   IZPD4R   IZPD4T   IZPD4VA  IZPD4VR
  IZPD4VT  IZPD5A   IZPD5R   IZPD5T   IZPD5VA  IZPD5VR  IZPD5VT
  IZPD6R   IZPD6VR  IZPD7R   IZPD7VR  IZPGEN00 IZPGENER IZPHLVP
  IZPMAP   IZPMIG00 IZPMIGRA IZPMNFST IZPSERVE IZPSYNCY IZPUI
  IZPUSCP  IZPYAML
  

Fix information

• Fixed component name

  UNIFIED MGMT SV

• Fixed component ID

  5698UM100

Applicable component levels

• R120 PSY UI96248

     UP24/03/30 P F403

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.