IBM Support

IT19692: PURGEALL DOES NOT TRUNCATE SOME _GUID TABLES

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

  • Problem Statement
    PurgeAll does not truncate the following tables
    - MBX_MAILBOX_GUID
    - MBX_MESSAGE_GUID
    After running PurgeAll the table MBX_MESSAGE_GUID has still
    some mio rows
    Simulation Steps
    [si@si526 bin]$ ./PurgeAll.sh -l | grep GUID
    6.   ACT_SESSION_GUID
    23.  DATA_FLOW_GUID
    24.  DMI_FACT_GUID
    Observations
    PurgeAll is truncating only the following GUID-tables
    - ACT_SESSION_GUID
    - DATA_FLOW_GUID
    - DMI_FACT_GUID
    Expected Behavior
    PurgeAll cleans up all non-config tables
    Business Impact
    On MSSQL truncate on GUID tables is not allowed to keep the
    identity seed value.
    So customer has to follow laborious guide:
    https://eclient.lenexa.ibm.com:9445/search/?fetch=source/TechNot
    e/1969212
    

Local fix

Problem summary

  • USERS AFFECTED:
    All
    
    PROBLEM DESCRIPTION:
    PurgeAll does not truncate some _GUID tables.
    
    PLATFORMS AFFECTED:
    ALL
    

Problem conclusion

  • RESOLUTION SUMMARY:
    A code fix is provided.
    
    DELIVERED IN:
    5020603_2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT19692

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    524

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-15

  • Closed date

    2017-06-07

  • Last modified date

    2017-06-11

  • 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

  • R526 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:
11 June 2017