The DB2 Interface › JARSDB21: Debit Record Creation

JARSDB21: Debit Record Creation

In JARSDB21, CA JARS Wizard is used to:

• get accounting information for each DB2 user using a DB2 user ID and a CA JARS Wizard facility called file matching. This involves having CA JARS Wizard search a second file to find the accounting information associated with each user ID. Complete information on file matching can be found in the Wizard Reference Guide.
• calculate the charge for the user. In this sample the charge is based on CPU time and the number of read requests. Because CA JARS Wizard has a flexible language for computing new fields, and since all the information about the user's session with DB2 is carried in the DB2 account record, the charge can be based on anything in the record. For instance, a surplus could be charged for using DB2 during peak hours.
• sum the charges for the accounts and print a report that shows the charge by account.
• write a CA JARS debit record for each account. This debit record contains the account information and the charge that was calculated. All debit records are read in a run that reports on charges by account. The charge for the use of DB2 is added to the other charges that are calculated on an account basis.

JARSDB21 executes on the assumption that you have a secondary file containing one record for each unique DB2 user ID at your site. Each record in this secondary file also contains the necessary debit record accounting information. Report JARSDB21 assumes that the userid is in positions 1 to 8 and the accounting information is in positions 10 to 25, as shown below:

         1         2    2
1........0.........0....5
userid   accounting info.

If you do not have such a file, you must set one up or alter the JARSDB21 control statements accordingly.

A sample of this file is located CAJROPTN member JARSDBTB.

To execute JARSDB21, set up the necessary JCL for the run. See the CA JARS Wizard Reference Guide for sample JCL. Be sure to include DD statements for the following ddnames:

• CAIJWI (your DB2 input file)
• CAIJWI2 (the secondary file containing account information)
• CAIJWOP (the output file for the debit records)

The following sample report is produced with the debit record output file when JARSDB21 is run.

CA                                                       PROGRAM LISTING                      CA JARS Wizard PAGE 1
 CA JARS Wizard 9710JW230                                                                                23 MAR 1994 14.41.50
                                                       TOTAL CHARGES BY ACCOUNT

                                                                  CPU TIME              READ     DB2 ACCOUNT
                               ACCOUNT           TOTAL CHARGE       SS.SSS           REQUEST         RECORDS
                          ----------------     --------------     --------     -------------     -----------

                          FINANCE                      $24.12      110.620               227               4
                          MARKETING                    $44.81       97.760             2,111              58
                          NETWORK                      $34.51       93.080             1,346               4
                          OPERATIONS                    $7.43       14.470               378               8
                          R & D                         $9.08       17.190               444             163
                          SALES                        $13.21       42.560               408              15
                                      .
                                      .
                                      .
                                                       TOTAL CHARGES BY ACCOUNT                      23 MAR 1994 PAGE    2

                                                                  CPU TIME              READ     DB2 ACCOUNT
                               ACCOUNT           TOTAL CHARGE       SS.SSS           REQUEST         RECORDS
                          ----------------     --------------     --------     -------------     -----------

   GRAND TOTAL                                        $133.16      375.680             4,914             252