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 |
|
37 |
9 |
Char |
Blank (reserved for future) |
|
46 |
1 |
Char |
Environment |
|
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) |
|
Copyright © 2014 CA.
All rights reserved.
|
|