Interested to Buy Any Domain ? << Click Here >> for more details...
What is auditing?
- 2 Answers
- 5038 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Audit records the SQL statement executed against the table,
the AUTHID and the timestamp. AUDIT ALL records INSERT,
UPDATE, DELETE, SELECT. AUDIT CHANGES records INSERT,
UPDATE, DELETE.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mehdee
When we create DB2 table, if we assign the AUDIT option,
then as this tabe being accessed, DB2 will records
information about all those access so that later the DBADM
person will be able to use their Monitoring software and
Analize/Locate the problem in case it was any. But most of
the time we do not assign the AUDIT option unless it is
required, because it will use lots of DB2 resurces as this
DB2 table being used.
| Is This Answer Correct ? | 0 Yes | 0 No |
how can u retrieve the data from null values using applicaion program.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
List down the types of triggers in the db2 database?
What is the purpose of the DSNC transaction ?
what is + sign and -ve sign for sql code ?
pls tell me abt the normalization five types....
Update command
What is lock contention?
what are bind concepts in db2 cobol?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
How can we define a table? How can we apply SEARCH ALL on it ?
How do I copy a table in db2?
COBOL 
