What is auditing?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum length of sqlca?

871


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7528


What is iseries database?

597


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

724


What is a collection in db2?

584






Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

633


Explain the benefits you can get from mainframe connect?

524


What is meant by explain?

663


What are the various data types available in db2?

638


What are the bind parameters ibm db2?

624


Define declaration generator (dclgen).

669


What are union and union all?

541


How do I add a column in db2?

596


List some fields from sqlca?

615


What is page size in db2?

565