IBM Support

PH03412: DB2 ADMIN TOOL - OBJECT COMPARISON TOOL DOES NOT CREATE WORKLISTFOR PARTITIONED INDEX

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

  • Converting index from simple to partitioned is not detected by
compare if source is from DDL. The reverse case or with source
index from catalog the change is reported and appropriate
statements generated.

Fix for this APAR will also resolve inconsistency between
compare and analyze when trying to convert index from NPI
to DSPI

Local fix

  • n/a

Problem summary

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Object Comparison Tool for      *
*                 z/OS who compare partitioned index using     *
*                 DDL as source to simple index from target.   *
****************************************************************
* PROBLEM DESCRIPTION: Object Comparison Tool does not         *
*                      recognize conversion from NPI to        *
*                      DSPI index.                             *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Object Comparison Tool does not report index update from simple
to partitioned index and does not generate the change statement
in WSL.

Problem conclusion

  • Problem has been resolved.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH03412
    • 

  • Reported component name
    DB2 ADMIN TOOL
    • 

  • Reported component ID
    568851500
    • 

  • Reported release
    C10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2018-10-01
    • 

  • Closed date
    2019-01-25
    • 

  • Last modified date
    2019-02-02
    • 





    

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

    • 

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

    
UI60959 UI60960
    

    • 



Modules/Macros


    

  •    ADB2CME

    



Fix information


    

  • Fixed component name
    DB2 ADMIN TOOL
    • 

  • Fixed component ID
    568851500
    • 



Applicable component levels


    

  • RB20  PSY  UI60959
       UP19/01/29  P  F901
    • 

  • RC10  PSY  UI60960
       UP19/01/29  P  F901
    • 



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 February 2019
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback