Interested to Buy Any Domain ? << Click Here >> for more details...
What is auditing?
- 2 Answers
- 4905 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 |
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
How to resolve -504 sql code in DB2?
Explain what a plan is?
can any one expalin check point with an example?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
List down the types of triggers in the db2 database?
What are the 2 sqlcodes that are returned?
What are the levels of isolation available with DB2V4
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
What is rebind in db2?
What technique is used to retrieve data from more than one table in a single SQL statement?
What will the COMMIT accomplish?
COBOL 
