A sample cost accounting report "Cost Accounting Example" is supplied with Review. It may be used without modification, customized to suit site requirements, or used as a basis for other cost accounting reports. The report definition for the "Cost Accounting Example" report is shown below:
12:08:58 A D A B A S - R E V I E W 2003-07-07
Edit Report HUB=00221
Report Name: COST ACCOUNTING EXAMPLE_________ DBID to Monitor:___
+-----------------------------------------------------------------+
| Field Order Sum Min Max Avg Pct Rate Round |
|-----------------------------------------------------------------|
| CQJOB___ _1 _ _ _ _ _ _ ______ |
| TPUSERID _2 _ _ _ _ _ _ ______ |
| COMMANDS __ X _ _ _ _ _ ______ |
| IOS_____ __ X _ _ _ _ _ ______ |
| CMDRESP_ __ X _ _ _ _ _ ______ |
| ADADURA_ __ X _ _ _ _ _ ______ |
| ________ __ _ _ _ _ _ _ ______ |
| ________ __ _ _ _ _ _ _ ______ |
| ________ __ _ _ _ _ _ _ ______ |
| ________ __ _ _ _ _ _ _ ______ |
+--------------------------- Page 1-------------------------------+
Command: ______________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Optns Exit Save Start - + Rules Flds Menu |
In this report, the generated NATURAL display program was modified to attach a cost value to the amounts of CPU time and Adabas time used, and to the number of Adabas calls and I/Os performed by each user.
By issuing the VW command, the report may be used to examine data that has been stored in the Adabas Review repository.
The following screen shows the type of information collected by the report:
11:21:07 COST ACCOUNTING EXAMPLE 2003-07-07
09:54:08 1999-08-09 Thru 11:21:07 1999-08-09 LOCL=00009
Num. of Total Total Total
Job TPUserid Commands IOs Cmd-Resp ADA-Dur
-------- -------- ------------ ------------ -------------- --------------
ALSCCOMP 151 210 1.1202 5.152688
******** SUB-T==> 151 210 1.1202 5.152688
COMPLETE 12 6 0.0702 0.251056
USER1 652 318 1.3057 6.523424
USER2 186 57 0.2409 0.903504
USER3 2775 1241 5.5287 26.014992
USER4 219 97 0.3831 2.337776
USER5 831 271 1.2486 7.082896
USER6 147 169 0.4203 2.965808
USER7 129 117 0.4519 2.433072
USER8 386 136 0.5802 3.022160
USER9 8030 5573 7.7051 107.307856
USER10 707 323 1.3217 6.409696
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Sort Exit ===> Menu |
Because the data spans the width of two screens, PF11 is provided to access the screen to the right and the additional columns of data.
11:21:07 COST ACCOUNTING EXAMPLE 2003-07-07
09:54:08 1999-08-09 Thru 11:21:07 1999-08-09 LOCL=00009
Call Cmd-Resp ADA Dura Total
Cost IO Cost Cost Cost Cost
----------- ----------- ----------- ----------- -----------
0.15 1.05 0.02 0.05 1.27
0.01 0.03 0.00 0.00 0.04
0.65 1.59 0.02 0.06 2.32
0.18 0.28 0.00 0.00 0.46
2.77 6.20 0.11 0.26 9.34
0.21 0.48 0.00 0.02 0.71
0.83 1.35 0.02 0.07 2.27
0.14 0.84 0.00 0.02 1.00
0.12 0.58 0.00 0.02 0.72
0.38 0.68 0.01 0.03 1.10
8.03 27.86 0.15 1.07 37.11
0.70 1.61 0.02 0.06 2.39
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Sort Exit <=== Menu |
From the above screen, PF10 enables you to scroll the screen back to the left.
Additionally, the displayed resource consumption data may be downloaded to a personal computer by using the DL command. To use this feature, the Software AG product Entire Connection must be installed.
Refer to the section Downloading Report Output in Managing Report Output.
