IBM Support

IT08102: HEALTHCHECK TOOL INDEX FRAGMENTATION TEST FOR THE DATABASE SCANNER REPORTS FRAGMENTATION WITH SMALL INDEXES.

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

  • The Health Check Tool when running the Index Fragmentation Test
    for the Database Scanner reports Severe Index
    Fragmentation for very small Indexes.
    

Local fix

  • RTC 444589
    FB/FB
    Circumvention: None
    

Problem summary

  • Problem Description:
    The Index Fragmentation Test for the Database Scanner currently
    reports an error even when the table is small.  Index
    fragmentation is not a significant problem for small tables
    since they don't benefit as much from being defragmented.
    
    Platforms Affected:
    All
    
    Users Affected:
    Health Check Tool users
    

Problem conclusion

  • Resolution Summary:
    Properties have been added to determine severity based on table
    size, and queries for determining table size.
    
    This fix is included in Health Check Tool V1.0.2.1, which is
    available with Sterling B2B Integrator V5.2.5, Interim Fix 4.
    
    Delivered In:
    5020500_4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT08102

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    525

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-04-02

  • Closed date

    2015-04-20

  • Last modified date

    2015-04-28

  • 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.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
28 April 2015