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

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 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