Accounting for a distributed relational database

 

You need to be able to account and charge for the use of distributed data.

Consider the following items:

• Accounting for the use of distributed data involves the use of resources in one or more remote systems, the use of resources on the local system, and the use of network resources that connect the systems.

• Accounting information is accumulated by each system independently. Network accounting information is accumulated independent of the data accumulated by the systems.

• The time zones of various systems might have to be taken into account when trying to correlate accounting information. Each system clock might not be synchronized with the remote system clock.

• Differences might exist between each system's permitted accounting codes (numbers). For example, the i5/OS^® operating system restricts accounting codes to a maximum of 15 characters.

The following functions are available to account for the use of distributed data:

• i5/OS job accounting journal. The system writes job accounting information into the job accounting journal for each distributed relational database application. The Display Journal (DSPJRN) command can be used to write the accumulated journal entries into a database file. Then, either a user-written program or query functions can be used to analyze the accounting data.

• NetView^® accounting data. The NetView licensed program can be used to record accounting data about the use of network resources.

 

Parent topic:

Developing a management strategy for a distributed relational database

 

Related reference

Display Journal (DSPJRN) command
Job accounting in a distributed relational database