Specifies the audit file format when auditing is enabled for CONNX for ADABAS

AUDITFORMAT 
 = 1

 

The target audit file has two supported formats - depending on the setting AUDITFORMAT:

If AUDITFORMAT is zero (the default value) then the audit file must have the following structure:

AA - 7,P - Natural timestamp - the time of the audit event

AB - 8.A - UserID - the user identifier

AC - 4,F - The database number for the table that triggered the audit record

AD - 4,F - The file number for the table that triggered the audit record

AE - 4,F - The ISN of the record that triggered the audit.

AF - 100,A - The optional key field from the record that triggered the audit

 

For example, the audit file can be created using the following SQL statement:

create table  AuditFile( AuditTime timestamp NOT NULL, Userid char(8)  NOT NULL, databasenumber integer  NOT NULL, filenumber integer  NOT NULL, ISN integer  NOT NULL, keyfield varchar(100)  NOT NULL)

 

 

If the AUDITFORMAT is 1, then the audit file contains a periodic group and must have the following structure:

1,AA - 7,P - Natural timestamp - the time of the audit event

1,AB - 8.A - UserID - the user identifier

1,AC - 4,F - The database number for the table that triggered the audit record

1,AD - 4,F - The file number for the table that triggered the audit record

1,AE, PE - Periodic group use for audit performance

2,AF - 4,F - The ISN of the record that triggered the audit.

2,AG - 100,A - The optional key field from the record that triggered the audit

 

For example, the audit file can be created using the following SQL statement:

 

Create cluster description adalocal.auditfilenewcluster

FILE NUMBER <your adabas file number> (

create table AuditFileNew(

internalisn seqno(0) not null,

AuditTime timestamp shortname 'AA' NOT NULL  ,

Userid     shortname 'AB' NOT NULL,

databasenumber integer  NOT NULL  shortname 'AC',

filenumber integer  NOT NULL  shortname 'AD',

primary key (internalisn)),

create table  AuditFileNewValueData(

internalisn seqno(0) not null,  

COL_SEQNO_1 SEQNO(1) NOT NULL,

ISN   shortname 'AF' NOT NULL,

keyfield varchar(100)  NOT NULL  shortname 'AG',

foreign key (internalisn) references AuditFileNew,

primary key (internalisn, COL_SEQNO_1))

)

 

AUDITFORMAT = 0 results in a single adabas record for each audit record, which is a simpler format, easier to read, but results in slower performance.

AUDITFORMAT = 1 will store multiple audit records in the periodic group element of a single adabas record.  This results in much better performance, but can make the data a little more difficult to read.

 

 

 

Please see the AUDIT configuration setting for more details.

 

Default = 0.

 

Environments: Server

Configuration Manager: CONNX Settings; Current Key = CONNX/ADABAS; Key Value/Value Name =  AUDITFORMAT

 

Unix Environment Variable: AUDITFORMAT

VMS Logical: AUDITFORMAT

Started Task: AUDITFORMAT

CICS:  AUDITFORMAT