IBM Support

PI95739: DB2 ADMIN TOOL - CM BATCH ALTER GENERATES STRANGE ADDITIONAL STATEMENT & VIEW NOT RECREATED

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

  • Alter of a table that has an MQT that has a view

1) The generated WSL has a strange ghost statement
MAINTAINED BY SYSTEM
DISABLE QUERY OPTIMIZATION
IN DCMDB.TSPQBE
PARTITION BY SIZE
AUDIT NONE
DATA CAPTURE NONE
WITH RESTRICT ON DROP
CCSID EBCDIC
NOT VOLATILE
APPEND NO

2) Views on the MQT are not re-created

Local fix

  • n/a

Problem summary

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Object Comparison Tool          *
*                 for z/OS who alter a table with dependent    *
*                 MQT and a view on the MQT using Change       *
*                 Management function.                         *
****************************************************************
* PROBLEM DESCRIPTION: View on MQT is dropped but not          *
*                      recreated.                              *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
In order to alter base table, the MQT needs to be dropped
which also drops the view on the MQT. MQT is recreated
but view is not.

Problem conclusion

  • Problem has been resolved.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI95739
    • 

  • Reported component name
    DB2 ADMIN TOOL
    • 

  • Reported component ID
    568851500
    • 

  • Reported release
    B20
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2018-03-27
    • 

  • Closed date
    2018-06-18
    • 

  • Last modified date
    2018-07-02
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  •    ADB2CMP

    



Fix information


    

  • Fixed component name
    DB2 ADMIN TOOL
    • 

  • Fixed component ID
    568851500
    • 



Applicable component levels


    

  • RB20  PSY  UI56654
       UP18/06/22  P  F806
    • 

  • RC10  PSY  UI56655
       UP18/06/22  P  F806
    • 



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":"11.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 July 2018
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback