A fix is available
APAR status
Closed as program error.
Error description
Per PMR 60107,999,000. This APAR enhances PM33752 / PM33750. ================================================================ Date reported: 06/10/2011 Severity: High Users Affected: All IMU users of MU V3.2 who applied PTF # UK66901 Problem Description: Customer is getting "DCLQUE-02,012 "&OWNER.&TBNAME" CANNOT BE RESOLVED FROM DB2 CATALOG" when &OWNER is an ALIAS. Problem Summation The logic that was implemented by PTF # UK66901 (APARs PM33752/PM33750 does not include owner when resolving the alias names. Problem Conclusion: Logic was added to FSYDB2D1 and FSYDB2P1 programs to find the alias owner and the alias table name from the SYSIBM.SYSTABLES catalog. The real owner and the table name are then extracted from the retrieved row and passed to the logic that retrieves column definitions from the SYSIBM.SYSTABLE catalog. Impacted SFSYLOAD modules: FSYDB2P1 Impacted SFSYEZTS program: FSYDB2D1 Special handling: Activating FSYDB2P1: No action is required. Activating FSYDB2D1: Users must re-compile and bind FSYDB2D1 program for this change to take effect. To re-compile and bind, run jobs JCCOBSQL and JCCOBBND after this change is applied. Note that compiling and binding process is described in the reference manual, Chapter 11 page 199, section "Activating Call Attachment Facility (CAF) for DB2 users. ================================================================
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All IMU V3.2 users. * **************************************************************** * PROBLEM DESCRIPTION: Customer is getting * * "DCLQUE-02,012 "&OWNER.&TBNAME" * * CANNOT BE RESOLVED FROM DB2 CATALOG" * * when &OWNER is an ALIAS. * **************************************************************** * RECOMMENDATION: Apply the PTF. * **************************************************************** The logic that was implemented by PTF # UK66901 (APARs PM33752/PM33750 does not include owner when resolving the alias names.)
Problem conclusion
Logic was added to FSYDB2D1 and FSYDB2P1 programs to find the alias owner and the alias table name from the SYSIBM.SYSTABLES catalog. The real owner and the table name are then extracted from the retrieved row and passed to the logic that retrieves column definitions from the SYSIBM.SYSTABLE catalog.
Temporary fix
Comments
APAR Information
APAR number
PM41428
Reported component name
MIGRATION UTILI
Reported component ID
5697N4400
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-06-13
Closed date
2011-06-15
Last modified date
2011-07-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FSYDB2D1 FSYDB2P1
Fix information
Fixed component name
MIGRATION UTILI
Fixed component ID
5697N4400
Applicable component levels
R320 PSY UK68805
UP11/06/18 P F106
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":"SSY4B9","label":"IBM Migration Utility for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"320","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
27 October 2020