Description of UDS/SQL monitor output to a file

In response to the UDSMON command MEDIUM=F,n,[D] the UDS/SQL monitor writes data records to the output file after each specified time interval.
A label is written to the file when UDSMON output starts or if the time interval is changed.

The output file is a SAM file with variable-length records. The current counter readings are output in binary form.

For UDS-D:
If D (=distributed) is entered during operation in UDS-D mode, UDS-D operation is evaluated as well.

In such cases the structure of the output file is as follows:
UDS/SQL label
UDS-D label
UDS/SQL data record
UDS-D data record
. . .

The UDS-D label is output when UDSMON output starts, if the time interval is changed, if the DBH load parameter PP PTCSYNCH is changed, or if the distribution table is activated or deactivated.

The record format may change in a subsequent version of UDS/SQL. As a rule this will entail increasing the record length.

The UDS/SQL version number appears in label field 4 (see the table “UDS/SQL label format”).

Record format for file output

UDS/SQL label format

Field number	Field contents		Displacement [dec]	Length [bytes]
1	Record length		0	2
2	Filler		2	2
3	Record identifier X'0010'		4	2
4	UDS/SQL version number X'0290' =V2.9		6	2
5	Time in STCK format		8	8
6	Configuration name		16	20
7	Time interval in seconds		36	4
8	PP SERVERTASK		40	2
9	PP TRANSACTION		42	2
10	PP 2KB-BUFFER-SIZE		44	2
11	PP MAXDB		46	2
12	PP SUBSCHEMA		48	2
13	PP LOG	X'00' no RLOG	50	1
		X'01' single RLOG
		X'02' duplicate RLOG
14	PP CPU	X'00' CPU-MONO	51	1
		X'01' CPU-MULTI
15	PP DEACT	X'00' DEACTIVE=YES	52	1
		X'01' DEACTIVE=NO
16	PP SCHEDULING	X'00' SYMMETRIC	53	1
		X'01' ASYMMETRIC
17	PP IO	X'00' ASYNCHRON	54	1
		X'01' SYNCHRON
