Layout of the accounting information

SESAM/SQL creates an accounting record (DBS1 record) for each user session. At the end of the user session, the accounting record is made available in the accounting buffer:

The contents of this buffer are written to the BS2000 accounting file and can be further processed by the RAV accounting procedure.

DBS1 record

Field	Length	Meaning
1	2	Total record length
2	2	Free
3	4	Record ID: “DBS1”
4	8	Timestamp (STCK format)
5	2	Length of the user information
6	2	Length of the basic information: 80 bytes
7	4	Free
User information
8	8	TIAM: accounting number
9	8	TIAM: BS2000 ID
10	32	Requesting user: UTM R/L 1 DCAM R/L 1 TIAM R 1 TIAM L 1	1-8	9-16	17-24	25-32
			host	application	user	TAC name
			host	application	user	program name
			host	TSN=tsn	program name	userid
			request name	TSN=tsn	program name	userid
Basic information
11	8	Source: q = {R| L} 1	UTM		SESAMUq
			DCAM		SESAMDq
			TIAM		SESAMTq
12	4	Number of physical file accesses
13	4	Number of logical file accesses
14	4	Number of DML statements

Field	Length	Meaning
15	4 4	Elapsed time in the following format: seconds nanoseconds
16	4 2 2 2 2 2 1	Beginning of user session: local time, printable Year Month Day Hour Minute Second Season: C'W': winter time, C'S': daylight saving time
17	1	Free
18	4 2 2 2 2 2 1	End of user session: local time, printable Year Month Day Hour Minute Second Season: C'W': winter time, C'S': daylight saving time
19	1	Free
Variable part
20	8	Host ID of the DBH
21	8	User ID of the DBH
22	8	Account # of the DBH
23	1	Configuration identifier
24	1	Name identifier
25	2	Number of variable fields: 1
26	2	Field distance: X'0000'
27	2	Field identification
28	2	Length of the variable field
29	4 4	CPU time in the following formats: seconds nanoseconds

Table 50: DBS1 record

¹R = remote, L = local