DB2 graphic QMF Version 8

Chargeback summary for a time period

This report allows you to associate a cost with QMF usage for real or informational chargeback purposes. It allows you to set a cost per unit for CPU seconds consumed and rows fetched and then it calculates a usage cost per user for the specified time period.

The following is an online example of the Chargeback Summary report:

Table 69. Sample Chargeback Summary [for a time period] Report
RAAMR10T ------------------------------- LINE 0000000 -- COLUMNS 001 080
Command ===>                                          Scroll ===> PAGE
*************************** TOP OF REPORT  ****************************
                          QMF RESOURCE USAGE BY USER
                       FOR PERIOD 2099-01-01 TO 2099-12-31
                          CPU COST $1.00  ROW COST $0.07
 
TSOID   SQLID  RUN COUNT   TOTAL CPU TIME  TOTAL ROW COUNT   TOTAL COST
-----   -----  ---------   ---------------  ---------------   --------
DBPUSR  DBPUSR        36            175.75            92148     $6,626
USER01  USER01        32             75.30            31329     $2,268
 
************************** BOTTOM OF REPORT ***************************
 

Input variables

This report requires the following input variables:

Begin Date
Enter the beginning date (in YYYY-MM-DD format) for which you want to obtain resource usage information.
End Date
Enter the ending date (in YYYY-MM-DD format) for which you want to obtain resource usage information.
Dollars per CPU
Enter the amount (in DECIMAL(5,2) format) which represents the dollar per CPU second consumed cost.
Dollars per Row
Enter the amount (in DECIMAL(5,2) format) which represents the dollar per row fetched cost.

How to run this report online

You can invoke this report by selecting option 10 from the Object Manager Reports Selection Menu.

How to run this report in batch

Edit the sample JCL member RAAMR10J in QMFHPO.SRAASAMP. See the comments in this JCL member for instructions on what modifications are necessary before submitting the batch job.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004