18	Filler		55	1
19	Processor type, e.g. C'S150-60'		56	8
20	Internal identifier for the operating system and the operating system version		64	4
21	DCAM processor name (e.g. D016ZE09)		68	8
22	Main memory size in Kbyte, printable		76	8
23	Number of processors, printable		84	2
24	up to 8 serial numbers (binary) 3-byte identification number for each CPU (bytes 0-2: number of first CPU, bytes 3-5: number of second CPU, ...)		86	24
25	PP SQL		110	2
26	Filler (for internal use)		112	4
27	PP 4KB-BUFFER-SIZE		116	2
28	PP 8KB-BUFFER-SIZE		118	2
29	Date (printable) Format: yyyy-mm-dd		120	10
30	Time (printable) Format: hh:mm:ss		130	8
31	Values for the local time zone Format: shh 1:mm 1-hh 2:mm 2-t s: sign (“+“ or “-” for the time difference between local time zone and UTC time (Greenwich time) hh 1:mm 1: time difference between local time zoneand UTC time in hours (hh 1) and minutes (mm 1) hh 2:mm 2: time difference between daylight savingtime and normal time (i.e. summer and winter time) in hours (hh 2) and minutes (mm 2) t: current time setting for the local time zone(”W” for winter time, “S” for summer time)		138	14

Table 28: UDS/SQL label format

UDS-D label format

Field number	Field contents			Displacement [dec]	Length [byte]
1	Record length			0	2
2	Filler			2	2
3	Record identifier		X'0020'	4	2
4	UDS-D version number		X'0290' =V2.9	6	2
5	Time in STCK format			8	8
6	Time interval in seconds			16	4
7	PP TRANSACTION LOCAL or GLOBAL			20	2
8	PP TRANSACTION simultaneous STTs			22	2
9	PP CHCKTIME in seconds			24	2
10	PP DEADTIME in seconds			26	2
11	PP DISDB			28	2
12	PP PTCSYNCH-WARM		X'00' WAIT X'01' ABORT X'02' COMMIT	30	1
13	PP PTCSYNCH-SESSION		X'00' WAIT X'01' ABORT X'02' COMMIT	31	1
14	PP DISTABLE	X'00' no distribution table X'01' distribution table		32	1
15	Filler			33	3
16	Date (printable). Format: yyyy-mm-dd			36	10
17	Time (printable). Format: hh:mm:ss			46	8
18	Values for the local time zone. Format: shh 1:mm 1-hh 2:mm 2-t s: sign (“+“ or “-“ for the time difference between local time zone and UTC time (Greenwich time) hh 1:mm 1: time difference between local time zone and UTCtime in hours (hh 1) and minutes (mm 1) hh 2:mm 2: time difference between daylight saving time andnormal time (i.e. summer and winter time) in hours (hh 2)and minutes (mm 2) t: current time setting for the local time zone (”W” for winter time, “S” for summer time)			54	14

Table 29: UDS-D label format

UDS/SQL data record format

Field number	Field contents	Displacement [dec]	Length [bytes]
1	Record length	0	2
2	Filler	2	2
3	Record identifier X' 0011'	4	2
4	Filler	6	2
5	Time in STCK format	8	8
6	Free server tasks	16	4
7	Active transactions	20	4
8	Active SQL conversations	24	4
9	Number of DML statements	28	4
10	Number of transactions	32	4
11	Number of update transactions	36	4
12	Number of data deadlocks	40	4
13	Number of global task deadlocks	44	4
14	Filler (assigned the value 0)	48	4
15	Number of PPPs	52	4
16	Number of PPP OK	56	4
17	Number of LOCK-CALLs	60	4
18	Number of LOCK-Waits	64	4
19	Number of US --> ST requests	68	4
20	Number of ITC US --> ST	72	4
21	Number of ST --> ST requests	76	4
22	Number of ITC ST --> ST	80	4
23	Number of ITC ST --> US	84	4
24	Number of LOG. READ DBs	88	4
25	Number of LOG. WRITE DBs	92	4
26	Number of PHYS. READ DBs	96	4
27	Number of PHYS. WRITE DBs	100	4
28	Number of LOG. READ RLOGs	104	4
29	Number of LOG. WRITE RLOGs	108	4
30	Number of PHYS. READ RLOGs	112	4
31	Number of PHYS. WRITE RLOGs	116	4
32	Number of PHYS. READ ALOGs	120	4
33	Number of PHYS. WRITE ALOGs	124	4
34	Number of LOG. READ ALOGs	128	4
35	Number of LOG. WRITE ALOGs	132	4
36	Number of SEQUENTIAL READ DBs	136	4
37	Number of ACCEPT CRU without ITC	140	4
38	Number of SQLDMLs	144	4
39	Number of BIBs generated from SQLDML	148	4
40	Number of SQL transactions	152	4
41	Number of remote UPDATE transactions	156	4
42	Number of processed SQL conversations	160	4
43	Filler	164	4
44	Sum of TA times in seconds (binary)	168	4
45	Number of monitored transactions	172	4
46	Number of LOG. READ 2KB-DBs	176	4
47	Number of LOG. WRITE 2KB-DBs	180	4
48	Number of PHYS. READ 2KB-DBs	184	4
49	Number of PHYS. WRITE 2KB-DBs	188	4
50	Number of LOG. READ 4KB-DBs	192	4
51	Number of LOG. WRITE 4KB-DBs	196	4
52	Number of PHYS. READ 4KB-DBs	200	4
53	Number of PHYS. WRITE 4KB-DBs	204	4
54	Number of LOG. READ 8KB-DBs	208	4
55	Number of LOG. WRITE 8KB-DBs	212	4
56	Number of PHYS. READ 8KB-DBs	216	4
57	Number of PHYS. WRITE 8KB-DBs	220	4
58	Number of LOG. READ EXCL-DBs	224	4
59	Number of LOG. WRITE EXCL-DBs	228	4
60	Number of PHYS. READ EXCL-DBs	232	4
61	Number of PHYS. WRITE EXCL-DBs	236	4
62	Filler	240	10
63	Date (printable) Format: yyyy-mm-dd	250	10
64	Time (printable) Format: hh:mm:ss	260	8

Table 30: UDS/SQL data record format

UDS-D data record format

Field number	Field contents	Displacement [dec]	Length [bytes]
1	Record length	0	2
2	Filler	2	2
3	Record identifier X'0021'	4	2
4	Filler	6	2
5	Time in STCK format	8	8
6	STT ACTIVE OUT value	16	4
7	STT ACTIVE IN value	20	4
8	CONNECT ACTIVE OUT value	24	4
9	CONNECT ACTIVE IN value	28	4
10	Filler	32	4
11	Filler	36	4
12	Filler	40	4
13	Filler	44	4
14	Number of partners	48	4
15	RDML OUT value	52	4
16	RDML IN value	56	4
17	STT OUT value	60	4
18	STT IN value	64	4
19	CONNECT REQUEST OUT value	68	4
20	CONNECT REJECT OUT value	72	4
21	CONNECT REQUEST IN value	76	4
22	CONNECT REJECT IN value	80	4
23	DISCONNECT value	84	4
24	GLOB-DEADLOCKS SESS value	88	4
25	Filler	92	4
26	Date (printable) Format: yyyy-mm-dd	98	10
27	Time (printable) Format: hh:mm:ss	108	8

Table 31: UDS-D data record format