What are concurrency issues?

0 Answers  

---

Mention the downsides of page level lock.

0 Answers  

---

How will you return the number of records in table?

0 Answers  

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

How do I start db2 in windows?

0 Answers  

---

What is pagespace?

1 Answers  

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---

What is the function of buffer manager?

1 Answers  

---

What is the result of open cursor statement?

0 Answers  

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

What is catalog database in db2?

0 Answers  

---