IV93507: RUNNING QUERY EXECUTES MULTIPLE IBS_SPEC CALLS

APAR status

• Closed as fixed if next.

Error description

• Running queries for non base language users will execute
  multiple calls to IBM_SPEC table unecessaryly.
  
  1. Create a user that has language set that isn't the base
  language (British English vs US)
  2. Create a report with a number of different classification
  fields, for example a report/query on triPeople/triPeople,
  choose the following as display columns:
  
      User Name (triUserNameTX)
      Assignment Type (triAssignmentTypeCL)
      Functional Role (triFunctionalRoleCL)
      Maintenance Priority (triMainPriorityCL)
      Timezone (triTimeZonesCL)
      TRIRIGA User Status (triUserStatusCL)
      Previous Status (triPreviousStatusCL)
      Status (triStatusCL)
  
  3. Login as the new user, navigate to the point where you are
  about to run the query.
  4. turn on SQL Logging (3.5.2 SQL Performance Log)
  5. You will see extra queries to IBS_SPEC as it has to fill the
  Smart Record Header (SmartObjectHeaderLazyLoaderProxy called
  from QueryActions.translateValueIfClassificationField)
  

Local fix

• N/A
  

Problem summary

• Changes in Platform, Cache many of the frequently hit items in
  classifications and my profile, so that it reduces pressure on
  IBS_SPEC
  

Problem conclusion

• The IBS_SPEC table is no longer queried multiple times when
  classifications were included on reports. Classifications are
  considered meta-data and the values will now be cached for a
  default of 24 hours.
  This is targeted to the 1h2017 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:

Modules/Macros

• 999
  

Fix information

Applicable component levels