IJ41534: GRAPHICAL WORK WEEK QUERY PERFORMANCE WHEN THERE ARE EXTREMELY LARGE QUANTITY OF RECORDS IN WORKORDER TABLE

APAR status

• Closed as program error.

Error description

• When trying to use the Graphical Work Week application it is
  taking more than 10 minutes to
  
  
  
  The query being used returns a simple result set that may return
  
  25 work orders or less,  however, it seems a sql is built which
  attempts to scan all the
   resources with the craft that matches the assignment records on
   the work orders that are trying to schedule. However, if there
  are greater than 2M+ records in
  WMASSIGNMETN table preformance suffers.
  
  Steps to Reproduce:
  GO to GWW
  Return a Work List
  CLick on the View tab
  
  RESULTS:
  It takes more than 10 minutes to load the view, sometimes it
  eventually displays a yellow box saying "The data cannot be
  displayed"
  
  
  
  
  .
  REPORTED 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 will be included in a future Release.
  

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