Interested to Buy Any Domain ? << Click Here >> for more details...
What is auditing?
- 2 Answers
- 5034 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 happens to a cursor after a commit?
What is cursor?
What is the purpose of the WHENEVER statement?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
What is the difference between spufi and qmf?
How to find the number of rows in db2 tables?
How can you quickly find out the number of rows updated after an update statement?
What are the full forms of spufi and dclgen and why are they used?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
how do you resolve -805?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
Define buffer pool.
COBOL 
