IBM Tivoli TrainingNetcool/Proviso 4.4.3
IBM Tivoli Training Netcool/Proviso 4.4.3 Purging metric data
This IBM Education Assistant module demonstrates manually purging metric data in TivoliŽ Netcool/Proviso 4.4.3.
Objectives
Objectives Upon completion of this module, you should be able to: Describe the sequence of manually purging metric data using the dbMgr command Locate the online Netcool/Proviso documentation source that details automating the metric data purge process
Upon completion of this module, you should be able to: Describe the sequence of manually purging metric data using the dbMgr command Locate the online Netcool/Proviso documentation source that details automating the metric data purge process
Manual data purge uses the dbMgr command
Manual data purge uses the dbMgr command
At a command prompt, set the /opt/datamart/dataMart.env and enter the dbMgr command. Do not purge metric data without proper authorization.
Use dbMgr to show partitions that can be purged
Use dbMgr to show partitions that can be purged
The dbMgr command returns a shell with a list of procedures. Choose showPurgeablePartitions, option 13.
Choose 1 to select channel
Choose 1 to select channel
A channel number and data type are selected. Choose 1 to go to channel selection.
Choose channel number
Choose channel number
Supply the channel number at the Value prompt. The current value shown is null.
Select 2 to choose data type to purge
Select 2 to choose data type to purge
You supply the data type by entering 2 at the Choice prompt.
Select data type to purge
Select data type to purge
The data types available to review are shown in the parameter line. In the example, NRAW is the value entered.
Choose E and confirm choice
Choose E and confirm choice
After you have supplied the channel and data type, choose E and reply y to the confirmation request.
Note the month, day, and year for purging
Note the month, day, and year for purging
The metric data purge requires that you supply the year, month, day, and hour (for NRAW data) of the of the metric data to purge in addition to the channel number and data type. The hour is stated as a two-place numerical value ranging from 01 to 24.
Choose 9 to purge the partition
Choose 9 to purge the partition
Return to the List of Procedures menu and select the purgePartitions procedure, choice 9.
Choose channel number
Choose channel number
Choose 1 to define the channel number.
Enter the channel number
Enter the channel number
Enter the channel number to use. The current value is null.
Choose the data type option
Choose the data type option
Choose 2 to supply the data type.
Enter the data type value
Enter the data type value
Select the data type to purge. NRAW is supplied in this example.
Choose the date option
Choose the date option
Choose 3 to supply the date of the metric data to purge.
Enter date value (YYYY.MM.DD-HR)
Enter date value (YYYY.MM.DD-HR)
Enter the date in the format YYYY.MM.DD-HH for NRAW data. The hour is a two-place numerical value, 01 to 24.
Choose execute and confirm choice
Choose execute and confirm choice
Choose E to purge the partition and confirm that you want to purge this partition.
Result of purge and location of log file displayed
Result of purge and location of log file displayed
The metric data purge takes time. When the metric data purge finishes, the result of the purge and the path to the log file for the purge are displayed.
Output from log file
Output from log file
The log file shows the tables dropped, partitions dropped, and table spaces dropped and the status of the purge request.
Need for an automated metric data purge
Need for an automated metric data purge Manual metric data purge is time consuming Only one channel, data type, can be purged at a time using the manual purge method An automated tool is available as part of the Netcool/Proviso distribution The automated tool and its use is detailed in Netcool/Proviso documentation
There is a need for an automated purge process in very large installations or installations where database space is at a premium. The manual purge procedures are time consuming. However, an automated metric data purge tool is included with the Netcool/Proviso distribution. This module does not cover the process of automating the metric data purge. It does, in the following slides, describe where to find the documentation to automate the metric data purge.
Open a Web browser
Open a Web browser
Open a Web browser and enter the following URL: http://publib.boulder.ibm.com
Choose support type and product
Choose support type and product
Select support type Tivoli and product Netcool/Proviso from the pull-down menus. Click the blue button to advance to the next Web page.
Select the product Netcool/Proviso
Select the product Netcool/Proviso
Click Netcool/Proviso.
Select Product manuals
Select Product manuals
Click Product manuals.
Expand the Netcool/Proviso documentation
Expand the Netcool/Proviso documentation
Expand Network Performance Management, IBM Tivoli Netcool/Proviso, and Netcool/Proviso 4.4.3.
Click Purging Metric Data in Technical Notes
Click Purging Metric Data in Technical Notes
Expand Technical Notes and click Purging Metric Data. The document that covers automating the metric data purge is displayed.
Summary
Summary You should now be able to: Describe the sequence of manually purging metric data using the dbMgr command Locate the online Netcool/Proviso documentation source that details automating the metric data purge process
You should now be able to: Describe the sequence of manually purging metric data using the dbMgr command Locate the online Netcool/Proviso documentation source that details automating the metric data purge process
Training roadmap for Netcool/Proviso
Training roadmap for Netcool/Proviso http://www.ibm.com/software/tivoli/education/edu_prd.html
Copy and paste the link provided into the Web browser of your choice to explore the Netcool/Proviso training roadmap.
Trademarks