IBM Support

JR35171: ^ IS DISPLAYED FOR NULL WHEN VIEWING PK ANALYSIS FREQUENCY DISTRIBUTION

 

APAR status

  • Closed as fixed if next.

Error description

  • IA 8.1 Windows Server 2003 with SQL Server 2005 repository
    
    PK Analysis Frequency Distribution displays ^ to represent NULL.
    
    Customer's concerns:
    
    1. It is not readily clear to the user that the ^ represents
    nulls. The
    can make that relationship by looking at the data.
    
    2. Is the ^ recognized as null and represented in the
    statistics?  What
    about other nulls?  Are they all analyzed as null?
    
    3. Customer's preference suggestions:
    - Make behavior similar to what is done with virtual columns
    - Add the ability to indicate explicitly to the user that they
    can
    substitute what they want to use to represent null or have a
    default
    substitution for null such as [NULL] instead of ^
    - In Properties, allow the user to set the default to represent
    NULL.
    
    4. Concerns for all options are:
    - Will they be recognized as true null values? (e.g. ^ or
    [NULL])
    - When substituting for null value, does it affect the
    statistics?
    - Will the substitution 'break' FK Analysis?
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users looking at Primary Key Analysis results for data that
    contains NULL values.
    ****************************************************************
    PROBLEM DESCRIPTION:
    PK Analysis Frequency Distribution displays ^ to represent NULL
    values.
    
    Concerns:
    1. It is not readily clear to the user that the ^ represents
    nulls. They can infer that relationship by looking at the data.
    2. Is the ^ recognized as null and represented in the
    statistics?  What about real null values?  Are they all analyzed
    as null?
    ****************************************************************
    RECOMMENDATION:
    Upgrade to Information Analyzer 8.1 Fix Pack 2, or
    Information Analyzer 8.1.1 Fix Pack 1, or Information Analyzer
    8.1.2 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR35171

  • Reported component name

    WIS INFORM ANAL

  • Reported component ID

    5724Q36IA

  • Reported release

    810

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-12-17

  • Closed date

    2010-03-02

  • Last modified date

    2010-12-31

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1"}]

Document Information

Modified date:
12 October 2021