Interested to Buy Any Domain ? << Click Here >> for more details...
What is auditing?
- 2 Answers
- 5051 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 does one remove entries from the SCT02 table?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What does the sqlcode of -818 pertain to?
Which component is responsible for db2 startup and shutdown?
How do I connect my db2 database to ibm?
How to define the a field which accepts value till 99999.99 in db2
What is iseries database?
What are delete-connected tables?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
wht happens if we close cursor with cursor with hold option?
can we update the table by using cursors can anyone post the query?
COBOL 
