| Audit: To determine the net result of the audit
configurationNo session is available that displays the net result of the
configuration when you convert the configuration to run time. To view the net
result for a specific table or field, you can use the Where Used Audit Tables (ttaud3521m000) and Where Used Audit Table Fields (ttaud3526m000) sessions, although these
sessions do not specify for which companies the tables and fields are audited.
However, you can also view the net result of the configuration as stored in the audit_cols file, which you can find in the $BSE\lib directory. The information in this file has this format: {audit_cols} ::= {line}*
{line} ::= {tables}:{companies}:{audit_type}
{tables} ::= '*'|{package}[{module}[{table}]]
{companies} ::= '*'|{company}[,{company}]*
{company} ::= (0-9)+(0-9)+(0-9)
{audit_type} ::= 'C'|'A':[{field_name}[{field_name}]*]
The code must be read as follows: The audit_cols file exists of one or more lines. Each line specifies one or more
tables, one or more companies, and the audit type. The tables are specified as '*' or as a package code
(mandatory), a module code (optional), and a table number (optional). If you
specified '*', all tables are selected. If you only specify a package code, all
tables in all modules are selected. If you also specify a module code, but no
table number, all tables in the module are selected. The company must be
specified by a '*', which specifies all companies, or by one or more company
numbers. The audit type is either C or A. Audit type C only logs
transactions if a field is changed. Audit type A logs transactions always, that
is, if any field in the table is changed. Optionally, you can specify one or
more fields. If fields are specified, the audit type only applies to those
fields. If no fields are specified, the audit type applies to all fields in the
table. Note that fields can only be specified if the line did specify only one
table. Example tdsls:*:C
For all tables in this module (tdsls) in all companies (*), all
fields are audited (no fields specified), but only if the field is changed (C).
Note however, that the fields of the primary key are by default always
audited. tdsls400:500:A:col1,col2
For table tdsls400 in company 500, only col1 and col2 are
audited, and they are audited always, that is, for any transaction in this
table. The other fields of this table are not audited, unless another line, for
example, tdsls:*:C , specifies that these tables must be audited.
Notes - To audit a field means that the old and the new value of the
table cell are logged.
- Key fields are always audited, unless they are not specified.
You can only choose not to specify key fields if you define the audit type for
each field. If you define the audit type for an entire table, key fields are
always audited, and you cannot change this setting.
Because the relation between audit type (A or C) and field
specification can be confusing, the following tables display the meaning of
each combination. Each combination is illustrated by a table with two examples.
The abbreviations used are: - C: Column (not specified)
- K: Keyfield (either mandatory, or optionally specified or not
specified)
- R: Record
- A: Audited
- (A): Audited if specified (key field)
- T: Transaction
Possible combinations of audit
type and field specification |
---|
Audit Type | All
Fields | Specified
Fields |
---|
A | 1 | 2 | C | 3 | 4 |
Example 1: Every table cell in the relevant record is audited if any transaction in the table occurs. |
---|
Audit Type A, All
Fields | K | C | C | C | C | C |
---|
R | A | A
T | A | A | A | A | R | A
T | A | A | A | A | A |
Example 2: Only the table cells in the
record concerned in the specified columns are audited if any transaction in the table
occurs |
---|
Audit Type A, Specified
Fields | K | C | C | S | C | S |
---|
R | (A) | | T | A | | A | R | (A) | | | A | | A
T |
Example 3: Every table cell in every column in the table can be audited, but only the table
cell in which a transaction occurs is actually
audited. |
---|
Audit Type C, All
Fields | K | C | C | C | C | C |
---|
R | A | | A
T | | | | R | A | | | | A
T | |
Example 4: Only table cells in the specified column can be audited. A table cell is
audited if a transaction occurs in a specified
column. |
---|
Audit Type C, Specified
Fields | K | C | C | S | C | S |
---|
R | (A) | | T | | | | R | (A) | | | A
T | | |
| |