JR35009: NULL AND DUPLICATE %S NOT SHOWING UP PROPERLY IN PK ANALYSIS REVIEW IN IA 8.1

APAR status

• Closed as fixed if next.

Error description

• The percentages are actually very small percentages, but are
  displaying as 0% in PK and when running MCPK analysis ->
  choosing columns to run (the descriptor is showing the 100%
  null).
  
  IA 8.1 RU5 on Windows Server 2003 with SQL Server 2005
  repository.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users examining the Null and Duplicate percentage values in
  Information Analyzer screens
  ****************************************************************
  PROBLEM DESCRIPTION:
  When NULL and DUPLICATE percentages are very small values (<
  0.01%), they are displayed as 0% in Primary Key Analysis.
  Also, when running Multi-Column Primary Key Analysis the
  columns chosen indicate 100% null when they are more than 99.99%
  null.
  ****************************************************************
  RECOMMENDATION:
  Upgrade to Information Analyzer 8.1 Fix Pack 2
  
  or 8.1.1 Fix Pack
  1 or 8.1.2 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• R810 PSN

     UP