JR60162: Indexing preprocessing performance improvement

APAR status

• Closed as program error.

Error description

• During indexing preprocess, each index temporary table is
  populated by first performing the SELECT query defined for the
  table in the preprocess XML. The data preprocessor will then
  parse the result set of this query and perform INSERT queries to
   put the data into the index temporary table.
  
  This process results in significant network overhead and
  processing due to retrieving data from database, and then
  inserting it back into database. This overhead can be avoided if
   these tables were instead populated through INSERT INTO SELECT
  queries, which would result in this data not leaving the
  database unnecessarily as it would just be directly updating the
   index temporary table in one step.
  

Local fix

Problem summary

• USERS AFFECTED:
  8.0.4.18 and before
  
  PROBLEM ABSTRACT:
  Indexing preprocessing performance improvement
  
  BUSINESS IMPACT:
  Customers want to build their indices as quick as possible. With
   this enhancement, they can preprocess temporary tables faster.
  
  RECOMMENDATION:
  

Problem conclusion

• By leverage INSERT INTO temporary table SELECT FROM another
  table, we can reduce the round-trip data transmission between db
   and app server.
  

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

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R800 PSY

     UP