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