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 does db2 plan contain?
Name the various locking levels available?
What is db2 command?
What is data manager?
What is null indicator in db2?
How do I add a column to an existing table in db2?
Why select is not preferred in embedded sql programs?
What is drop table?
What is explain plan in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is image copy in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is the difference between db2 and oracle?
Can you tell me how can you find out the # of rows updated after an update statement?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference