Answer / s

Tablespaces are divided into equal-sized units called pages
default is 4KB. Data pages contains the table data.

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

What is the STOSPACE Utility used for?

1 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

How would you find out the total number of rows in a db2 table?

0 Answers  

---

What are the prerogatives?

0 Answers  

---

List down the data types in the db2 database.

0 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  

---

Which transaction use a command thread ?

1 Answers  

---

What is concurrency?

0 Answers  

---

What is query_cache_limit?

0 Answers  

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

Mention and explain the contention situations caused by locks?

1 Answers  

---