Answer / renu gupta

DSNC transaction uses the command thread to give command to
Db2

How to check last update on table in db2?

0 Answers  

---

When do you specify the isolation level? How?

1 Answers  

---

Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

Define buffer pool.

0 Answers  

---

can any one expalin check point with an example?

1 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 do you need to do before you do EXPLAIN ?

1 Answers  

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

---

How do you stop a db2 database in linux?

0 Answers  

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---