IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 number

    IT01481

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    524

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-01

  • Closed date

    2015-03-09

  • Last modified date

    2015-03-20

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
20 March 2015