Explain what are the various isolation levels possible?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  


i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


What do you mean by storage group (stogroup)?

0 Answers  


Compare a subselect to a join?

1 Answers  


Explain in brief how does db2 determine what lock-size to use?

0 Answers  






Is ibm db2 open source?

0 Answers  


What is performance tuning db2?

0 Answers  


how to fetch multiple records without using cursor

14 Answers   HCL,


What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,


How do you run JCL in cobol program

1 Answers   IBM, Syntel,


What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


What's the maximum number of characters that a tablename can have?

3 Answers  


Categories