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