IT17613: IBM B2B ADVANCED COMMUNICATIONS PURGING PROCESS ISSUES A BLOCKING SQL STATEMENT THAT BLOCKS PERFORMANCE

MEG-1.0.0.5_3-MediaImage
Interim Fix 3 Notification for B2B Advanced Communications, V1.0.0 Fixpack 5

APAR status

• Closed as program error.

Error description

• IBM B2B Advanced Communication purging process issues
  blocking SQL statement, affecting system performance.
  
  
  Under IBM B2B Advanced Communications (B2B AC) 1.0.0.4_3,
  when purge runs, B2BAC issues the following SQL
  statement which blocks system operations.
  
  
  
  
  DELETE FROM BUSINESSDATA WHERE ID IN (SELECT DISTINCT t1.ID FROM
  BUSINESSDATA t1 WHERE (NOT (EXISTS (SELECT @P0 FROM EVENT t0
  WHERE (t0.
  BUSINESSDATAID = t1.ID))))
  

Local fix

• STRRTC - 40550
  JG / JG
  
  Circumvention: NONE
  

Problem summary

• Users Affected:
  Any user who perfomrs a huge number of transactions, resulting
  in huge number of records picked up for purge.
  
  Problem Description:
  When a large number of records are picked up for purge, with a
  very small interval between the purge cycles, it results in a
  overlap and deadlock situation.
  
  Platforms Affected:
  All
  

Problem conclusion

• Resolution Summary:
  A code fix is provided.
  
  
  Delivered In:
  iFIX1005_3
  

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

  B2B ADV COMMUNI

• Fixed component ID

  5725Q7200

Applicable component levels

• R100 PSN

     UP