Adding Workload Reduction CSV files to Model Builder Tasks

BMC AMI Cost Management can provide support for IBM Mobile Workload Pricing (MWP) and z Systems Collocated Application Pricing (zCAP) in your cost models when you are using the CSV reporting method. This topic provides procedures for adding Workload Reduction CSV files to the next Model Builder Task that runs.

Use one of the following procedures to add Workload Reduction CSV files (either MWP or zCAP) to a Model Builder Task:

• Upload CSV files using Manage Model Builder Tasks Administration Tool
• Copy CSV files to a staging folder on the Cost Management application server

When performing either of these procedures take note of the following conditions:

• You need to upload a CSV file for every month that MWP or zCAP was in effect.
• The next Model Builder Task that runs is automatically associated with the uploaded CSV files.
• You cannot associate CSV files with more than one Model Builder Task.
• After you upload a CSV file for a particular month, you need to rebuild the cost models for that month in order to apply MWP or zCAP to your MLC costs.
    

To upload CSV files using Manage Model Builder Tasks Administration Tool 

Mobile Workload and zCAP support are added to the next Model Builder Task that runs by using the Workload Reduction Support link in the Manage Model Builder Tasks administration tool.

1. From the Cost Management console, click Administration Tools.

2. From the Administration Tools, click Manage Model Builder Tasks.

   The Model Builder Task Manager dialog box is displayed listing all the tasks defined by you.

   

   Note

   In the dialog box, you cannot select a specific Model Builder Task to associate with the CSV files. Workload Reduction Support is applied only to the next Model Builder Task that is run.

3. Click the Workload Reduction Support link.

   The Workload Reduction Support dialog box is displayed.
   

   Tip

   The Workload Reduction Support dialog box enables you to upload the same comma-separated value (CSV) files that you used to report both your mobile CPU consumption and your zCAP activity to IBM. 

4. In the SCRT CSV Files section, click Browse and navigate to the location of the mobile CPU consumption CSV files or the zCAP activity CSV files that you want to add to the next Model Builder Task that runs.

5. Select one or more mobile CPU consumption CSV files or zCAP activity CSV files and click Open.
   Cost Management imports the CSV files and lists them in the SCRT CSV Files section of the Workload Reduction Support dialog box.

   Note

   The following conditions apply:

   • The next Model Builder Task that runs will be associated with the uploaded CSV files.
   • Cost Management verifies that your CSV files are valid before uploading them.
     However, Cost Management does not verify the eligibility of specified MLC products or the validity of your specified CPU metrics. We recommend using only valid CSV files that were specified in the SCRT task and processed successfully.
   • You can remove any CSV file from the list by highlighting the file and clicking Remove.

6. (Optional) In the Workload Manager section of the dialog box, select Ignore WLM RMF mobile data if you want to ignore WLM RMF mobile data during the model build process.

   Tip

   Your specification should match the specification that you use for SCRT. For example, assume that you select Ignore WLM RMF mobile data and upload CSV files when using SCRT to report MSU utilization to IBM. You should perform identical specifications and upload the same CSV files using the Workload Reduction Support dialog box.

7. Click Accept after making your selection.
    

   Note

   You cannot remove a CSV file after you click Accept. However, you can overwrite any uploaded CSV file by using a different CSV file with the same name. For example, if you want to remove the effect of the CSV file from the cost model, you can prepare an empty CSV file with the same name and add it to the Workload Reduction Support. The empty CSV file replaces the original CSV file. During the model build process, 

   Cost Management

    will not apply any workload reduction costs because they no longer exist in the file.

To copy CSV files to a staging folder on the Cost Management application server 

1. On your local computer, navigate to the location of the mobile CPU consumption CSV files that you want to add to the next Model Builder Task that runs.
2. Copy the Workload Reduction CSV files (either WMP or zCAP) that you want to add.
3. On the Cost Management application server, navigate to C:\Program Files (x86)\BMC Software\SCA\Services\App_Data.

4. Paste the CSV files into the MWPStaging folder.

   Cost Management applies the CSV files to the next Model Builder Task that runs. If you are adding CSV files for a previous month, you need to rebuild the cost model before generating an MLC Monthly Summary Report or working with an LPAR and Workload Plan. For more information, see Running-the-Model-Builder-Task-manually.

   Note

   The following conditions apply:

   • The MWPStaging folder is not a repository for the CSV files. Cost Management uses the CSV files during the next model build process and then removes them from the folder.
   • It is the responsibility of the product administrator to ensure that the CSV files are valid for use in reporting MWP or zCAP activity according to specifications established by IBM SCRT.

Where to go from here

Cost Management applies the CSV files to the next Model Builder Task that runs. If you are adding MWP or zCAP CSV files for a previous month, you need to rebuild the cost model before generating an MLC Monthly Summary Report or working with an LPAR and Workload Plan. You can wait for the next scheduled Model Builder Task to complete, or you can run the Model Builder Task manually. For more information, see Running-the-Model-Builder-Task-manually.

After the Model Builder Task is complete, you should check the Model Build Log file for any messages. Any issues or problems with the CSV file are contained in the log. For more information, see Displaying-Cost-Management-log-files and Model-Build-Logs.