What is auditing?

db2 sql interview questions

Moderator: Moderator Group

Post Reply
User avatar
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

What is auditing?

Post by Krishna » Sun Mar 29, 2009 11:48 pm

What is auditing?

User avatar
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Sun Mar 29, 2009 11:49 pm

Recording SQL statements that access a table. Specified at table creation time or through alter.

Posts: 8
Joined: Sun May 03, 2009 1:24 am

Post by kishore » Fri May 08, 2009 9:19 am

Auditing consists of several objects in DB2. It could consist of creating and dropping several objects, tables, tablespaces, databases, indexes, and also include modifying data (insert / update / delete) in a table.

Debin Jack
Posts: 14
Joined: Sat Jan 22, 2011 12:24 pm

Post by Debin Jack » Wed Mar 30, 2011 2:30 pm

The general definition of an audit is an evaluation of a person, organization, system, process, enterprise, project or product

Posts: 4
Joined: Fri May 11, 2012 9:33 am

Post by brahan » Fri May 11, 2012 9:48 am

The Following Items can be Audited:

a.Authorization Failures
b.GRANT and REvoke operations
c. Create/Alter/Drop Table operations
d.First Select
e.First Update
f. First Binds

AUDIT None means no Auditing.

Posts: 1
Joined: Thu Dec 24, 2015 11:26 am
Location: Chennai

Post by oracletraining » Thu Dec 24, 2015 11:31 am

Auditing refers to a systematic and independent examination of books, accounts, documents and vouchers of an organization to ascertain how far the financial statements present a true and fair view of the concern.


Topic deleted by Admin

Post by academyindia4 » Sat Jan 30, 2016 11:26 pm

<< Content deleted By Admin >>

Post Reply


Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions

Other References
Mainframe Tools and others