IBM Support

JR62051: COLUMN ANALYSIS REMAINS IN PROGRESS WHEN PROFILING IS RUN WITH THE OPTION 'UPDATE EXISITING TABLES = YES'

 

APAR status

  • Closed as program error.

Error description

  • Trigger profiling for a dataset with 2million rows by setting
the update exisiting table to yes. Even after one day there is
no progress on the status and there is no FD table
created.

Tried the same scenario with sampling from 10k,1
lakh,10 Lakhs and it was successful for 10k and 1 lakh but
stuck for 10lakhs.

Local fix

  • 



Problem summary


    

  • Column Analysis remains in progress when profiling is run with
the option 'Update Exisiting Tables = Yes'

    



Problem conclusion


    

  • Fixed in 11.7.1 FP1

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR62051
    • 

  • Reported component name
    WIS INFORM ANAL
    • 

  • Reported component ID
    5724Q36IA
    • 

  • Reported release
    B70
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2020-02-26
    • 

  • Closed date
    2020-05-15
    • 

  • Last modified date
    2020-05-15
    • 





    

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

    • 

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

    • 



Fix information


    

  • Fixed component name
    WIS INFORM ANAL
    • 

  • Fixed component ID
    5724Q36IA
    • 



Applicable component levels


    

  • RB71  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            14 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback