IBM Support

PM66278: SQLCODE -650 ON ALTER 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

  • Automation Tool is not excluding indexes on cloned tables from
the reallocation utility.  This will allow an Alter Index
command to be built for these indexes.  Execution of this Alter
command will result in a -650 sqlcode, reason code 18 (ALTER
INDEX is not allowed when the table has defined a clone).

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Automation Tool.                *
****************************************************************
* PROBLEM DESCRIPTION: Automation Tool is not excluding        *
*                      indexes on cloned tables from the       *
*                      reallocation utility.  This will allow  *
*                      an Alter Index command to be built for  *
*                      these indexes.  Execution of this       *
*                      Alter command will result in a -650     *
*                      sqlcode, reason code 18 (ALTER          *
*                      INDEX is not allowed when the table     *
*                      has defined a clone).                   *
****************************************************************
* RECOMMENDATION: APPLY the PTF.                               *
****************************************************************
Code has been changed to correct this condition.

    



Problem conclusion


    

  • APPLY the PTF.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PM66278
    • 

  • Reported component name
    DB2 AUTOMATION
    • 

  • Reported component ID
    5697G6300
    • 

  • Reported release
    310
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2012-06-06
    • 

  • Closed date
    2012-09-04
    • 

  • Last modified date
    2012-10-01
    • 





    

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

    • 

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

    
UK81509 UK81510
    

    • 



Modules/Macros


    

  • HAA#OBEX HAA#UTOB

    



Fix information


    

  • Fixed component name
    DB2 AUTOMATION
    • 

  • Fixed component ID
    5697G6300
    • 



Applicable component levels


    

  • R310  PSY  UK81509
       UP12/09/08  P  F209
    • 

  • R410  PSY  UK81510
       UP12/09/08  P  F209
    • 



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":"SSAUWB","label":"IBM Db2 Automation Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"","label":""}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            01 October 2012
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback