IV39578: MQL JOIN QUERIES MAY RETURN WRONG RESULTS.

APAR status

• Closed as program error.

Error description

• Running MQL join queries that use subclass name as second
  identifier may result in returning other subclasses of same
  base class. For example;
  
  
  select * from ComputerSystem,ActiveDirectory where
  ComputerSystem.guid==ActiveDirectory.host.guid
  
  will return all ComputerSystem objects that have a Service
  (which is a super type for:
  DHCPService, DNSService, FileSystemService,
  GenericService, LDAPService, LVMService, SMTPService,
  VeritasStorageService, WebService).
  The expected behavior is returning only ComputerSystems that
  have ActiveDirectory (subclass of LDAPService)
  

Local fix

• Run the query with a where/contains clause to specify additional
  atttributes that are unique to the service subclass. For
  example;
  
  
  
  select * from ComputerSystem,ActiveDirectory where
  ComputerSystem.guid==ActiveDirectory.host.guid AND
  (ActiveDirectory.name
  contains 'Active Directory' or ActiveDirectory.name contains
  'unknown ldap')
  

Problem summary

• Running MQL join queries that use subclass name as second
  identifier may result in returning other subclasses of same
  base class. For example;
  
  
  select * from ComputerSystem,ActiveDirectory where
  ComputerSystem.guid==ActiveDirectory.host.guid
  
  will return all ComputerSystem objects that have a Service
  (which is a super type for:
  DHCPService, DNSService, FileSystemService,
  GenericService, LDAPService, LVMService, SMTPService,
  VeritasStorageService, WebService).
  The expected behavior is returning only ComputerSystems that
  have ActiveDirectory (subclass of LDAPService)
  

Problem conclusion

• The fix for this APAR corrects the problem with returning all
  classes from object hierarchy. Queries like:
  select * from ComputerSystem,WebSphereServer where
  ComputerSystem.guid==WebSphereServer.host.guid
  
  Will return all ComputerSystem objects, that have
  WebSphereServer or any of it's subclasses (
  WebSphereDeploymentManager, WebSphereNodeAgent,
  WebSphereXSCacheNode ).
  To query all ComputerSystems that have any type of J2EEServer
  use query:
  select * from ComputerSystem,J2EEServer where
  ComputerSystem.guid==J2EEServer.host.guid
  
  "SELECT * FROM ONLY" syntax is only applied to first table in
  the query.
  select * from only WindowsComputerSystem,WebSphereServer where
  ComputerSystem.guid==WebSphereServer.host.guid
  Will return only WindowsComputerSystems,  that have
  WebSphereServer or any of it's subclasses.
  
  
  The fix for this APAR is contained in the following maintenance
  packages:
  | Fix Pack | 7.2.1-TIV-ITADDM-FP0005
  
  Check the IBM Software Support web site for availability of the
  above maintenance packages.
  

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

  APP DEPENDENCY

• Fixed component ID

  5724N5500

Applicable component levels

• R721 PSY

     UP