IBM Support

PI82181: DB2 ADMIN TOOL - COMPARE GENERATES DROP ON AUX INDEX WHEN SUPPRESS DROP OF OBJECTS SET TO YES

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

  • Object Compare with suppress drop of objects set to yes. However
it is still generating Drop statements for auxiliary indexes.

Local fix

  • n/a

Problem summary

  • ****************************************************************
* USERS AFFECTED: Users of the DB2 Object Comparison           *
*                 Tool for z/OS.                               *
****************************************************************
* PROBLEM DESCRIPTION: Auxiliary index dropped                 *
*                      regardless of option setting            *
*                      for 'Suppress DROP of objects'          *
*                      on panel GOC5 'Generate                 *
*                      Compare Jobs'.                          *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Object Compare generates a DROP statement for an explicit
auxiliary index which exists only on the target when its
associated base table is not dropped regardless of the
value specified for option 'Suppress DROP of objects'.

Problem conclusion

  • Object Compare has been modified to keep the
explicit auxiliary indexes on the target, if the
associated base table is not dropped, regardless
of the value specified for option 'Suppress DROP
of objects' on panel GOC5 'Generate Compare Jobs'.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI82181
    • 

  • Reported component name
    DB2 OBJECT COMP
    • 

  • Reported component ID
    5697G6400
    • 

  • Reported release
    C10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2017-05-26
    • 

  • Closed date
    2017-08-25
    • 

  • Last modified date
    2017-09-02
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  •    ADB7000

    



Fix information


    

  • Fixed component name
    DB2 ADMIN TOOL
    • 

  • Fixed component ID
    568851500
    • 



Applicable component levels


    

  • RC10  PSY  UI49875
       UP17/08/31  P  F708
    • 



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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 September 2017
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback