Answer Posted / 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 |
Post New Answer View All Answers
what is a corelated subquerry?
List down the data types in the db2 database.
What is the difference between drop table and delete table?
How do I start db2 in windows?
What is cursor stability in db2?
Why do we bind in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is a collection in db2?
What is difference between alias and synonym in db2?
Who uses db2?
How to resolve deadlock issue
what is db2 restart?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What does db2 blu stand for?
What is the advantage in De-normalizing tables in DB2?
