Auditable information for every SESAM object event

The table in the following shows a list of the events for the SAT object SESAM, with the associated information fields and their type of output:

M = Mandatory (is always output)

O = Optional (may be output)

- = is not output

Event of the object SESAM

evt

SAT-Information

a p p l n a m

a p p l u i d

d b h c o n f

d b h n a m

d b n a m e

d b t a b l e

h o s t n a m

s c h e m a

s e s s u b c

s e s t e x t

s t m t c t f

s t m t c t s

u t m s c t

u t m u s e r

Administer DBH session

SEA

M

O

M

M

-

-

M

-

M

M

-

-

M

M

Change access rights and user accesses

SEP

M

O

M

M

M

-

M

-

M

O

-

-

M

M

DDL, SSL, utility statement

SES

M

O

M

M

M

O

M

O

M

O

-

-

M

M

Start or stop SESAM task (DBH or Service-Task)

SET

-

-

M

M

-

-

-

-

M

M

-

-

-

-

Stop process

SEU

M

O

M

M

-

-

M

-

M

-

M

M

M

M

Table 53: Auditable information of the events of the SAT object SESAM

The table below shows the values present in the various fields.

The field names which can also be monitored via the alarm function of SAT or for which a filter condition can be defined are identified in the second column (al/fil) by means of an asterisk (*). The asterisk (*) mark means that aside from the existence of the field the contents of the field can also be checked.

The identifier in the third column (exit) can be used to edit the SAT information in the audit records when using exit routine 110. The identifiers are specified in hexadecimal notation.

Fieldname	al/ fil	exit	Meaning and values of information: SDF data type or keywords
applnam	*	0025	Application name 1 type: c-string 1..8 In case of a TIAM program the field contains the string 'TSN=<tsn>' where <tsn> stands for the tsn of the application program. With logging of an administration statement via /INFORM-PROGRAM this field contains the string ' SEND'.
appluid	*	0162	Application user id type: c-string 1..8 With logging of an administration statement via /INFORM-PROGRAM this field is not filled.
dbhconf	*	0160	DBH configuration identifier 2 type: c-string 1..1
dbhnam	*	015F	DBH name identifier2 type: c-string 1..1
dbname	*	0165	Name of the database type: c-string 1..18 Logical database name to which the statement relates.
dbtable	*	0167	Table name in the catalog type: c-string 1..31 Table name which is addressed in a statement. This field is only supplied if the name is known at the time of logging.
hostnam	*	0029	Name of the host of the user program 1 type: c-string 1..8 With logging of an administration statement via /INFORM-PROGRAM this field contains the string ' SESAM'.
schema	*	0166	Schema name in the catalog type: c-string 1..31 Schema which is addressed in a statement. This field is only supplied if the name is known at the time of logging.
sessubc	*	015E	Subcode for the SESAM events type: c-string 1..4 The following subcodes can be evaluated, depending on the event concerned: Event SET STRT: Start of a SESAM task (DBH or service task) END: End of a SESAM task (DBH or service task) Event SEU END: End of process Event SEA ADM: Administer DBH session Event SEP USR: Add/remove/modify users PRI: Grant/revoke rights Event SES DDL: DDL statement SSL: SSL statement UTI: utility statement
sestext	*	0168	Additional information about the SESAM event type: c-string 1..64 Depending on the event, the following additional information is given, if it exists, at the time of logging: 'DBH-Task' when a DBH task has been started or terminated 'Service-Task' when a service task has been started or terminated The first 64 characters of an adminisration statement Brief statement texts such as 'ALTER_TABLE' or 'COPY_CATALOG' in the case of DDL, SSL or utility statements. If the statement has altered the catalog, the statement number, the internal TAID and number and subnumber of the catalog will also be issued. This information is used to understand the changes with the catalog.
stmtctf	*	0164	Number of unsuccessful statements in the process type: integer 0..231-1 A statement is unsuccessful if it is not acknowledged with “successful completion”, “no data” or “rollback”.
stmtcts	*	0163	Number of successful statements in the process type: integer 0..231-1 A statement is successful if it is acknowledged with “successful completion”, “no data” or “rollback”.
utmsct	*	0161	UTM session counter 1 type: x-string 2..16 (ALARM/FILTER: x-string 16..16)
utmuser	*	0048	UTM user name 1 type: c-string 1..8 With logging of an administration statement via /INFORM-PROGRAM this field contains the string ' MESSAGE'.

Table 54: Field names and values for the SAT object SESAM

¹A specific process can be identified with the hostnam, applnam, utmuser and utmsct fields

²The SAT log records for all tasks of a database handler can be identified with the dbhnam and dbhconf fields