IT01481: CUSTOMER HAS OVER 30 MILLION DOCUMENTS AND INCREASING WITH 10 YEAR LIFE_SPAN WITH DOCUMENT_LIFESPAN USER_KEY OF CDSA-CREATOR

APAR status

• Closed as program error.

Error description

• Customer has very large table counts for documents:
  TABLE                      ROW COUNT
  CORRELATION_SET            401,912,218
  TRANS_DATA                 111,007,207
  DOCUMENT                   26,832,529
  DOCUMENT_LIFESPAN          27,634,737
  
  Nearly all the rows in TRANS_DATA WF_ID -1 are document or
  document_extension rows.
  
  SELECT REFERENCE_TABLE, COUNT(WF_ID) FROM TRANS_DATA WHERE
  WF_ID = -1 GROUP BY REFERENCE_TABLE;
  
  DOCUMENT               88,523,339
  DOCUMENT_EXTENSION     30,407,189
  
  For CORRELATION_SET for each document put into a mailbox it
  creates approx 14 rows in CORRELATION_SET table so therefore
  27,634,737 x 14 = 386,886,318
  
  For TRANS_DATA for each document we create 4 rows 3 document
  row + 1 document extension therefore 27,634,737 x 4 =
  110,539,848 rows
  

Local fix

• STRRTC 419782
  AC / AC
  No Workaround
  

Problem summary

• Users Affected:
  Connect:Direct Server adapter user
  
  Problem Description:
  Customer has over 30 million documents and increasing with 10
  year life_span with document_lifespan USER_KEY of CDSA-CREATOR.
  Each iteration INSERTs rows into the database.
  
  Platforms affected:
  All
  

Problem conclusion

• Resolution Summary:
  An exception was causing an infinite loop. A code
  fix has been provided.
  
  Delivered In:
  5020500_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

  STR B2B INTEGRA

• Fixed component ID

  5725D0600

Applicable component levels

• R525 PSY

     UP