What is auditing?
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 is the logical entity between plan and Package?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What will happen, while trying to close the closed cursor.
What is innodb buffer pool?
What is precompiler in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What kind of database is db2?
What is the usage of open cursor command?
What is package in db2 mainframe?
Explain the function of data manager.
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process