IBM Tivoli TrainingNetcool/Proviso 4.4.3
IBM Tivoli Training Netcool/Proviso 4.4.3 Re-indexing metadata tables
This IBM Education Assistant module demonstrates manually re-indexing metadata tables in Tivoli Netcool/Proviso 4.4.3.
Objectives
Objectives Upon completion of this module, you should be able to: Manually re-index metadata table spaces using the dbMgr command Identify the Netcool/Proviso tool, Database Information, that contains information about the metadata table spaces
Upon completion of this module, you should be able to: Manually re-index metadata using the dbMgr command Identify the Netcool/Proviso tool, Database Information, that contains information about the metadata table spaces
Metadata in Netcool/Proviso
Metadata in Netcool/Proviso Netcool/Proviso uses metadata to keep track of the topology of the network resources and the components of the Netcool/Proviso installation. Metadata is never deleted or purged. It contains a record of the resources Netcool/Proviso reports, including changes to those resources. As new devices are discovered and changes to existing devices are found, the metadata tables are augmented. It is critical to monitor the free space of the table spaces. It is also critical to periodically re-index the metadata table spaces to insure proper reporting performance.
Netcool/Proviso uses metadata to keep track of the topology of the network resources and the components of the Netcool/Proviso installation. Metadata is never deleted or purged. It contains a record of the resources Netcool/Proviso reports, including changes to those resources. As new devices are discovered and changes to existing devices are found, the metadata tables are augmented. It is critical to monitor the free space of the table spaces. It is also critical to periodically re-index the metadata table spaces to insure proper reporting performance.
Monitoring metadata table space
Monitoring metadata table space Using PVM, click Monitor and Database Information
Set the datamart environment variables and issue the pvm command at a command-line prompt. Make sure the display is set. In the DataMart graphical user interface (GUI), click the Monitor tab and click Database Information.
Click the MetaData tab
Click the MetaData tab
The MetaData tab shows information about Netcool/Proviso configuration elements, metrics, and properties. Metadata represents data such as table space and table information. Metadata is grouped by topic (for example, configuration, temporary table spaces, system table spaces). Netcool/Proviso describes each resource, collection and aggregation schedules, and management information bases (MIBs). Expand the MetaData directory on the left hand side of the GUI to browse the metadata detail. You can find information about the tables and their state.
Re-index metadata
Re-index metadata
Use the dbMgr command to re-index metadata table spaces. At a command-line prompt, set the DataMart environment variables and issue the dbMgr command.
Run dbMgr
Run dbMgr
You can use the dbMgr command to perform multiple procedures. Each procedure is identified by a number. You must choose the individual procedure before running the dbMgr command. The procedure to re-index the metadata tables is choice number 3 and is called analyzeMetaDataTables. At the Choice prompt, type 3 and press Enter.
Select the Set of tables option
Select the Set of tables option
You must set two arguments before re-indexing the metadata tables. The first argument is the selection of the set of tables to re-index. The second argument is to select whether or not to Force analyze. The default is N, or no. If you do not want to force the re-index, use the default. You can set the Force analyze to Y, or yes, by choosing 2 and setting the subsequent value choice to Y. That choice forces the metadata tables to re-index. Choose 1 to set the tables to re-index.
Select tables to analyze
Select tables to analyze
There are several choices of tables that you can set for re-indexing. You can select the history, grouping, and inventory tables individually, or you can re-index all three. Type the value to re-index, either A, H, G, or I, and then press Enter.
Analyze selected tables
Analyze selected tables
The second option that you can be choose is Force analyze. You can set it to Y or N, but the default is N. If you must force the re-index, choose 2 and set the value to Y. When you have set both arguments, Set of tables and Force analyze, type E and confirm that you want to re-index by typing y at the confirmation prompt.
Review results
Review results
When the re-index completes, the results are displayed. A result of 0 indicates that the re-index has completed successfully. Type enter to quit the results page.
Command-line analyze command
Command-line analyze command
You can place the re-index of metadata tables in a cron. You can issue the dbMgr command with arguments. To re-index without using the interactive dbMgr tool, run the dbMgr command with the analyzeMetaDataTables argument and the following options: The set of tables to run against (A, H, I, or G) Whether to force the re-index (The default is no option specified, or N). Scheduling the re-index of metadata tables in a cron ensures that metadata table indexes will not adversely affect reporting performance
Summary
Summary You should now be able to: Manually re-index metadata table spaces using the dbMgr command Identify the Netcool/Proviso tool, Database Information, that contains information about the metadata table spaces
You should now be able to: Manually re-index metadata table spaces using the dbMgr command Identify the Netcool/Proviso tool, Database Information, that contains information about the metadata table spaces
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