Previous Topic: Diagnostics and CA Datacom/DB Accounting StatisticsNext Topic: Accessing the Online Administrative Functions


CA Dataquery Audit Facility

CA Dataquery provides a facility to audit access to data using Dataquery. The facility uses the CA Datacom/DB LOGDW command to write to the log file an entry containing user and environmental information and the text to the query. The "Audit Facility records only DQL queries.

The " Audit Facility is activated by setting the AUDIT1=parameter in the Dataquery System Options Table (DQOPTLST) to ON.

The logged records can be read using the CA Datacom/DB READRXX facility. The format of the logged records follow.

Note: This is the format of the data which follows the RXX Header documented in the CA Datacom/DB Database and System Administration Guide section Using the Recovery File (RXX) Read Subroutine.

Location

Length

Format

Content

1

4

Binary

Work Area Length

5

32

Char

User ID
Internal Security: Person
External Security: Blank (ID can be obtained from the RXX Header)

37

9

Char

Blank (reserved for future)

46

1

Char

Environment
O = Online
B = Batch

47

15

Char

Query Name

62

39

Char

Blank (reserved for future)

101

2

Binary

Length of the query text that follows

103

7680

Char

Text of the query

7783

218

Char

Blank (reserved for future)