Answer / Suman Shukla

DB2 (Data Base 2) is a relational database management system developed by IBM. The DB2 Optimizer is a crucial component that determines the most efficient way to execute SQL statements, improving query performance.

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

What does db2 plan contain?

1 Answers  

---

What is the syntax for FETCH in DB2 ?

1 Answers   MCN Solutions,

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

Mention the various locks that are available in db2.

1 Answers  

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1 Answers   IBM,

---

What is the syntax for creating a table in the db2 database?

1 Answers  

---

How to find last record before record through SQLRPGLE?

1 Answers   IBM,

---

How does a cursor work?

1 Answers  

---

How can you split a table in to exactly half?

7 Answers   HSBC,

---

What are the four lockable units for DB2?

1 Answers  

---