IBM Support

PK74694: DB2 OBJECT COMPARE TRIGGER CREATED PRIOR TO DEPENDENT VIEW WHEN TRIGGER ON TARGET

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

  • DB2 OBJECT COMPARE TRIGGER CREATED PRIOR TO DEPENDENT VIEW WHEN
TRIGGER ON TARGET

Local fix

  • APPLY PTF

Problem summary

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Object Comparison Tool Ver 7.2  *
*                 and DB2 Tools Change Management.             *
****************************************************************
* PROBLEM DESCRIPTION: The DB2 Object  Comparison  Tool apply  *
*                      job  fails with  an SQLCODE  -204 when  *
*                      reate  Trigger is  performed  prior to  *
*                      Create  View  on  which  thi s trigger  *
*                      depends.   The order of objects in the  *
*                      Changes file is incorrect when trigger  *
*                      has dependences on views and MQTs  and  *
*                      the  trigger is found  on both  source  *
*                      and target.                             *
****************************************************************
* RECOMMENDATION: Apply The PTF.                               *
****************************************************************
The DB2 Object Comparison Tool apply job fails with an SQLCODE
-204  when Create Trigger is performed prior to Create View on
which this trigger depends.The order of objects in the Changes
file is incorrect when the rigger has dependences on views and
MQTs and the trigger is found on both source and target.

Problem conclusion

  • The problem is fixed.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PK74694
    • 

  • 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
    2008-10-29
    • 

  • Closed date
    2008-12-15
    • 

  • Last modified date
    2009-01-02
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  •    GOC2CMF  GOC2CMP  GOC2CMR  GOC2CMS

    



Fix information


    

  • Fixed component name
    DB2 OBJECT COMP
    • 

  • Fixed component ID
    5697G6400
    • 



Applicable component levels


    

  • R720  PSY  UK42509
       UP08/12/23  P  F812
    • 



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:
            

            12 February 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback