IBM Support

PH18028: CM BATCH OBJECT COMPARE INCORRECTLY ADDS BACK VERSIONING WITH UNLOAD_ALTERED_TABLES 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

  • When a change drops versioning for a temporal and history table
pairing, and change option UNLOAD_ALTERED_TABLES is
set to 'YES', CM Batch or Object Compare incorrectly
reestablishes versioning for the tables.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Administration Tool for Z/OS    *
*                 who use Compare to drop versioning from a    *
*                 temporal and history table pairing, with the *
*                 "Unload Altered Tables" option set to YES.   *
****************************************************************
* PROBLEM DESCRIPTION: With UNLOAD_ALTERED_TABLES = 'Y',       *
*                      Compare does not recognize drop         *
*                      versioning for source tables and        *
*                      instead maintains the versioning.       *
****************************************************************
When UNLOAD_ALTERED_TABLES = Y, Compare processing
that used to generate DROP/CREATEs now generates ALTERs.
This difference in pathways causes Compare to think it needs to
add versioning back when altering temporal and history
tables.

This fix ensures that the result of Compare when altering such
tables is identical regardless of the setting of
UNLOAD_ALTERED_TABLES, namely that when the table is altered to
drop versioning the versioning is not added back afterwards.

    



Problem conclusion


    

  • This problem has been resolved.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH18028
    • 

  • 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
    2019-10-11
    • 

  • Closed date
    2020-01-28
    • 

  • Last modified date
    2020-02-04
    • 





    

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

    • 

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

    
UI67591        
    

    • 



Modules/Macros


    

  • ADB2CMT

    



Fix information


    

  • Fixed component name
    DB2 ADMIN TOOL
    • 

  • Fixed component ID
    568851500
    • 



Applicable component levels


    

  • RC10  PSY  UI67591
       UP20/02/04  P  F001
    • 



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:
            

            04 February 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback