IBM Support

PM13454: ADB3002E ERROR GENERATED WHEN TRIGGER TABLE IS UNQUALIFIED AND RUNSQLID IS USED WITH A DIFFERENT SQLID. FFA10 PM29858

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In DB2 Object Comparison Tool for z/OS, when comparing a
TRIGGER with an unqualified table in the SQL, and RUNSQLID
specified is different from the table owner, ADB3002E Error
processing Trigger xxx.xxxxx in CREATE statement Table/View
xxx.xxxxx does not exist is generated.
Additional Symptoms: rc8 msgADB3002E

Local fix

  • Use RUNSQLID BLANK or <NONE>

Problem summary

  • ****************************************************************
* USERS AFFECTED: Users of the DB2 Object Comparison           *
*                 Tool for z/OS who add triggers on            *
*                 tables.                                      *
****************************************************************
* PROBLEM DESCRIPTION: The DB2 Object Comparison Tool          *
*                      creates triggers without the correct    *
*                      SET CURRENT SCHEMA or SET               *
*                      CURRENT SQLID statement.                *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Apply The PTF.

Problem conclusion

  • The DB2 Object Comparison Tool creates triggers
without the correct SET CURRENT SCHEMA or SET
CURRENT SQLID statement, causing unqualified
tables referenced from within the trigger body to not
be located.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PM13454
    • 

  • Reported component name
    DB2 OBJECT COMP
    • 

  • Reported component ID
    5697G6400
    • 

  • Reported release
    720
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2010-04-29
    • 

  • Closed date
    2010-12-29
    • 

  • Last modified date
    2011-03-02
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  •    GOC2CMP  GOC2CMR

    



Fix information


    

  • Fixed component name
    DB2 OBJECT COMP
    • 

  • Fixed component ID
    5697G6400
    • 



Applicable component levels


    

  • R720  PSY  UK63553
       UP11/02/05  P  F102
    • 



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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUVH","label":"IBM Db2 Object Comparison Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"720","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 March 2011
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback