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
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How to find schema of a table in db2?
What is sqlca’s maximum length?
Mention the different locking levels that are available in db2.
How do I add a column in db2?
What r the comman abends in db2, jcl and cobol???????
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is a db2 tablespace?
What is host variable?
On which levels locks can be applied?
How to check table size in db2 sap?
What is isolation level 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?
How do I delete a column in db2?
What is a Foreign Key?
