PI34858: PURGE PERFORMANCE IS EXTREMELY SLOW IF LOTS OF COMPLETED & ARCHIVED JOBS ARE ON QUEUE

Rational Build Forge Fix Pack 3 (8.0.0.3) for 8.0
Rational Build Forge Fix Pack 4 (8.0.0.4) for 8.0
Rational Build Forge Fix Pack 5 (8.0.0.5) for 8.0
Rational Build Forge Fix Pack 6 (8.0.0.6) for 8.0
Rational Build Forge Fix Pack 7 (8.0.0.7) for 8.0
Rational Build Forge Fix Pack 8 (8.0.0.8) for 8.0
Rational Build Forge Fix Pack 9 (8.0.0.9) for 8.0
Rational Build Forge Fix Pack 10 (8.0.0.10) for 8.0
Rational Build Forge Interim Fix 1 for 8.0.0.10
Rational Build Forge Fix Pack 11 (8.0.0.11) for 8.0
Rational Build Forge Interim Fix 1 for 8.0.0.11
Rational Build Forge Fix Pack 12 (8.0.0.12) for 8.0
Rational Build Forge Fix Pack 13 (8.0.0.13) for 8.0
Rational Build Forge Fix Pack 14 (8.0.0.14) for 8.0
Rational Build Forge Fix Pack 15 (8.0.0.15) for 8.0
Rational Build Forge Interim Fix 1 for 8.0.0.15
Rational Build Forge Fix Pack 16 (8.0.0.16) for 8.0
Rational Build Forge Fix Pack 17 (8.0.0.17) for 8.0
Rational Build Forge Fix Pack 19 (8.0.0.19) for 8.0
Rational Build Forge Fix Pack 18 (8.0.0.18) for 8.0
Rational Build Forge Fix Pack 20 (8.0.0.20) for 8.0
Rational Build Forge Fix Pack 21 (8.0.0.21) for 8.0
Rational Build Forge Fix Pack 22 (8.0.0.22) for 8.0

APAR status

• Closed as program error.

Error description

• Purge performance is extremely slow if there are huge number of
  completed & archived jobs are on queue.
  
  In v8, purge engine updates bf_step_clones table by below  SQL;
  
  UPDATE bf_step_clones SET bf_elseinline_id=null WHERE
  bf_elseinline_id=:1
  
  But, it does not have correct WHERE clause and it update records
  in bf_step_clones table. In the customer site, there more
  3,000,000 records and every purge updates all the records and it
  consumes huge system resource.
  Purge job may update bf_project_clones table as well and it
  needs to correct SQLs that update the tables.
  
  It's quite urgent and need hot fix because purge jobs are
  running during working time and compete resource with normal
  build jobs.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PURGE PERFORMANCE IS EXTREMELY SLOW IF LOTS OF COMPLETED &   *
  * ARCHIVED JOBS ARE ON QUEUE                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The issue was fixed in Build Forge 8.0.0.3 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

  BF SE QUICKREPO

• Fixed component ID

  5724S2708

Applicable component levels

• R712 PSN

     UP