Direct links to fixes
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
11 September 2023