Interested to Buy Any Domain ? << Click Here >> for more details...
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 are union and union all?
Define sqlca.
What is the purpose of rollback and commit?
What is sqlca?
List out the data types available.
Which component is responsible for processing sql statements and selecting access paths?
How and when does the db2 enforces the unique key?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Discuss about db2 bind?
What is runstats db2?
What is a db2 cursor?
Can you tell me how can you find out the # of rows updated after an update statement?
Give the name of some fields form sqlca.
Can we update view in db2?
What are bind parameters in db2?
