What is auditing?
- 2 Answers
- 4297 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Audit records the SQL statement executed against the table,
the AUTHID and the timestamp. AUDIT ALL records INSERT,
UPDATE, DELETE, SELECT. AUDIT CHANGES records INSERT,
UPDATE, DELETE.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
what is static sql? what is dynamic sql? Give me details
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
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?
i want to delete 20th million record how ?
Why select is not preferred in embedded sql programs?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
wht displays the number of times a query modified ?
how to resolve -818 error. how to see timestamp token in load module and plan
What is with ur in db2?
What is the maximum size of a char data type in db2?
What are bind parameters in db2?
COBOL 
