Enables Auditing for CONNX for ADABAS

AUDIT = 1

 

When auditing is enabled, any query access against one of the configured audit files will result in an audit record being generated and placed into the audit table.
If auditing is enabled the following configuration settings should also be configured:

 

AUDITDBID - the Adabas Database ID that contains the audit file.

AUDITFILECOUNT - the number of files to be audited

AUDITFILEID - the file number of the Audit file

AUDITPASSWORD - the ADASCR password for writing data to the audit file

AUDITFILTER### - where ### is 001 through 999 - the filter specification that will identify which adabas file to be audited, along with the optional key field.

 

The target audit file must have the following format:

 

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)

 

 

Default = 0.

 

Environments: Server

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

 

Unix Environment Variable: AUDIT

VMS Logical: AUDIT

Started Task: AUDIT

CICS:  AUDIT