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
Explain the contention situations caused by locks?
How do I start db2 in windows?
What is a bind card?
How to check sequence on a table in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Explain various types of locks in db2?
What is package in cobol db2?
Is db2 free?
What is a db2 table?
Can we delete records from view?
How can you quickly find out the # of rows updated after an update statement?
What is dclgen in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
List down the types of triggers in the db2 database?
How to find primary key of a table in db2?