What is auditing?

Answers were Sorted based on User's Feedback



What is auditing?..

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

What is auditing?..

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

Post New Answer

More DB2 Interview Questions

What is sqlca’s maximum length?

0 Answers  


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?

1 Answers  


Explain the EXPLAIN statement?

1 Answers  


What is package versioning? Please give an example.

1 Answers  


Give some example of statistics collected during RUNSTATS?

1 Answers  






Before you give the explain statement, what are the prerogatives?

0 Answers  


Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  


My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  


How can you display the current date & current time ?

1 Answers   Cap Gemini,


What is a DB2 bind?

1 Answers   Logica CMG,


How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


Categories