IBM Support

PM02349: DB2 CLONING TOOL PERFORMANCE ISSUE WHEN COPYING TABLES FROM SOURCE

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

  • Note, resolving PTF will be for DB2 Cloning Tool r220.
There will not be a fix for r210.

Performance issue when copying tables, when badly clustered
catalogs or when it must use the SQL STRIP function (without any
indexes).

Catalog reads can take a considerable amount of time.
This change applies only to SYSTABLES.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Cloning Tool.                   *
****************************************************************
* PROBLEM DESCRIPTION: Note, resolving PTF will be for DB2     *
*                      Cloning Tool r220. There will not be    *
*                      a fix for r210. Performance issue       *
*                      when copying tables, when badly         *
*                      clustered catalogs or when it must use  *
*                      the SQL STRIP function (without any     *
*                      indexes). Catalog reads can take a      *
*                      considerable amount of time. This       *
*                      change applies only to SYSTABLES.       *
****************************************************************
* RECOMMENDATION: APPLY the PTF.                               *
****************************************************************
Code has been changed to correct this condition.

    



Problem conclusion


    

  • APPLY the PTF.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PM02349
    • 

  • Reported component name
    DB2 CLONING TOO
    • 

  • Reported component ID
    5655N1000
    • 

  • Reported release
    210
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2009-11-30
    • 

  • Closed date
    2010-03-29
    • 

  • Last modified date
    2010-05-04
    • 





    

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

    • 

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

    
UK55671
    

    • 



Modules/Macros


    

  •    CKZ00500 CKZ00501 CKZ00510 CKZ00535 CKZ00536
CKZ00544 CKZ00545 CKZ00547 CKZ00560 CKZ00563 CKZ00613 CKZ00627
CKZ00629 CKZ00630 CKZ00632 CKZ00652 CKZ00653 CKZ00654 CKZ00655
CKZ00670 CKZ00671 CKZ00673 CKZ00678 CKZ00679 CKZ00727 CKZ00729
CKZ00730 CKZ00732 CKZ00752 CKZ00753 CKZ00754 CKZ00755 CKZ00770
CKZ00773 CKZ00778 CKZ00779 HCKZ220J

    



Fix information


    

  • Fixed component name
    DB2 CLONING TOO
    • 

  • Fixed component ID
    5655N1000
    • 



Applicable component levels


    

  • R220  PSY  UK55671
       UP10/04/10  P  F004
    • 



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

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            12 February 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback