IBM Support

PM41428: SQL, UNDEFINED DB2 TABLE ALIAS

A fix is available

Subscribe

You can track all active APARs for this component.

 

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