Interested to Buy Any Domain ? << Click Here >> for more details...
What is auditing?
- 2 Answers
- 5139 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 a collection?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How to compare data between two tables in db2?
What is the use of predicate?
What does runstats do in db2?
How to find schema of a table in db2?
What is cursor stability?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is subquery ?
Which catalog table stores referential constraints?
what is the difference between normal select query and currosor
can you use symbolic parameters in JOB?
COBOL 
