IBM Tivoli Storage Manager, Version 7.1

Estimating processor value units

To estimate the number of processor value units (PVUs) for your system, use the QUERY PVUESTIMATE, SELECT * FROM PVUESTIMATE_DETAILS, or the QUERY NODE command.

Before you begin

Before you begin, review the information about how PVUs are estimated and what the limitations are. For more information, see Role of processor value units in assessing licensing requirements. Tivoli Storage Manager offers several options for viewing PVU information. Select the option that best meets your needs. To export the PVU estimates to a spreadsheet, use the SELECT * FROM PVUESTIMATE_DETAILS command.

Important: The PVU calculations that are provided by Tivoli Storage Manager are considered estimates and are not legally binding.

Procedure

To estimate PVUs, complete the following steps:

To ensure that you have the latest IBM PVU table, go to the FTP site at ftp://public.dhe.ibm.com/software/tivoli_support/misc/CandO/PVUTable/.
Download the file for the latest table and rename it IBM_ProcessorValueUnitTable.xml.
Copy the renamed file to the Tivoli Storage Manager server instance directory. Alternatively, you can store the file in the server installation directory, where it replaces the installed file. Then, restart the server.
Tip: The IBM_ProcessorValueUnitTable.xml file name is case-sensitive. Ensure that the file name on your system matches this file name.
A version of the IBM PVU table is also provided with the Tivoli Storage Manager installation.

Obtain the type of PVU information that you require:

Option	Description
Product-based information	To obtain a PVU report that is categorized by product, issue the QUERY PVUESTIMATE command. For more information about the QUERY PVUESTIMATE command, see QUERY PVUESTIMATE (Display processor value unit estimate). Remember: The reports that are produced by the QUERY PVUESTIMATE and SQL SELECT * FROM PVUESTIMATE_DETAIL commands provide information about all client and server devices that are managed by the Tivoli Storage Manager server. However, PVU estimates are provided only for the V6.3 server devices that established a connection with the Tivoli Storage Manager server since the installation of or upgrade to Tivoli Storage Manager V6.3.
Node-based information	To obtain a PVU report that provides detailed information at the node level, issue the SELECT * FROM PVUESTIMATE_DETAILS command. For more information about the SELECT command, see SELECT (Perform an SQL query of the IBM® Tivoli Storage Manager database). After you obtain data from the SELECT * FROM PVUESTIMATE_DETAILS command output, you can move the data to a spreadsheet. Then, modify the data to gain a more accurate estimate. To export data to a spreadsheet, use the `-comma` and `> output` redirection options of the dsmadmc administrative command-line client with the SELECT administrative command. For example, complete the following steps: `dsmadmc -comma select * from pvuestimate_details > pvuestimatefile.csv` Import the resulting CSV file into a spreadsheet program.
Complete information	To view complete information, including PVU-related fields that are provided by Common Inventory Technology, such as processor vendor, brand, type, model, and processor count for selected nodes, specify the DETAILED value for the FORMAT parameter. For more information about the QUERY NODE command, see QUERY NODE (Query nodes).

Option

Description

Product-based information

To obtain a PVU report that is categorized by product, issue the QUERY PVUESTIMATE command. For more information about the QUERY PVUESTIMATE command, see QUERY PVUESTIMATE (Display processor value unit estimate).

Remember: The reports that are produced by the QUERY PVUESTIMATE and SQL SELECT * FROM PVUESTIMATE_DETAIL commands provide information about all client and server devices that are managed by the Tivoli Storage Manager server. However, PVU estimates are provided only for the V6.3 server devices that established a connection with the Tivoli Storage Manager server since the installation of or upgrade to Tivoli Storage Manager V6.3.

Node-based information

To obtain a PVU report that provides detailed information at the node level, issue the SELECT * FROM PVUESTIMATE_DETAILS command. For more information about the SELECT command, see SELECT (Perform an SQL query of the IBM® Tivoli Storage Manager database). After you obtain data from the SELECT * FROM PVUESTIMATE_DETAILS command output, you can move the data to a spreadsheet. Then, modify the data to gain a more accurate estimate.

To export data to a spreadsheet, use the -comma and > output redirection options of the dsmadmc administrative command-line client with the SELECT administrative command. For example, complete the following steps:

dsmadmc -comma select * from pvuestimate_details > pvuestimatefile.csv
Import the resulting CSV file into a spreadsheet program.

Complete information

To view complete information, including PVU-related fields that are provided by Common Inventory Technology, such as processor vendor, brand, type, model, and processor count for selected nodes, specify the DETAILED value for the FORMAT parameter. For more information about the QUERY NODE command, see QUERY NODE (Query nodes).

To obtain a more accurate PVU estimate, you might want to change the classifications of nodes. To change node classifications, issue the UPDATE NODE command. For more information about the UPDATE NODE command, see UPDATE NODE (Update node attributes).
To calculate the PVUs for a node, use the following formula: PVUs = number of processors on the node * processor type (core count) * pvu value. To calculate the total PVUs, sum the PVUs for all nodes. For more information about the PVU estimation formula, see Formula for PVU estimation.
After you generate a PVU report, more analysis might include removing redundancies, deleting obsolete information from the report, and accounting for known systems that are not logged in to and connected to the server.
Tip: If you cannot obtain PVU information from a client node that is running on a Linux operating system, ensure that Common Inventory Technology is installed on that client node. After you install Common Inventory Technology, obtain a new PVU estimate.

Feedback