What is auditing?
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 sqlca’s maximum length?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
Explain the EXPLAIN statement?
What is package versioning? Please give an example.
Give some example of statistics collected during RUNSTATS?
Before you give the explain statement, what are the prerogatives?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How can you display the current date & current time ?
What is a DB2 bind?
How to know the primary key of a table without defining the primary key in the table?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?