IV45129: EXCESSIVE ROWS SUMMARY AND BH TABLES ARE NOT DELETED
A fix is available
Closed as fixed if next.
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.
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.
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 22.214.171.124-TIV-TNPM-IF0005. Note that this is subject to change at the discretion of IBM.
Reported component name
NETCOOL PM WIRE
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Applicable component levels