JR52750: Referential Integrity analysis job status shows as Completed while prerequisite Column Analysis job is still running

APAR status

• Closed as program error.

Error description

• If a selected Foreign Key candidate requires Column Analysis
  (CA) to be run first as part of a Referential Integrity (RI)
  analysis job, the RI job will show as Completed even though the
  underlying CA job is still progress and hence the RI job does
  not actually complete successfully. An example of this is when
  evaluating a multi-column FK candidate, for which a
  multi-column virtual column will be created and a CA job will
  have to run on the multi-column virtual column before the RI
  job can complete.
  

Local fix

Problem summary

• Referential Integrity analysis job status shows as Completed
  while prerequisite Column Analysis job is still running
  

Problem conclusion

• users should apply 11.3.1.2 to have the fix
  

Temporary fix

Comments

APAR Information

• 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

• R912 PSY

     UP