What is auditing?

Answers were Sorted based on User's Feedback



What is auditing?..

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

What is auditing?..

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

Post New Answer

More DB2 Interview Questions

What is the logical entity between plan and Package?

5 Answers  


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.

1 Answers  


What will happen, while trying to close the closed cursor.

1 Answers  


What is innodb buffer pool?

0 Answers  


What is precompiler in db2?

0 Answers  






How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  


What kind of database is db2?

0 Answers  


What is the usage of open cursor command?

0 Answers  


What is package in db2 mainframe?

0 Answers  


Explain the function of data manager.

0 Answers  


how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,


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

2 Answers  


Categories