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
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is null in db2?
What is the use of with ur in db2?
How to test SQL -911 error while developing COB-DB2 program
What is cursor in dbms?
What is the maximum size of a char data type in db2?
How do I delete a column in db2?
What are catalog tables in db2?
What is a trigger in the db2 database?
How do I change the column size in db2?
What is difference between isnull and coalesce?
What is buffer pool in the db2 database?
What language is db2 written in?
Which components manage deadlocks in db2?
How does a cursor work?