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
How do you find the maximum value in a column in db2?
What is cursor stability in db2?
Explain how can you do the explain of a dynamic sql statement?
What are db2 objects?
Describe major components of db2?
What is alias in db2?
What are bind parameters in db2?
What is database manager in db2?
Why do we need reorg in db2?
Define predicate?
What is meant by explain?
When reorg is used?
List out the three types of page locks that can be held.
What are the two types of logging in the db2 database? Explain them.
What is iseries database?
