IBM Support

IT23334: PERFORMANCE OF COMPUTER ROLLUP QUERY IS TOO SLOW

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Rollup reports are taking several hours when the Spectrum
    Control environment is really large
    
    An example of large environment:  Spectrum Control instance 1
    having approx 85 storage systems, 45 FC switches, 5000+
    hypervisors and 1900 agentless servers.  The 2nd Spectrum
    Control instance is smaller with about 70 storage systems, 30
    switches, no hypervisors and 1800 agentless servers
    
    This sized environment may find in the probe logs of the rollup
    server job that the collection of "Computer systems" takes about
    several hours
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Control users using rollup reporting            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When rollup reports are used, and the Spectrum Control       *
    * environment is really large, the rollup reports are taking   *
    * several hours to perform.                                    *
    *                                                              *
    * An example of large environment:                             *
    *                                                              *
    * Spectrum Control instance 1 having approx 85 storage         *
    * systems, 45 FC switches, 5000+ hypervisors and 1900+         *
    * agentless servers.                                           *
    *                                                              *
    * The 2nd Spectrum Control instance is smaller with about      *
    * 70 storage systems, 30 switches, no hypervisors and          *
    * approx 1800 agentless servers                                *
    *                                                              *
    * This sized environment may find in the probe logs of the     *
    * rollup server job that the collection of "Computer systems"  *
    * takes about several hours.                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fix maintenance when available                         *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is targeted for the following release:
    
    IBM Spectrum Control 5.3.1  |  5.3.1-IBM-SC
    
    ( release target Nov 2018 )
    
    http://www.ibm.com/support/docview.wss?&uid=swg21320822
    
    The target dates for future releases do not represent a formal
    commitment by IBM. The dates are subject to change without
    notice.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23334

  • Reported component name

    TPC

  • Reported component ID

    5608TPC00

  • Reported release

    529

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-11-29

  • Closed date

    2018-10-10

  • Last modified date

    2018-10-10

  • 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

    TPC

  • Fixed component ID

    5608TPC00

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSWFB4","label":"IBM Spectrum Control Standard Edition"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"529","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
06 September 2023