JR62018: INFORMATION ANALYZER RELATIONSHIP ANALYSIS DOES NOT FIND KNOWN JOINS

APAR status

• Closed as program error.

Error description

• While trying to identify primary and foreign key relationships
  between tables in a workspace, and choose a very simple set of
  3 tables that we know the Joins from both the Erwin model and
  from the IMAM import, we are able to find the correct Primary
  keys (only works if we run CA, DQA and Primary key analysis in
  one analysis) but we are unable to find the relationships
  between tables.
  
  The following settings are used :
  
  Primary key
  min uniqueness 90%
  Frimary key max ophans 50%
  Min % of common
  distinct 1%
  Min confidence for relationships 1%
  Compound keys
  relationship max 6 columns
  
  It still shows zero Selected or
  Candidate relationships.
  

Local fix

Problem summary

• Information Analyzer Relationship Analysis does not find known
  joins
  

Problem conclusion

• Fixed in 1171 FP1
  

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

• RB71 PSY

     UP