A fix is available
APAR status
Closed as program error.
Error description
Select LEFT OUTER JOIN needed for SYSENVIRONMENT table
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: When navigating the Db2 catalog, the * * existing views cannot be displayed * * if the SYSENVIRONMENT catalog table * * has no matching ENVID. * **************************************************************** When Db2 Administration Tool fetches information about views from the system catalog, no information can be retrieved if the ENVID value for the view has no counterpart record in SYSENVIRONMENT.
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH55780
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-07-14
Closed date
2023-07-31
Last modified date
2023-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI92973
Modules/Macros
ADB21 ADB21A ADB21C ADB21E ADB21H ADB21J ADB21K ADB21P ADB21TC ADB21VV ADB21VV0 ADB21Y ADB2ALL0 ADB2AT ADB2ED3 ADBPZAC ADBPZAT
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI92973
UP23/08/01 P F307 ¢
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 August 2023