IV45728: IMPROVEMENT FOR PART MAINT

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Problem description:
    Existing implmentation
    1. Statistic is not available for today partition.
    ANALYZE_PARTITIONS only analyze for yesterday partition.
    2. No recalculate stats if there is any later data than
    yesterday.
    3. SOme large scale environment take more than 1 days to
    complete analyze for 1 day partitions.
    
    Proposed solution:
    1. utilize 11g feature to perform daily copy stats from last 2
    days to current date. With assumption customer data loading are
    consistent. Additional checking if there is new tables or enwly
    loaded data, then gather_table_stats shall be performed.
    
    2. Perform daily full table gather_table_stats to ensure their
    statistic is up to date to be copied.
    
    a. Add feature to timeout the analyze if it cannot complete
    within an interval. always select table with last_analyzed is
    oldest.
    b. Additional checking if last_analyzed is
    
    
    
    not null
    and num_rows = 0, then additional checking on count for physical
    table. If there is rows returned, then perform analyze assuming
    new data loaded for first time, else do nothing.
    c. Perform analyze if num_rows > 0 assuming this table is always
    filled up with data.
    

Local fix

  • daily copy stats and weekly analyze available from L3 support
    for TNPM 1.3.2 onwards
    

Problem summary

  • ERROR DESCRIPTION:
    TCR report are running slower due to table statistic was not
    collected properly.
    
    PROBLEM DESCRIPTION:
    Without proper statistic, oracle unable to generate proper
    execution plan.
    
    PROBLEM SUMMARY:
    Customer environment contain large scale tables which taking
    longer time to analyze yesterday partitions thus making some of
    the partitions not analyzed.
    
    
    RESOLUTION:
    Introduce new functionality to copy statistic and perform full
    analyze for updated stats.
    

Problem conclusion

  • Problem Conclusion:
    This is projected to be fixed in 1.3.2.0-TIV-TNPM-IF0005. Note
    that this is subject to change at the discretion of IBM.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV45728

  • Reported component name

    NETCOOL PM WIRE

  • Reported component ID

    5724T0100

  • Reported release

    132

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-17

  • Closed date

    2013-07-31

  • Last modified date

    2013-07-31

  • 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

    NETCOOL PM WIRE

  • Fixed component ID

    5724T0100

Applicable component levels

  • R132 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Netcool Performance Manager for Wireless

Software version:

132

Reference #:

IV45728

Modified date:

2013-07-31

Translate my page

Machine Translation

Content navigation