IV45129: EXCESSIVE ROWS SUMMARY AND BH TABLES ARE NOT DELETED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • We have a problem with excessive number of rows in NC_Cell
    table.
    Current number is 1073268. We had a problem with inconsistent
    mapping
    for GSM Ericsson G10 domain in October and November. Problem was
    solved, but it created around 400 k rows. We had the same
    problem for
    UMTS Ericsson domain last summer and Niall Cody for L3 was able
    to
    delete excessive rows. Please note that retention period of 45
    days is
    over (problem solved in mid-November), and NC_IDs for traffic
    tables
    can be deleted. We would have to worry about  summary and bh
    tables and
    not delete them. I will soon provide you with custom summary and
    bh
    definitions.
    

Local fix

  • Please note that this is a temporary script that we had provided
    to address the nc_cell issue since the current nc_archiver_admin
    did not check against summary and SBH tables. It is flexible
    enough to be used for different tables. However, it requires
    some manual inputs. The script that is used to generate csv file
    is not generic and is specific to nc_cell. This script will need
    to be created for particular tables. This is the limitation with
    the current script. Please raise an APAR to get this fix into
    next Interim Fixes to cater the reference in SBH, summary tables
    and overall performance. Once APAR is raised, the next available
    IF would be available by Q3 2013.
    

Problem summary

  • ERROR DESCRIPTION:
    NC table are growing due to rehoming.
    
    PROBLEM DESCRIPTION:
    nc_archiver_admin unable to clean nc tables due to number of
    rows is too large.
    
    PROBLEM SUMMARY:
    Current nc_archiver doesnt cater on summary and SBH and slow to
    complete.
    
    RESOLUTION:
    Improve nc_archiver to check faster and check against summary
    and SBH tables.
    
    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.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IV45129

  • Reported component name

    NETCOOL PM WIRE

  • Reported component ID

    5724T0100

  • Reported release

    131

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-02

  • 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

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:

131

Reference #:

IV45129

Modified date:

2013-07-31

Translate my page

Machine Translation

Content navigation