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 |
When do you specify the isolation level? How?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What is cascading rollback?
What is the difference between drop table and delete table?
How do you pull up a query which was previously saved in qmf?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What is the maximum length of sqlca?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is sqlcode -922 ?