IBM Support

PM20410: NEW COPY COMMAND USED FOR INDEX INCOMPATIBILITY CHECKS, CHECK-INDEX-KEYS(Y/N)

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • New COPY subcommand CHECK-INDEX-KEYS(y/n).

This command make additional checks on index compatibility.
LIMITKEY is always checked and is normally sufficient.  In some
cases, a mismatch is missed unless the keys are read and checked
also.  If using index cacheing, run once with
CHECK-INDEX-KEYS(Y), change any indexes to correct the
mismatches and then run with CHECK-INDEX-KEYS(N) or the default.

This has been added as a command since it can cause a
performance penalty especially when there are many indexes to
copy or cacheing is being used to access the catalog.  Cacheing
is not supported for index keys.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Cloning Tool.                   *
****************************************************************
* PROBLEM DESCRIPTION: New COPY subcommand                     *
*                      CHECK-INDEX-KEYS(y/n). This command     *
*                      make additional checks on index         *
*                      compatibility. LIMITKEY is always       *
*                      checked and is normally sufficient.     *
*                      In some cases, a mismatch is missed     *
*                      unless the keys are read and checked    *
*                      also.  If using index cacheing, run     *
*                      once with CHECK-INDEX-KEYS(Y), change   *
*                      any indexes to correct the mismatches   *
*                      and then run with CHECK-INDEX-KEYS(N)   *
*                      or the default. This has been added as  *
*                      a command since it can cause a          *
*                      performance penalty especially when     *
*                      there are many indexes to copy or       *
*                      cacheing is being used to access the    *
*                      catalog.  Cacheing is not supported     *
*                      for index keys.                         *
****************************************************************
* RECOMMENDATION: APPLY the PTF.                               *
****************************************************************
Code has been changed to correct this condition.

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • APPLY the PTF.

    



APAR Information




    

  • APAR number
    PM20410
    • 

  • Reported component name
    DB2 CLONING TOO
    • 

  • Reported component ID
    5655N1000
    • 

  • Reported release
    220
    • 

  • Status
    CLOSED  UR1
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2010-08-11
    • 

  • Closed date
    2011-03-23
    • 

  • Last modified date
    2011-04-04
    • 





    

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

    • 

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

    
UK66073
    

    • 



Modules/Macros


    

  • CKZ00501
CKZ00510
CKZ00532
CKZ00535
CKZ00547
CKZ00613
CKZ00628
CKZ00629
CKZ00631
CKZ00632
CKZ00634
CKZ00635
CKZ00652
CKZ00653
CKZ00654
CKZ00655
CKZ00656
CKZ00657
CKZ00670
CKZ00671
CKZ00675
CKZ00678
CKZ00679
CKZ00728
CKZ00729
CKZ00731
CKZ00732
CKZ00734
CKZ00735
CKZ00752
CKZ00753
CKZ00754
CKZ00755
CKZ00756
CKZ00757
CKZ00770
CKZ00775
CKZ00778
CKZ00779

    



Fix information


    

  • Fixed component name
    DB2 CLONING TOO
    • 

  • Fixed component ID
    5655N1000
    • 



Applicable component levels


    

  • R220  PSY  UK66073
       UP11/04/03  P  F103
    • 



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.
    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.2.0"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            30 March 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback