IBM Support

JR42896: Second referential integrity job never runs after launching RI jobs one right after the other

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If two Referential Integrity jobs involving a common column are
    submitted in quick succession, the second job never runs
    

Local fix

Problem summary

  • When multiple Referential Integrity jobs are launched without
    waiting for the previous ones completed, the jobs submitted at
    later point of time were hanging. This was only happening when
    the jobs submitted later contains the same column was used in
    the previous jobs as primary/foreign key.
    

Problem conclusion

  • The locking of analyzed columns in Key Analysis jobs was removed
    to allow concurrent key analysis jobs. APAR JR42896 is created
    to fix this issue   in 85rp10  and delivered  to Customer .
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR42896

  • Reported component name

    WIS INFORM ANAL

  • Reported component ID

    5724Q36IA

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-22

  • Closed date

    2012-10-17

  • Last modified date

    2013-01-21

  • 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

  • R850 PSY

       UP

  • R870 PSY

       UP

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
21 January 2013