+---------------------Programming interface information----------------------+
| Task | Required Privilege Class |
|---|---|
| Set accounting records on or off | System |
ADSM accounting records show the server resources used during a session. This information lets you track resources used by a client node session. At installation, accounting is set off. You can set accounting on by entering:
set accounting on
When accounting is set on, the server creates a session resource usage accounting record whenever a client node session ends.
Accounting records are stored in a file, dsmaccnt.log, in the directory from which the server is started. The file contains text records that can be viewed directly or can be read into a spreadsheet program.
The file remains opened while the server is running and accounting is set on. The file continues to grow until you delete it or prune old records from it. To close the file for pruning, either temporarily set accounting off or halt the server.
There are 29 fields, which are delimited by commas (,). Each record
ends with a new-line character. Each record contains the following
information:
| Field | Contents |
|---|---|
| 1 | Product level |
| 2 | Product sublevel |
| 3 | Product name, 'ADSM', |
| 4 | Date of accounting (mm/dd/yyyy) |
| 5 | Time of accounting (hh:mm:ss) |
| 6 | Node name of ADSM client |
| 7 | Client owner name (UNIX) |
| 8 | Client Platform |
| 9 | Authentication method used |
| 10 | Communication method used for the session |
| 11 | Normal server termination indicator (Normal=X'01', Abnormal=X'00') |
| 12 | Number of archive database objects inserted during the session |
| 13 | Amount of archived files, in kilobytes, sent by the client to the server |
| 14 | Number of archived database objects retrieved during the session |
| 15 | Amount of space, in kilobytes, retrieved by archived objects |
| 16 | Number of backup database objects inserted during the session |
| 17 | Amount of backup files, in kilobytes, sent by the client to the server |
| 18 | Number of backup database objects retrieved during the session |
| 19 | Amount of space, in kilobytes, retrieved by backed up objects |
| 20 | Amount of data, in kilobytes, communicated between the client node and the server during the session |
| 21 | Duration of the session, in seconds |
| 22 | Amount of idle wait time during the session, in seconds |
| 23 | Amount of communications wait time during the session, in seconds |
| 24 | Amount of media wait time during the session, in seconds |
| 25 | Client session type. A value of 1 or 4 indicates a general client session. A value of 5 indicates a client session that is running a schedule. |
| 26 | Number of space-managed database objects inserted during the session |
| 27 | Amount of space-managed data, in kilobytes, sent by the client to the server |
| 28 | Number of space-managed database objects retrieved during the session |
| 29 | Amount of space, in kilobytes, retrieved by space-managed objects |
The following shows an example of two records:
0,8,ADSM,06/03/1996,16:26:37,node1,,AIX,1,Tcp/Ip,0,254,1713,0,0,47,1476,0,0,3316,960,27,5,1,4,0,0,0,0 0,8,ADSM,06/03/1996,18:01:48,node2,,OS/2,1,Tcp/Ip,1,85,610,0,0,53,611,0,0,2133,78,48,6,1,4,0,0,0,0
+------------------End of Programming interface information------------------+