+---------------------Programming interface information----------------------+
Task | Required Privilege Class |
---|---|
Set accounting records on or off | System |
TSM accounting records show the server resources that are used during a session. This information lets you track resources that are used by a client node session. At installation, accounting defaults to OFF. You can set accounting on by entering:
set accounting on
When accounting is on, the server creates a session resource usage accounting record whenever a client node session ends.
CPU usage information is not recommended for use in billing because it does not account for all CPU time used for the client. In addition to time not recorded for database activity during the session, CPU usage for migration, expiration, reclamation, and administrator activities on behalf of a client are not recorded.
Accounting records are stored in an SMF file as SMF record type 42 subtype
14 records:
Offset | Length | Field Type | Contents | |
---|---|---|---|---|
Decimal | Hex | |||
0 | 0 | 2 | Binary | Record length (standard SMF record header) |
2 | 2 | 2 | Binary | Segment descriptor (standard SMF record header) |
4 | 4 | 1 | Binary | System level identifier (standard SMF record header) |
5 | 5 | 1 | Binary | Record type, 42 (standard SMF record header) |
6 | 6 | 4 | Binary | Record time (standard SMF record header) |
10 | A | 4 | Packed | Record date (standard SMF record header) |
14 | E | 4 | EBCDIC | System ID (standard SMF record header) |
18 | 12 | 4 | EBCDIC | Subsystem ID (standard SMF record header) |
22 | 16 | 2 | Binary | Record subtype, 14 |
24 | 18 | 2 | Binary | Number of triplets, 2 (offset/length/number of entries) |
26 | 1A | 2 | N/A | Reserved |
28 | 1C | 4 | Binary | Offset to product section |
32 | 20 | 2 | Binary | Length of product section, 12 |
34 | 22 | 2 | Binary | Number of product sections, 1 |
36 | 24 | 4 | Binary | Offset to TSM section |
40 | 28 | 2 | Binary | Length of TSM section |
42 | 2A | 2 | Binary | Number of TSM sections, 1 |
44 | 2C | 1 | Binary | Product level |
45 | 2D | 1 | Binary | Product sublevel |
46 | 2E | 8 | EBCDIC | Product name, TSM |
54 | 36 | 2 | N/A | Reserved |
56 | 38 | 30 | EBCDIC | Node name of the client. If the node name does not fit completely
within 30 characters, the client node name is listed as:
first...last where first is the first 17 characters of the node name and last is the last 10 characters of the node name. |
86 | 56 | 14 | EBCDIC | Date and time of accounting (yyyymmddhhmmss) |
100 | 64 | 4 | Binary | Duration of session, in seconds |
104 | 68 | 4 | Binary | Number of archive database objects inserted during the session |
108 | 6C | 4 | Binary | Number of backup database objects inserted during the session |
112 | 70 | 4 | Binary | Amount of archived files, in kilobytes, sent by the client to the server |
116 | 74 | 4 | Binary | Amount of backed up files, in kilobytes, sent by the client to the server |
120 | 78 | 4 | Binary | Amount of data, in kilobytes, communicated between a client node and the server during this session |
124 | 7C | 8 | EBCDIC | Client owner name (UNIX) |
132 | 84 | 8 | EBCDIC | Node type. |
140 | 8C | 8 | EBCDIC | Communication method used for session |
148 | 94 | 4 | Binary | Number of archive database objects retrieved during the session |
152 | 98 | 4 | Binary | Number of backup database objects retrieved during the session |
156 | 9C | 4 | Binary | Amount of space, in kilobytes, retrieved by archived objects |
160 | A0 | 4 | Binary | Amount of space, in kilobytes, retrieved by backed up objects |
164 | A4 | 4 | Binary | Amount of Idle Wait time, in seconds, during the session |
168 | A8 | 4 | Binary | Amount of Communications Wait time, in seconds, during the session |
172 | AC | 4 | Binary | Amount of Media Wait time, in seconds, during the session |
176 | B0 | 4 | Binary | Amount of CPU usage, in seconds, used by the server for basic client activity. This amount includes CPU usage to send or receive data from the client but does not include CPU usage to place data on, or retrieve it from database storage. |
180 | B4 | 1 | Binary | Authentication method used |
181 | B5 | 1 | Binary | Normal termination indicator (Normal=X'01') |
182 | B6 | 2 | Binary | 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. |
184 | B8 | 4 | Binary | Number of space-managed database object inserted during the session. |
188 | BC | 4 | Binary | Amount of space-managed data, in kilobytes, sent by the client to the server. |
192 | C0 | 4 | Binary | Number of space-managed database objects retrieved during the session. |
196 | C4 | 4 | Binary | Amount of space, in kilobytes, retrieved by space-managed objects. |
+------------------End of Programming interface information------------------+