IC90162: IS THERE SOME WAY TO COMPARE THE FIELD NAMED SECURE_ENABLED WITH NULL VALUE WHEN FILTERING A REPORT?

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Need to extract a report to list all processes with Secure+
    disabled. Trying to use the Report type = "Connect:Direct
    Statistics Log Report" and using as filter the field
    SECURE_ENABLED
    
    Y  - If Secure+ is enabled
    N - If Secure+ is disabled on both nodes
    NULL - If some of nodes does not have Secure+
    
    Need to get a list of all processes with SECURE_ENABLED=N or
    SECURE_ENABLED=null.
    
    Tried to use the criteria:  SECURE_ENABLED Doesn't match Y, but
    it lists only the N values.
    

Local fix

  • STRRTC - 366217
    SF / SF
    Circumvention: None
    

Problem summary

  • Description of issue:  Using the CD Stats Log Report, the user
    attempted to query all processes which did not have Secure Plus
    enabled (i.e. SECURE_ENABLED | Doesn't match | Y ).
    This filter resolved to a SQL clause of SECURE_ENABLED <> 'Y'.
    This will return records which have the field filled in with
    'N', but not if NULL (meaning Secure Plus is not licensed /
    available).
    

Problem conclusion

  • Description of fix:  Modified the DB report program to alter the
    query from: SECURE_ENABLED <> 'Y'   to:  (SECURE_ENABLED <> 'Y'
    OR SECURE_ENABLED IS NULL).
    

Temporary fix

  • Description of issue:  Using the CD Stats Log Report, the user
    attempted to query all processes which did not have Secure Plus
    enabled (i.e. SECURE_ENABLED | Doesn't match | Y ).
    This filter resolved to a SQL clause of SECURE_ENABLED <> 'Y'.
    This will return records which have the field filled in with
    'N', but not if NULL (meaning Secure Plus is not licensed /
    available).
    
    Description of fix:  Modified the DB report program to alter the
    query from: SECURE_ENABLED <> 'Y'   to:  (SECURE_ENABLED <> 'Y'
    OR SECURE_ENABLED IS NULL).
    

Comments

APAR Information

  • APAR number

    IC90162

  • Reported component name

    STR CONTROL CEN

  • Reported component ID

    5725D0200

  • Reported release

    52X

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-12

  • Closed date

    2013-02-22

  • Last modified date

    2013-02-22

  • 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

    STR CONTROL CEN

  • Fixed component ID

    5725D0200

Applicable component levels

  • R52X PSY

       UP

  • R530 PSY

       UP

  • R540 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Control Center

Software version:

5.2

Reference #:

IC90162

Modified date:

2013-02-22

Translate my page

Machine Translation

Content navigation