What is auditing?
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 |
Explain transactions, commits and rollbacks in DB2.
What is scrollable cursor in db2?
cobol-db2 runjcl please?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What is drop table?
Who uses db2?
Is there any advantage to denormalizing DB2 tables?
What is the difference between group by and order by?
What is a synonym ?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is the difference between plan and package in db2?
What is db2 purescale?