IJ35039: INEFFICIENT WRITING OF SQL QUERIES IN GRAPHICAL ASSIGNMENT

APAR status

• Closed as program error.

Error description

• When displaying the Graphical View, in graphical Assignment,
  inefficient SQL queries are used and written in the logs. This
  could cause performance issues.
  
  STEPS TO REPRODUCE:
  1. Set SCHEDULER, SCHEDULERSQL and SQL loggers on DEBUG
  2. Open any Graphical Assignment lists
  4. Move to Graphical View
  4. Check the logs for the query generated
  
  RESULT:
  
  The following SQL is written in the logs:
  
  BMXAA6719I - USER = (MAXADMIN) SPID = (625) app (null) object
  (SKDSTATE) : select * from skdstate  where (userid like
  '%MAXADMIN%' and siteid like '%BEDFORD%' and skdprojectid = 23
  and orgid like '%EAGLENA%' and upper(statekey) like
  'RLWORKORDERS_23_20200715-0100')
  
  EXPECTED RESULT:
  
  "Like" and "%" should be replaced with exact match syntax
  
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Scheduler users                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: | Release 7.6.1.3 of Base Services
  

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

  MAXIMO SCHEDULE

• Fixed component ID

  5724R46SE

Applicable component levels